Installation and Configuration Supplement

Configuring Stored Procedure Builder on AIX and Solaris

In order to run Stored Procedure Builder on AIX or Solaris, you need to ensure that you have a Java Development Kit (JDK) installed on your system. DB2 installs a Java Run-Time Environment (JRE) on your system which can be used for the Control Center, however, it will not allow you to use Stored Procedure Builder.

Once you have installed your JDK, you need to ensure that DB2 is aware of location of the JDK by setting its path in the instance's database manager configuration file. To set the JDK's path, perform the following steps:

1. Log on to the system as a user with SYSADM authority. For more information, see Working with the System Administrative Group.
2. Update the database manager configuration file by entering the following command:

   	db2 update dbm cfg using jdk11_path /usr/java
   

   where /usr/java represents the JDK installation path.

3. Once you update an instance's database manager configuration file, you must stop and restart the instance for the changes to take affect. To stop and start the database manager for the current instance, enter the following commands:

      db2stop
      db2start