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
0
votes
1 answer

Does Watson Analytics has a limit on the number of records it can import from dashDB?

I have a account in IBM Watson Analytics (https://watson.analytics.ibmcloud.com). I also have an account in IBM Public Bluemix. I provisioned a dashDB instance and inserted 10,000 records into a dashDB table. In Bluemix dashDB, I verified (via SQLs…
Aditya Dutta
  • 55
  • 2
0
votes
1 answer

dashDB: insert into generated default column using select

I have a simple test table CREATE TABLE TEST ( KEY INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), INTENTS VARCHAR(255), NO_FOUND SMALLINT ); I am then trying to insert data into this table using the following…
timd
  • 376
  • 1
  • 8
0
votes
1 answer

dashDB query node: Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0964C The transaction log for the database is full. SQLSTATE=57011

I am using nodeRed and DashDB and now when I am perfomring some inserts on database I am getting the following message on debug for nodered: dashDB query node: Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0964C The transaction log for the database is…
Eduardo Diogo Garcia
  • 41
  • 7
0
votes
1 answer

How to pass a null value received on msg.req.query to msg.payload

I am developing an application using Dashdb on Bluemix and nodered, my PHP application uses the call to webservice to invoke the node-red, whenever my function on PHP invokes the node to insert on table and the field GEO_ID is null, the application…
Eduardo Diogo Garcia
  • 41
  • 7
0
votes
2 answers

Why is loading dashDB analytics by trickle feed a bad idea?

I have a use case where I continuously need to trickle feed data into dashDB, however I have been informed that this is not optimal for dashDB. Why is this not optimal? Is there a workaround?
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

Using PHP to connect to dashdb in bluemix

This is the code that I have so far. I've checked the credentials a million times, so I know they're correct. I'm not sure what's going wrong. Could someone please help me out? Thanks in advance!
Jon Yahr
  • 1
0
votes
3 answers

how to get the table DDL in dashDB console?

I have created a table in dashDB from a CSV file using the console load functionality. How can I get the table DDL using only the dashDB console?
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
0 answers

What is the backup cycle of BlueMix platform and who to contact if data recovery is needed?

Our client running their apps in bluemix public platform. They need to know when do the backup cycle happens in bluemix. Also in case something happened and they need to recover who they need to contact to?
Suvoraj Biswas
  • 573
  • 1
  • 6
  • 10
0
votes
2 answers

pip install ibmdbpy gives syntax error exec nested function

I am trying to pip install ibmdbpy and I am getting the following syntax error: # pip install --pre ibmdbpy Downloading/unpacking ibmdbpy Downloading ibmdbpy-0.1.0b26-py2.py3-none-any.whl (153kB): 153kB downloaded Requirement already satisfied (use…
webe3
  • 103
  • 1
  • 8
0
votes
1 answer

How do you connect to an external dashDB instance from within Node-Red?

From my Bluemix dashDB instance I can set up connections to external dashDB instance(s) that are also in Bluemix. However, when creating a Node-Red service, I can only connect to the internal/local dashDB service. I cannot locate a generic UI to…
wzanine
  • 1
  • 1
0
votes
1 answer

Bluemix Embedded reporting Service - Unable to connect DashDB

I am trying to connect the Bluemix embedded reporting service to DashDB. After creating the package (specifying credentials for DashDB) when I create a new report definition, and select SQL query, it throws the following error... will be great if…
Sunny
  • 1
0
votes
1 answer

Issue in Cloudant to Dash DB sync on bluemix: Documents lost in transit

Few documents have just vanished in sync between Cloudant to Dash DB. On Cloudant side, the count of messages in main & overflow table is different than the actual count in dash db tables. Any clue how to find those documents?
jeet
  • 629
  • 1
  • 4
  • 15
0
votes
1 answer

Bluemix DashDB not working

My DashDB is not working. When I try to open it, it shows me the error: "The server refused the connection." What could be wrong? Is it a problem with bluemix or there's something wrong with my network settings? Help!
Abhishek Gupta
  • 77
  • 1
  • 2
  • 9
0
votes
2 answers

I need to connect IBM dashDB on Bluemix with another DB2 database in corporate network to get regular feed

I have created tables in dashDB on IBM Bluemix and populated those tables with data. Now I need to connect my cloud-based dashDB with the respective feeding DB2 system (V9.7) which sits behind a corporate firewall. How can I establish the connection…
Venkat
  • 1
0
votes
2 answers

how to query disk used / available on dashDB

I would like to programmatically query the disk space used and remaining space. How can I do this in dashDB? In oracle, I could perform something like this: column dummy noprint column pct_used format 999.9 heading "%|Used" column …
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
1 2 3
…
15 16