DB2 on Docker :: IBM Data Studio prompts error when creating new database

All we need is an easy explanation of the problem, so here it is.

I’ve followed this simple guide and I was able to install DB2 on Docker.

I now would like to import a sample database to play with.

So I open IBM Data Studio, I right click on the instance > New database… , I fill up with my user name and password but then an error appears:

The system cannot verify the instance that you specified. Either enter
a valid instance name or click on the button next to the Instance name
field and select one from the list.
com.ibm.datatools.adm.explorer.ui.model.InstanceException: An internal
error occurred during: "Verifying instance db2inst1 in system
192.168.1.44.".

DB2 on Docker :: IBM Data Studio prompts error when creating new database

If I expand the error for more details I see:

‘Verifying instance db2inst1 in system 192.168.1.44.’ has encountered
a problem.

An internal error occurred during: "Verifying instance db2inst1 in
system 192.168.1.44.".

An internal error occurred during: "Verifying instance db2inst1 in
system 192.168.1.44.".

com.ibm.db2.das.core.DasMessageIdentifier (initialization failure)

DB2 on Docker :: IBM Data Studio prompts error when creating new database

A dive in the official documentation brings me to this solution but I don’t think that could be the problem.

What intrigues me is the ‘dot’ (.) after the IP address. Could this be the error?

DB2 on Docker :: IBM Data Studio prompts error when creating new database

Or is there any other way to import a sample database from IBM Data Studio?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

The easiest way to create a sample database is to login to the container:

~]$ docker exec -ti mydb2 bash -c "su - db2inst1"

Once inside the container:

[[email protected] ~]$ db2sampl 

Creating database "SAMPLE"...
Connecting to database "SAMPLE"...
Creating tables and data in schema "DB2INST1"...
Creating tables with XML columns and XML data in schema "DB2INST1"...

'db2sampl' processing complete.

[[email protected] ~]$ db2 list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias                       = SAMPLE
Database name                        = SAMPLE
Local database directory             = /database/data
Database release level               = 15.00
Comment                              =
Directory entry type                 = Indirect
Catalog database partition number    = 0
Alternate server hostname            =
Alternate server port number         =

If you don’t want to use the sample database provided via db2sampl, you can create a database as part of the start of the container via -e DBNAME=MYSAMPLE:

docker run -itd --name mydb2 --privileged=true -p 50000:50000 -e LICENSE=accept -e DB2INST1_PASSWORD=whatever  ibmcom/db2 -e DBNAME=MYSAMPLE

Now you can try to connect to that database from data studio, setup your tables and inserting data.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply