3.1.13 Retain fenced model processes

Information

The keepfenced parameter indicates whether or not external user-defined functions or stored procedures will reuse a DB2 process after each subsequent call. It is recommended that this parameter be set to NO.

All routines that were executed by the DB2 should be terminated when the instance is stopped.

Solution

Note: this procedure will require a DB2 restart.
1. Attach to the DB2 instance.
db2 => attach to $DB2INSTANCE
2. Run the following command from the DB2 command window:
db2 => update database manager configuration using keepfenced no
3. Restart the DB2 instance.
db2 => db2stop
db2 => db2start
Default Value:
The default value for KEEPFENCED is YES.

See Also

https://workbench.cisecurity.org/files/1654