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

Using "db2 text search" on db2 on cloud (formerly dashdb)

I need to perform a fuzzy search using db2 on cloud (formerly dashdb). The name of the product I need to use is "Db2 Text Search". Here are the details on the announcement:…
Lina
  • 1
0
votes
1 answer

IBM DB2 Warehouse Developer Edition web console error when connecting to LDAP server

Current DB2 Warehouse Dev Ed Docker image, Windows 10 Docker Desktop 10.09.2, Docker run command appears successful, try to connect to webconsole at localhost:8443. Browser sits there "waiting for localhost" after many minutes get an error…
0
votes
0 answers

How to backup at scheme level on DB2 Warehouse On Cloud?

We are using DB2 Warehouse On Cloud, Flex Performance Plan. By default, daily full online backup and retain last seven backup images are provided by DB2 Warehouse On the Cloud. However, we need a more flexible backup strategy. Besides a full backup,…
0
votes
2 answers

Communication error on creating federated (Data Virtualization) server (target as DB2 on Cloud)

Error while creating a federated server with target server as DB2 on Cloud and federation source as DB2 Warehouse on Cloud Error message (on running second command below): A communication error "104" occurred sending or receiving data from the…
0
votes
2 answers

DASHDB(DB2)/BLUEMIX(IBM CLOUD): Export CSV with custom separator (not comma)

Is there any way to export a CSV from DASHDB/DB2 in BLUEMIX (IBM CLOUD) with another separator than comma? My data if full of commas and this separator is useless for me. Thanks! :)
Álvaro
  • 3
  • 2
0
votes
1 answer

Insert into select statement that sets all other columns to null

I am trying to run this insert into select statement: insert into xyz (select t1.column1, t1.column2 from table1 t1, table2 t2 where t1.column1 = t2.column1) But get the error: "The number of values assigned is not the same as the number of…
hertogkj
  • 13
  • 3
0
votes
1 answer

db2wh docker pull failed

Trying to install Db2wh but not getting the docker pull docker run -d -it --privileged=true --net=host --name=Db2wh -v /mnt/clusterfs:/mnt/bludata0 -v /mnt/clusterfs:/mnt/blumeta0 store/ibmcorp/db2wh_ee:v2.10.0-db2wh-linux What does this…
bracke
  • 1
0
votes
0 answers

Deploying DB2 Warehouse to IBM Cloud with Kubernetes

is there a way to deploy the docker image to our Kubernetes Cluster? I have been trying to add it with the below yaml file. but when I run status it says the environment is not setup. What I basically tried to do is to convert the docker run…
0
votes
1 answer

Why can't I see Connections options in Watson Analytics?

I'm an administrator of a Watson Analytics account. I deal with a huge amount of data that usually comes from a .csv file. The developers of the website where I get the .csv file shared with me a link to a Dash DB with all data, so I could connect…
0
votes
1 answer

Fatal Runtime Error During dashDB Container Deployment

I am trying to deploy dashDB and am following instructions at https://www.ibm.com/support/knowledgecenter/SS6NHC/com.ibm.swg.im.dashdb.doc/admin/linux_deploy.html. Environment: RHEL 7.3 Docker Version: Client: Version: 1.13.1 API version:…
W_Marc
  • 1
  • 2
0
votes
2 answers

Backup of Dashdb on Bluemix - what options available

I tried taking backup of dashdb from bluemix cloud using Data Studio. I am getting this error 'Remote target is unreachable.'. Since this is an admin activity, I assume it should be done on the server. As this is cloud server, I am trying to…
Gana
  • 482
  • 3
  • 11
  • 32
0
votes
2 answers

query giving zero output

the tables i am using are retail_str_sales_detail,retail_store_prod,retail_store Actualy the main query this query is working but it is taking more time to execute so i tried to change that query into more efficient way SELECT…
ROHIT JHA
  • 13
  • 5
0
votes
1 answer

How can I limit the amount of data in my db2 warehouse on cloud entry instance?

I have an entry plan instance of DB2 Warehouse on Cloud that I'm looking to use for development of a streaming application. If I keep the data to <= 1GB, it will cost me $50/month. I'm worried that I could easily fill the database up with 20GB and…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
0 answers

Dedicated bluemix very slow

Since last week, dedicated Bluemix is working very slow and sometimes throws a timeout on conection with dashDB, so i wanted to ask if is it a problem with bluemix in general, or we have an issue with our dashDB? Thanks.
0
votes
0 answers

Access dashDB (or DB2) using ibmdbPy from Python notebook

I have been trying to access dashDB using ibmdbpy from Python. But it always crash when running script by following the guide. Could anyone have solution for…
andy
  • 1
  • 1