Friday, July 1, 2016

Accessing the CTGINST1 DB2 Instance From the Command Line Processor

When you install IBM Control Desk 7.6 on Windows, you actually have two DB2 instances created - DB2 and CTGINST1. The one with all of the data is CTGINST1, but the one that the system is configured to access is DB2. Luckily, this is easy to fix by changing the environment variable named DB2INSTANCE. After install, it is set to "DB2", and you simply need to change its value to "CTGINST1". You can do this temporarily from the command line or permanently by modifying the environment variables for the user.