Stack Overflow
Stack Overflow

Questions tagged [dashdb]

IBM Db2 Warehouse on Cloud (formally known as IBM dashDB) is a fully managed data warehousing service in the cloud.

For more information on IBM Db2 Warehouse on Cloud (formally known as IBM dashDB), visit here.

For more information on IBM Db2 Warehouse (formally known as IBM dashDB local), visit here.

226 questions
1
vote
2 answers

Is there a REST api of DashDB to export the content of a database in json format?

I need to re-create a database from a DashDB Bluemix service into another. And I need to automate this procedure in bash scripts. The best I can think of is a DashDB REST API that allows me to export the content of the entire database into json…
michele crudele
  • 73
  • 3
1
vote
3 answers

SQL add count column based on same table and grouped by another column

I appreciate this is a bit weird but I need to do this this way because the next data reporting steps relay on data in this specific format. Let say I have a table like: ID | Type | Item ---------------------- 1 | red | apple 2 | red …
Mike Pala
  • 766
  • 1
  • 11
  • 39
1
vote
1 answer

dashdb: connection error SQLSTATE=08001

I am running Node.js application with dashDB as the back end. I a using ibm_db node package as driver for connecting to dashDB. Node.js and dashDB are deployed in IBM Bluemix. I am not using connection pool option provided by ibm_db package. We have…
Devaraj Kommineni
  • 71
  • 1
  • 6
1
vote
0 answers

Creating BUFFERPOOL in Bluemix dashDB

I have an application that makes a connection to the dashDB, but prior to the application creating tables the application needs to create an 8K BUFFERPOOL. This fails with a permission error indicating the BUFFERPOOL cannot be created. Error: SQL…
DavidW
  • 120
  • 5
1
vote
2 answers

Push data from dashDB to Watson Analytics using DataWorks?

I have an account in IBM Public Bluemix. I provisioned a dashDB instance and have inserted data into a dashDB table. I login to Bluemix using my IBM ID (not IBM Intranet ID) I also have a Watson Analytics account. Please note that my Watson…
Aditya Dutta
  • 55
  • 2
1
vote
0 answers

Dash DB support for timestamp with time zone

I want to store timestamp with time zone in dashdb. I see that db2 supports data type TIMESTAMP WITH TIME ZONE for this purpose. But when I am trying to create table in dash db using this type, I am getting below error. Is this because dash db just…
jeet
  • 629
  • 1
  • 4
  • 15
1
vote
1 answer

Deploying R Shiny App on Bluemix using dashDB

I'm hoping someone can help with deploying an R Shiny application built on dashDB on Bluemix. I have built a Shiny application that currently runs on my local machine. However, I now want to host this app on Bluemix using the dashDB service to store…
Matt14
  • 11
  • 1
1
vote
0 answers

Connecting to DashDB with WAMP and PHP 7 on Windows

I have a website built with Zend Framework, ran by Wamp32 and PHP 7 on Windows 10, connected to a MySQL database. I am now trying to add a connection to DashDB. I have downloaded the PECL files from here, installed them in the ext directory of PHP…
malrok44
  • 592
  • 6
  • 17
1
vote
3 answers

RODBC connection to dashDB using R studio

When trying to set up a connection to dashDB from the rstudio ide on DSX I get this error: [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver Manager]Data source name not found, and no default driver specified This is after filling out…
Saraida
  • 39
  • 7
1
vote
1 answer

What are backup possibilities for DashDB with Bluemix?

We have an application on Bluemix that connects to a DashDB database. I could not find any mention of backup in the graphical interface. Is it possible possible to get a full backup? Does the service support backup automatically? Any links to…
John
  • 4,786
  • 8
  • 35
  • 44
1
vote
1 answer

How can I connect to DashDB with Slick?

I have a Scala Play application running on Bluemix. We decided to try DashDB (we were on DB2 before). The application uses the freeslick plugin for connection to DB2 which worked fine. It also seems to partly work (SELECT queries work, UPDATE not)…
John
  • 4,786
  • 8
  • 35
  • 44
1
vote
3 answers

IBM Cloud dashDB Timezone

The IBM Cloud (former Bluemix) dashDB service uses UTC as timezone. You cannot change that setting as far as I know. My data is from a different timezone. How do I either set the timezone for my data (table or column) or structure/format my data…
DC Martin
  • 41
  • 6
1
vote
1 answer

Installing package in R Console in IBM Bluemix

I am not able to install packages in R console in dashDB from IBM Bluemix. I am executing the below line: install.packages('tm') I am getting this error: Installing package into ‘/usr/lib64/R/library’ (as ‘lib’ is unspecified) Warning in…
Ram Kumar V
  • 103
  • 3
  • 8
1
vote
2 answers

Bluemix- Connect dashDB to PHP application

I have seen this very helpful post Questions and tried to follow the steps it outlined. However I am new to this so I think I may have messed up somewhere. I tried to tailor the code on the webpage which was created to log someone in to my…
Jessica Napolitano
  • 43
  • 2
  • 8
1
vote
1 answer

Difference between dashDB for Analytics and dashDB for Transactions?

DashDB has plans that are listed as "transactional" or "for transactions". Under the hood, what is the difference between dashDB for Analytics and dashDB for Transactions? Are there limitations to either one?
SilentSteel
  • 2,344
  • 1
  • 28
  • 28
1 2 3
…
15 16