Enabling trace for stored procedures

You can enable tracing for text search administration stored procedures by specifying the appropriate instrumentation facility component identifier (IFCID) in the START TRACE and MODIFY TRACE commands.

Procedure

To enable tracing:

Specify the appropriate IFCID for the type of trace that you want to enable.
Option Description
For data trace: Specify IFCID 345.
For verbose function trace: Specify IFCID 344.

Example

For example, if you choose generalized trace facility (GTF) as the trace destination and need to trace the IFCID 345 for the SYSPROC.SYSIBMTS_UPDATE stored procedure, you can complete the following steps:

  1. Start GTF as described in Recording GTF trace data.
  2. Run the following Db2® command:
    -START TRACE(MON) DEST(GTF) IFCID(345)
  3. Call the SYSPROC.SYSIBMTS_UPDATE stored procedure.
  4. Run the following Db2 command:
    -STOP TRACE(MON) DEST(GTF)
  5. Stop GTF by using the command P GTF.

Unless you specify otherwise, the trace data is written into the dataset SYS1.TRACE. This dataset might be requested by IBM® Support for problem determination.