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

An internal error has occurred. The application may still be initializing or the URL used is invalid

When I try opening the dashDB console from Bluemix, I occasionally get the following error message: An internal error has occurred. The application may still be initializing or the URL used is invalid. Check the URL and try again. For more…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

How can I tell if my SDP process is still running the 'initial' load?

You cannot run any sql statements on a DashDB that result in locks that will conflict with the schema discovery process (SDP) during the initial load. See here for more information: SQLCODE=-911 : "warehouser_error_message": "File…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

SQLCODE=-911 : "warehouser_error_message": "File <>.csv.zip could not be loaded due to an exception in dashDB

The Cloudant Schema Discovery Process (SDP) is reporting the following error message while loading my dashDB database: "warehouser_error_message": "File xxxxxx/xxxxxx_nnnn_nnn_n_n.csv.zip could not be loaded due to an exception in dashDB. Reason:…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

dashDB: how to create a TIMESTAMP from an ISO 8601 date?

I have a VARCHAR field storing an iso 8601 date as follows: 2015-01-13T23:17:00 I would like to convert the date into a TIMESTAMP. It seems that I have to strip out the 'T' to use the TIMESTAMP_FORMAT function: SELECT T.F1, T.F2, …
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

How to set auto_sampling on in dashdb

I setup a dashdb trial. I want to turn on AUTO_SAMPLING but the default userid does not have the admin authority to do this. So how do I get this done?
data_guy
  • 1
-1
votes
2 answers

What is the optimal way in DB2 to delete rows from a table and a subselect?

Database Db2 Scenario I have the following code, where on a NODE table I have about 135k rows and a NODE_LIST common table that has about 4k rows, and deleting all the rows from NODE that can be found in NODE_LIST takes about 48 seconds. I would…
H. Trujillo
  • 427
  • 1
  • 8
  • 21
-1
votes
1 answer

dashDB: An unexpected token "IF" was found following " ". Expected tokens may include: "". SQLSTATE=42601

I am trying to pass following query to dashdb: IF (NOT EXISTS (SELECT * FROM TEST_CONFIGURATION WHERE DEVICEID = 'OZ_POLLUDRON_010')) BEGIN INSERT INTO TEST_CONFIGURATION (DEVICEID, DEVICETYPE, SERIAL, TYPE, MACID, CONFIG, INIT)…
Freddy
  • 2,216
  • 3
  • 31
  • 34
-1
votes
2 answers

Liberty for Java app on Bluemix throws SQLNonTransientException

My Liberty for Java app is throwing the following exception when I attempt to connect with the dashDB Service on Bluemix: [err] SQLException informationjava.sql.SQLNonTransientException: [jcc][t4][2030][11211][4.8.86] A communication error…
Tarasankar
  • 1
-1
votes
1 answer

how to install IBM dashdb ODBC driver for Windows 10 and connecting that to SPSS Modeler

I'm trying to connect to dashDB through my SPSS Modeler stream with the database source node, but I'm at a total loss as to how to do it. I downloaded the DB2® v11.1 IBM Data Server Driver Package, but I don't know what to do next. Help, pls!
user2880990
  • 29
  • 1
  • 4
-1
votes
1 answer

Materialized views in DasbDB

Does 'DashDB for Transactions' support Materialized Views? DB2 has the concept of MQT (materialized query table), but not sure if DashDb for Transactions supports the same thing, since both use the same core DB2 engine.
Narendra Naidu
  • 403
  • 2
  • 5
  • 17
-1
votes
2 answers

How do I establish a connection to dashDB from IDA?

I'm trying to generate a physical data model on Bluemix using InfoSphere Data Architect running on my local machine. I have a dashDB service up and running and know all the connection settings. I can't seem to set up a connection from IDA to my…
Nik Molley
  • 1
-1
votes
1 answer

DashDB Local Docker Deployment

I have been able to deploy DashDB local (SMP) locally on my mac (using Kite) 3-4 months ago, but recently I am not able to successfully deploy either SMP or MPP using MacOS (Kite) or Linux (on AWS using individual instances with docker running - not…
Austin Rutherford
  • 1
  • 1
-1
votes
1 answer

GROUP BY clause failing mysteriously in IBM dashDB

Theoretically, I should be able to run a GROUP BY clause in dashDB's SQL syntax. This works: SELECT MESSAGE_BODY, MESSAGE_RETWEET_COUNT FROM COOLSCHEMA.DRIL_TWEETS ORDER BY MESSAGE_RETWEET_COUNT DESC LIMIT 100; However, this does not: SELECT…
huertanix
  • 761
  • 1
  • 9
  • 22
-1
votes
1 answer

Add column from one dataframe to another

I have a dataframe that I want to add a column to from another data frame. The following code "works": GOT_TOTALS$PERCENTAGE <- totals GOT_TOTALS When I print GOT_TOTALS I get my dataframe with the new column "totals". But I can't do anything with…
Saraida
  • 39
  • 7
-1
votes
1 answer

Fail to install R packages in DashDB/RStudio/Bluemix : wget: command not found

I am trying to install rjson, httpuv packages in RStudio in dashDB with following command: install.packages(c("rjson", "httpuv")) I got the following message: sh: wget: command not found Warning in install.packages : download had nonzero exit…
user3655007
  • 3
  • 1
1 2 3
…
15
16