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:
- Start GTF as described in Recording GTF trace data.
- Run the following Db2® command:
-START TRACE(MON) DEST(GTF) IFCID(345) - Call the SYSPROC.SYSIBMTS_UPDATE stored procedure.
- Run the following Db2 command:
-STOP TRACE(MON) DEST(GTF) - 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.