When I installed DB2 express 9.5 on my Windows XP pro, it automatically created a default DB2 instance, a user named db2admin with the password I specified and then a DB2ADMNS group. The DB2 install added the db2admin user to the DB2ADMNS group. Everything went well and the install finished.
But unfortunately, I was logged in using my corporate domain id and when launching DB2 Control Center, I could not see the default instance or the databases. I could not perform any database create operations as wel.This id was also a part of the local administrators group.
After digging around Google for a while, I came across several steps that must be performed in order to get this working successfully.
- Go to the Services panel and change the DB2 services running under .db2admin id to run under the domain id. Stop and restart these services. Some of the services include
- DB2 – DB2COPY1 – DB2
- DB2 Remote command server (DB2COPY1)
- DB2DAS – DB2DAS00
- Add the domain id to the local DB2ADMNS group
- Open up the DB2 command line processor window and type quit to come out of CLP.
- The type the following command in
db2set DB2_GRP_LOOKUP=LOCAL,TOKENLOCAL
UPDATE DBM CFG USING SYSADM_GROUP DB2ADMNS
UPDATE DBM CFG USING SYSCTRL_GROUP DB2ADMNS
- Stop and restart the DB2 services again.
- If necessary stop and restart windows.
Try to open DB2 control center to see if you can see everything and create databases.