Quick Beginnings for DB2 Connect Enterprise Edition

Setting the Current Instance

On OS/2 and Windows 32-bit operating systems:

When you enter commands to start or stop an instance's database manager, DB2 applies the command to the current instance. DB2 determines the current instance as follows:

• Read the setting for the DB2INSTANCE environment variable for the current session. To set the DB2INSTANCE environment variable, enter:

     set db2instance=new_instance_name
  

  where new_instance_name represents the instance that you want to work with.

• If the DB2INSTANCE environment variable is not set for the current session, DB2 uses the setting for the DB2INSTANCE environment variable from the system environment variables:

  • On Windows NT, system environment variables are set in the System Environment. See Setting Your Environment on Windows 32-Bit Operating Systems for instructions on setting DB2INSTANCE.

  • On Windows 95 and Windows 98, system environment variables are set in autoexec.bat or other batch file. See Setting Your Environment on Windows 32-Bit Operating Systems for instructions on setting DB2INSTANCE.

  • On OS/2, system environment variables are set in config.sys or other command file. See Setting Your Environment on OS/2 for instructions on setting DB2INSTANCE.

• If the DB2INSTANCE environment variable is not set at all, DB2 uses the registry value, db2instdef.

  To set the db2instdef registry value globally, enter:

     db2set db2instdef=new_instance_name -g
  

  where new_instance_name represents the instance that you want to be the default for your system.

For more information on setting registry values, refer to Chapter 41. Controlling Your DB2 Environment.

On UNIX Systems:

To use a specific instance, you need to execute the startup script for that instance. Enter the following command:

   . INSTHOME/sqllib/db2profile    (for Bourne or Korn shell)
   source INSTHOME/sqllib/db2cshrc (for C shell)

where INSTHOME is the home directory of the instance.

To determine which instance applies in the current session, enter:

   db2 get instance

[ DB2 List of Books | Search the DB2 Books ]