How to change default database name BLUDB in IBM Db2 Warehouse on Cloud?

Question

Whenever I create a Db2 service in IBM Cloud, it takes the default database name BLUBDB. I want to change to user specific name like TESTDB?

Why do you need this? There may be other ways to achieve what you want. — mustaccio, Oct 12 '18 at 19:42

score 1 · Answer 1 · answered Oct 12 '18 at 08:58

1

Most of service plans for Db2 Warehouse on Cloud (formerly dashDB), then there is only a single database and the name is preset to BLUDB for simplicity. If you want to have more control, you could go with Db2 Hosted on IBM Cloud.

answered Oct 12 '18 at 08:58

data_henrik

score 1 · Answer 2 · answered Oct 12 '18 at 15:59

1

Alternatively, if you are already locally cataloguing the database you could add an alias.

For example:

db2 catalog tcpip node mynode remote dashdb-myinstance.bluemix.net server 50000
db2 catalog database bludb as testdb at node mynode

answered Oct 12 '18 at 15:59

jackic23

2 Answers2