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

accessing logs for dashdb on bluemix cloud

I am updating a table in dashdb on Bluemix and receiving an error which indicates a possible db issue. Is there a way to look at the db logs for additional information? The errors I get are: com.ibm.db2.jcc.am.BatchUpdateException:…
behemoth18
  • 11
  • 1
1
vote
2 answers

DB2 Warehouse on Cloud Load_jobs filename or path is not valid failure

I have to try to load data to DB2 WoC (formerly dashDB) from IBM Cloud Object Storage (Softlayer) by using /load_jobs API call. Always getting error response: SQL3025N,A parameter specifying a filename or path is not valid.,0,n/a Trying different…
CTiPKA
  • 2,944
  • 1
  • 24
  • 27
1
vote
1 answer

make a query and data frame reactive and refresh it on every 5 minutes

// library(plyr) library(shiny) library(ggplot2) library(scales) library(shinydashboard) library(gridExtra) library(DT) library(ggthemes) library(plotly) library(data.table) library(plotrix) library(shinyjs) library(shinycssloaders) # connection…
ROHIT JHA
  • 33
  • 4
1
vote
2 answers

Connect services DataConnect and DB2 Warehouse on Cloud (former DashDB)

I am working on the migration of a db2 process, which connects to several remotes servers, exports data into our local db, and then manipulates it (insert computed data, calculated times, etc) I have created some activities in DataConnect to…
Juan Ignacio Durante
  • 107
  • 1
  • 12
1
vote
2 answers

loopback odbc_bindings.node Image not found

I'm trying to set up a DashDB datasource on a Loopback project. I am running node -v 6.10.1 & npm -v 3.10.10 I get the following error when trying to initialize a new Dashdb datasource: npm ERR! argv…
bannastre
  • 11
  • 1
1
vote
1 answer

dashDB Local on fedora 25 - error code 130

I tried 30 day trial of dashDB Local. I followed the steps described in the link: https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.doc/admin/linux_deploy.html I did not create a node configuration file because mine is a…
Jihyun
  • 883
  • 5
  • 17
1
vote
0 answers

Node.js appending tables from database using connection.query() getting unwanted rows bug

I am trying to append tables together in my database but for some reason I am getting excess rows when I check the data object I am appending each table to. So here are the tables I have in my database (dashDB): ILI_NAMES = table of table…
Mariane
  • 25
  • 3
1
vote
1 answer

Creating indvidual columns with SQL

I'm new to sql and very novice with this package. SQL is running in Watson DashDB. For the past few hours I've been struggling to find the correct code. The code is trying to accomplish a few things. Create a new view called SENTIMENT Join two…
RileyZ71
  • 25
  • 7
1
vote
1 answer

Direct connection from IBM Cloudant to Tableau

i have a scenario where IBM Cloudant NoSQL DB is used. We're trying to see if there is a way to connect the data directly from Cloudant straight to Tableau to produce some dashboards, but i haven't found success with hooking it up directly. There is…
Warren Lee
  • 31
  • 2
1
vote
1 answer

dashDB service plan was not able to recognise with configuration files provided by IBM MobileFirst 8.0

We are trying to create IBM MobileFirst 8.0 Container for bluemix by following the MobileFirst containers tutorial in :…
Srujan reddy
  • 137
  • 1
  • 16
1
vote
1 answer

Cloudant warehouse, deleted documents are not synced

I went through documentation on Cloudant warehouse but not able to find how are deleted documents synced. My requirement is that, just as in Cloudant replication, I would want documents deleted in Cloudant to also be deleted in dash DB. But I do not…
jeet
  • 629
  • 1
  • 4
  • 15
1
vote
1 answer

Does dashDB supports spatial objects?

I need to know if DashDB supports "spatial objects" and "spatial queries" (i.e. can we store in DashDB points, or areas, or polygons and query those "objects"?). I know that for PostgreSQL, for example, this is supported by installing an add-on…
user7254195
  • 23
  • 3
1
vote
1 answer

Ruby inheritance of class and method in JDBC connection string

I have the following code snippet that generates a JDBC connection string for various databases. In this case, Dash DB and IBM DB2. The following is the structure of the code I use to generate my connection string in DB2. def…
theGreenCabbage
  • 5,197
  • 19
  • 79
  • 169
1
vote
1 answer

ejbTimer feature with DashDB in bluemix

If you choose to use ejbTimer feature with DashDB in Bluemix, you end up with errors. We've analyzed the problem and came up with the analysis that ejbTimer feature creates a set of tables (WLPTASK, WLPPART, WLPPROP) in its create phase. These…
jarkko
  • 76
  • 8
1
vote
1 answer

Rails migration and CREATE UNIQUE INDEX not working on DashDB / DB2

I'm working on Rails 4.2.7 application on IBM Bluemix using Ruby 2.3.0. When I've installed Devise User model migration has been generated, just a standard file, no fancy options. During the deploy the migration is firing up three queries. First one…
Kociamber
  • 1,048
  • 8
  • 16
1 2
3
…
15 16