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.