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

pyspark ibmdpy giving ValueError: ('ordinal must be >= 1

I am loading data from netezza into a dataframe and then trying to write to dashdb. I am using ibmdpy to try to load the data into dashdb on bluemix. Ibmdpy requires a pandas dataframe so I convert the spark dataframe to pandas to load into…
webe3
  • 103
  • 1
  • 8
1
vote
1 answer

Error when loading shape files into Bluemix dashDB

I am running into the following error when I am loading my shape files through the DashDB console: My shape files are the following: Would anyone have experience working with DashDB and ran into a similar problem? UPDATE: I downloaded a separate…
ShaunK
  • 1,181
  • 5
  • 22
  • 41
1
vote
2 answers

How to use pandas on spark notebook (data on dashDB) in python

Hello I'm using IBM Bluemix. Here I'm using an Apache Spark notebook and loading data from dashDB I'm trying to provide a visualization and it's not displaying the rows, just the columns. def get_file_content(credentials): from pyspark.sql import…
Saraida
  • 39
  • 7
1
vote
2 answers

Using DashDB as a database (instead of a Data warehouse)

Note: This is not a programming question (at least at the moment). Once I start progressing further would seek assistance from the community on programming questions. Feel free to delete this, if this question is deemed inappropriate. I am trying to…
Manglu
  • 10,744
  • 12
  • 44
  • 57
1
vote
1 answer

IBM Bluemix ibm_db dashDB module 0.0.15 no longer compiles; module upgrade perhaps?

Has there been a recent "ibm_db" for dashDB module upgrade? We have been using the Bluemix node.js and ibm_db module to access dashDB. The module has worked ok but now on 10.5.2016 the module no longer compiles on Bluemix. The version we have been…
Jari
  • 13
  • 2
1
vote
1 answer

node-red redeploy flow using REST from within node-red

I have a node-red flow in bluemix that uses dash-db nodes also. So each time some dash db maintenance or some other reason, this db connection gets lost and all writes fail. When i redeploy, everything is fine again. Bluemix shows only logs of last…
rmvpaps
  • 147
  • 1
  • 9
1
vote
1 answer

Cannot deploy PLSQL package to dashDB on Bluemix

I am new here and this is my first post, so please be kind ;) I have created some tables on a dashDB instance on Bluemix using Infosphere Data Architect. No problem with that. I also loaded some seed data from excel spreadsheets into these tables…
1
vote
1 answer

Cannot connect to dbdash from DataGrip

In DataGrip, I'm using the DB2 (JTOpen) data source/driver and supplying the connection information directly off of the dashdb "connect" tab. When trying to connect to my dashdb, I keep getting the following error: I am using the stock information…
Joseph Idziorek
  • 4,853
  • 6
  • 23
  • 37
1
vote
1 answer

DashDB to MySQL Migration

Does anyone know an efficient way to migrate from DashDB to MySQL ? I have a database schema on DashDB which contains n number of tables and I wanted to migrate to MySQL. The only way I can think of is exporting each table to CSV and then import it…
Rain Man
  • 1,163
  • 2
  • 16
  • 49
1
vote
4 answers

Can't connect to DB2 Driver through Python: SQL1042C

I can't connect to a DB2 remote server using Python. Here is what I've done: Created a virtualenv with Python 2.7.10 (On Mac OS X 10.11.1) installed ibm-db using sudo pip install ibm_db Ran the following code: import ibm_db …
chribsen
  • 6,232
  • 4
  • 26
  • 24
1
vote
2 answers

DashDB ArcGIS Online Integration

Is there a means of integrating the ArcGIS Maps to my BlueMix webapp and integrate it to DashDB? I want to use the Map Layer in my web app and integrate it with DashDB. I understand there is a possibility of integrating dashDB with ArcGIS Desktop.…
1
vote
1 answer

Bluemix dashDB couchDB(?) error

After an attempt to create a new dashDB instance, a distinctly non-Netezza/DB2 error is thrown when trying to "manage" this newly purchased instance. Exception thrown by application class 'org.lightcouch.CouchDbClientBase.executeRequest:-1' …
1
vote
3 answers

PHP Login Form using DashDB

I'm Trying to create a Login form using PHP with the DashDB service from Bluemix, I really dont know whats wrong with this code and I would really appreciate your help! My code is composed of five parts: ConexionDB.php, checklogin.php,…
1
vote
1 answer

dashdb out of memory on Cloudant sync

I got the following error trying to warehouse a 7.7Gb database from Cloudant. How can I resolve this? Exception thrown by application class 'org.apache.wink.server.internal.RequestProcessor.handleRequest:195' javax.servlet.ServletException:…
Raj
  • 544
  • 2
  • 10
1
vote
1 answer

DashDB sync with Cloudant doesn't work

I had a setup to sync data from Cloudant database into DashDB. Initially the setup and processes were working well. I keep the sync processes running after the setup. A few days later, I inserted a record into my Cloudant database, then I were…
nyker
  • 57
  • 4