Enabling Db2 trace
For UIE, activate statistics trace for class 1 and accounting trace for class 1 and 2. Direct the trace output to your SMF data set. If you want to collect package information, activate accounting trace for class 7 and 8, and optionally class 10 to obtain buffer accounting data for packages, including getpage rate. UIE uses only class 2 information for Plans and class 8 information for packages.
Class 1 statistics trace provides system services, database, storage, and accelerator services statistics for your Db2 subsystems. Class 1 accounting trace provides transaction count, response time, CPU time, SQL statement use, and buffer information. Class 2 accounting trace provides in Db2 time for response time and CPU time. UIE uses class 2 for calculations.
You can also activate Db2 trace for specific IFCIDs (Instrumentation Facility Component Identifiers). UIE processes the Db2 trace IFCIDs shown in the following table:
IFCID | SMF record types | Record | Description |
|---|---|---|---|
1 | 100 | System services | Provides system services statistics for each Db2 subsystem |
2 | 100 | Database | Provides database and accelerator services statistics for each Db2 subsystem |
3 | 101 | Accounting | Provides CPU and response time for each transaction |
225 | 100 | Storage | Provides storage statistics value for each Db2 subsystem |
239 | 101 | Package accounting | Provides CPU and response time for each package |