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

Does IBM DataWorks support integration between Object Storage and dashDB?

Does the IBM DataWorks Data Load API support integration between Object Storage and dashDB?
Eduardo Kaufmann-Malaga
  • 31
  • 2
1
vote
2 answers

Database diagnostic information on dashDB

I am trying to load some data into a table in my dashDB database but hit an error message. Can I download db2diag.log from the dashDB console to find out what has happened? com.ibm.db2.jcc.am.SqlNonTransientConnectionException:…
CharlesL
  • 942
  • 5
  • 14
0
votes
1 answer

How do I configure Db2 on Cloud as source in Apache Zeppelin?

I am trying to use my Db2 on Cloud instance hosted on IBM Cloud with an Apache Zeppelin notebook. I tried to follow the JDBC setup instructions, but it resulted in "class not found" error. I used com.ibm.db2:jcc:11.5.8.0 as Maven artifact in the…
data_henrik
  • 16,724
  • 2
  • 28
  • 49
0
votes
0 answers

db2 on cloud rollforward and incremental backup

I want to restore the backup and do roll forward in db2 on cloud.How I can achieve this? I am able to do full backup restore but I want to restore to end of logs.I did't see rollforward option in db2 on cloud
Nagendra C
  • 1
0
votes
1 answer

Db2: How to convert Unix / epoch time to timestamp?

I have a BIGINT value which represents a UNIX timestamp (epoch). How can I convert it to the built-in TIMESTAMP type? As example, I want to turn 1611140400 into the related date and time. TIMESTAMP_FORMAT does not work.
data_henrik
  • 16,724
  • 2
  • 28
  • 49
0
votes
0 answers

Exceeded maximum limit of 5 connections. Connection refused

I want to drop a table in IBM Db2 on cloud but I receive this error: Exceeded maximum limit of 5 connections. Connection refused What should I have to do?
Hoda Baharestani
  • 1
0
votes
0 answers

IBM DB2 On Cloud - Exceeded maximum limit of 5 connections. Connection Refused

I have created a DB2 on the Cloud instance. I ran a few queries via Node-Red DB2 node before encountering the maximum connections exceeded error. I have waited for more than 12 hours but none of the connection has been freed up. I can't view table…
user14941403
  • 1
0
votes
2 answers

Db2 Lite plan on the IBM Cloud table not accessible after ALTER COLUMN performed

I had to perform an ALTER on a table in Db2 on IBM Cloud (DashDb). Thereafter, I tried to ALTER TABLE REFT_BRAND_DIM ALTER COLUMN BRAND_CD SET NOT NULL; Now that table is inaccessible. For example: SELECT * FROM RQG40283.REFT_BRAND_DIM Error…
Steven J. Ponessa
  • 15
  • 5
0
votes
1 answer

DB2 on Cloud. Change the configuration STRING_UNITS to CODEUNITS32

I need some help with my DB2 instance on Cloud. I need execute a command for change system property, for example I need change the configuration STRING_UNITS to CODEUNITS32, but I cant do it using IBM DATA SERVER DRIVER( IBM console). I will to…
Yasser Moreno
  • 9
  • 4
0
votes
1 answer

DashDB Entry Plan sunset and databases lost

I recently noticed that mi dashDB entry plan under a dedicated ibm cloud environment has been sunset. I read an article that said that, but i had not been informed previously, so i lost my two databases (production, and testing). Does anyone know…
Julian Buranits
  • 5
  • 3
0
votes
1 answer

V2/V3 of Db2 Warehouse Rest API

I am currently trying to use the Rest API with a standalone docker image of Db2 Warehouse developer edition. I have downloaded the docker image from the IBM docker hub "https://hub.docker.com/_/ibm-db2-warehouse-dev?tab=resources" After having…
Steph
  • 47
  • 1
  • 8
0
votes
1 answer

I got garbled character with ibm_db@2.6.1 in nodejs project

I am working on a nodejs project. There is company name 'ABC AEROLÍNEAS SA DE CV' in DB2. While using ibm_db@2.6.1 to get the name, it turned into 'ABC AEROL�NEAS SA DE CV' in my nodejs. I tried to verify it by using python with ibm_db 3.0.1 and got…
Oscar
  • 1
  • 3
0
votes
1 answer

DB2 database in Oracle SQL developer with SSL option

Need help to connect DB2 on cloud with Oracle SQL developer. I have configured SQL developer with third party JDBC to other DBs, but not work in DB2 with SSL option. There have no option to set "sslConnection=true" in connection dialog. I have…
Jesse
  • 3,243
  • 1
  • 22
  • 29
0
votes
1 answer

Connection authorization failure occurred. Reason: Invalid GSSAPI server credential. ERRORCODE=-4214, SQLSTATE=28000

I'm looking to connect to a DB2 Warehouse on Cloud (DB2 WoC) Server using JDBC and IBMid/Password, provided IAM is enabled on the database instance. It is enabled on my Db2 WoC server. Here's the piece of code I'm trying to connect (This method is…
Sparker0i
  • 1,787
  • 4
  • 35
  • 60
0
votes
1 answer

Db2 Warehouse: How to connect using SSL with ibm data server driver

While trying to connect to Db2 Warehouse Local from clpplus as below giving an error ```` clpplus -nw db2inst1@WP ```` jcc][t4][2030][11211][4.24.92] A communication error occurred during operations on the connection's underlying socket,…
svdb2
  • 1
  • 1
1 2 3
…
15 16