Using the statistics trace for distributed diagnosis

The statistics class 4 can be used to diagnose Distributed Relational Database Architecture™ (DRDA) and distributed two-phase commit exception conditions.

For DRDA, the statistics class 4 trace writes the following records:

  1. IFCID 0191

    This record is written by DDIS when DDIS identifies a DRDA exception condition, or on behalf of either DTM or DRDS when those managers identify a DRDA exception condition.

  2. IFCID 0192

    This record is written by DCRM it identifies a DRDA exception condition.

  3. IFCID 0193

    This record is written by DTM when it identifies a DRDA exception condition.

  4. IFCID 0194

    This record is written by DCRM when it identifies a DRDA exception condition.

  5. IFCID 0195

    This record is written by DRDS when it identifies a DRDA exception condition.

The statistics class 4 trace writes these records for the distributed two-phase commit process: IFCIDs 0203 - 0210 and 0234 - 0238.