SQL22223N creating database with DB2 Express C for Windows

1.2k Views Asked by At

I am having problems trying to create a database with DB2 Express C (v9.7).

I already have a another version of DB2 installed on my system:

Product: DB2 Connect Enterprise Edition 
Version: 8.2
Copy: DB2COPY1
Instance: DB2

I understand that it is possible to have coexistence.

Express C has seemingly installed OK on my laptop, and I am able to use the Sample Database without a problem. I created new copy DB2COPY2, and new instance DB2_01.

I've installed it as a DB2ADMN.

When I try and create a database I get the error:

SQL22223N The Instance "DB2_01" does not exist on host "host name".

It is saying that the instance does not exist on the host. Which is strange because I installed it locally as a DB2ADMN.

1

There are 1 best solutions below

2
user918176 On

Coexistence is supported. You have to open correct CLP version, and

set db2instance=db2_01
db2cc

and then it should work. If it doesn't you have to probably uncatalog and re-catalog your node and databases.