pl_stack_trace - SQL PL and PL/SQL error stack logging configuration parameter

Starting in Db2® Version 10.5 Fix Pack 7, this parameter determines whether error stack logging is enabled or disabled for SQL PL and PL/SQL routines.

Configuration type
Database
Parameter type
Configurable online
Default [range]
NONE [NONE; ALL; UNHANDLED]

When this SQL PL and PL/SQL error stack logging configuration parameter is set to NONE, error stack logging is disabled; no error stack trace records will be written to the db2diag.log file.

When this parameter is set to ALL, error stack logging is enabled. Error stack trace records will be written to the db2diag.log file each time a new SQL error is detected within an SQL PL or PL/SQL routine.

When this configuration parameter is set to UNHANDLED, error stack logging is enabled. Error stack trace records will be written to the db2diag.log file each time a new SQL error is detected within an SQL PL or PL/SQL routine, but only if the error is not captured by an SQL PL condition handler or PL/SQL exception handler within the SQL routine that is running currently.