Troubleshooting
Problem
I have multiple instances on my Windows machine. When I go to the CLP I am able to attach to the instances and run 'db2 list db directory' and see the databases. When I go to Control Center I am not able to view any of the non-default instances or databases.
Resolving The Problem
To resolve this issue you need to manually add the other instances and databases in Control Center.
- Open Control Center and expand the "All System" folder.
- You should see the ipaddress or hostname of your Windows box.
- Right click the "Instances" folder and choose "Add". Fill out the information, making sure to include the proper port number for this particular instance (it will be different than your default instance as each instance listens on a separate port, check \etc\services to verify).
- If you are unsure of what to enter in a field, place your mouse over the field and a description will be displayed describing what you should enter.
- After you have successfully added the instance, expand the instance, and you will see a "Database" folder.
- Right click on the database folder, choose "Add", and fill out the information.
- Go to the top menu in Control Center and choose Selected --> Refresh. You should now see the non-default instances and databases listed in Control Center.
Related Information
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DBAdmin - Control Center","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21427846