Stored procedure trace

To obtain an application trace or a diagnostic trace of a Db2 ODBC stored procedure, you need to perform certain steps in the initialization file.

Db2 ODBC stored procedures run in a WLM-established address space. Both the main application that calls the stored procedure (client application), and the stored procedure itself, can be either a Db2 ODBC application or a standard Db2 precompiled application.

More than one address space can not share write access to a single data set. Therefore, you must use the appropriate JCL DD statements to allocate a unique trace data set for each stored procedure address space that uses the Db2 ODBC application trace or diagnostic trace.