Updating the database manager configuration parameters

You can configure the database manager configuration parameters for your stored procedures and UDFs. The two key database manager configuration parameters are KEEPFENCED and JDK_PATH.

About this task

The database manager configuration parameter KEEPFENCED has the default value YES. When you are developing new routines (stored procedures and UDFs), set the KEEPFENCED parameter to NO. Setting the KEEPFENCED parameter to NO avoids routine process from persisting in the system and ensure that the routine that is running on the system is the current version. You can change the KEEPFENCED parameter back to YES when you deploy the final version of your routine.

For Java™ routines, the JDK_PATH parameter must be set.

Procedure

To change the database manager configuration parameter settings, enter the following command:

   db2 update dbm cfg using parameter value

For example, enter the following command to set the KEEPFENCED parameter to NO:

   db2 update dbm cfg using KEEPFENCED NO

To set the JDK_PATH parameter to the directory /home/db2inst/jdk17, enter the following command:

   db2 update dbm cfg using JDK_PATH /home/db2inst/jdk17

Results

To view the current settings in the database manager configuration parameters, enter the following command:

   db2 get dbm cfg

Note: On Windows operating system, you need to enter the db2 update dbm cfg command in the Db2® command window.