Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Sample reports

The requested reports are printed after the last Report Disposition Summary.

These reports are printed in the order in which they were requested in the REPORT statements.

The Data Collector provides a set of reports that has been specifically designed with batch reporting in mind. These reports are 132 columns wide, and their format has been designed to be easy to read.

Note

Data Collector reports are printed in mixed case (uppercase and lowercase) by default. If your printer does not support lowercase letters, you need to specify Y in the field labeled Print in upper case only on the Presentation Options panel of the User Profile.

The following figure is an example of an Accounting Short Trace report.

BACCTST : ACCOUNTING SHORT TRACE                                 05/15/06 15:36:20    PAGE     1             

      LOCATION: DHS                                     ACCOUNTING SHORT TRACE                GROUP: DSNDHS   MEMBER: DHS2          
     SUBSYSTEM: DHS2 8.1                                                                ACTUAL FROM: 05/15/06 10:25:22.04           

   PRIMAUTH CONNECT                                                                                                                 
   ORIGAUTH CORRELATION  ACCOUNTING TIMESTAMP     COMMIT    OPEN  UPDATE   INSERT ELAPSED(CL1) ELAPSED(CL2) GETPAGE SYNC RD LK SUSP
   PLANNAME THREAD TYPE  TERMINATION CONDITION    SELECT   FETCH  DELETE  PREPARE CPU    (CL1) CPU    (CL2) BUF UPD PREFTCH LOCKOUT
   -------- ------------ ----------------------- ------- ------- ------- -------- ------------ ------------ ------- ------- -------
   RDHAUS   TSO                                                                                                                     
   RDHAUS   RDHAUS       05/15/06 10:25:22.04          1       1       0        0 00:00.726808 00:00.726725      38      22       0
   DSNESPCS ALLIED       NORMAL DEALLOCATION           0       1       0        1 00:00.009846 00:00.009764       0       2       0

         PROGRAM NAME        TYPE     SQLSTMT  CL7 ELAP TIME    CL7 CPU TIME   CL 8 SUSP TIME  CL8 SUSP          1                  
         DSNESM68            PACKAGE        5   00:00.726700    00:00.009754         0.444275        30                             
   RDHAUS   TSO                                                                                                                     
   RDHAUS   RDHAUS       05/15/06 10:25:25.75          2       3       0        0 00:00.518386 00:00.401590     833      13       0
   DSNESPCS ALLIED       NORMAL DEALLOCATION           0     212       0        3 00:00.049258 00:00.028643       0      52       0

         PROGRAM NAME        TYPE     SQLSTMT  CL7 ELAP TIME    CL7 CPU TIME   CL 8 SUSP TIME  CL8 SUSP          1                  
         DSNESM68            PACKAGE      224   00:00.401583    00:00.028637         0.364820        64                             
   RDHAUS   TSO                                                                                                                     
RDHAUS   RDHAUS       05/15/06 10:25:37.20          5      28       0        0 00:02.540512 00:01.686082    2707      47       2
DSNESPCS ALLIED       NORMAL DEALLOCATION           0    7662       0       31 00:00.329843 00:00.192208       0     133       0

      PROGRAM NAME        TYPE     SQLSTMT  CL7 ELAP TIME    CL7 CPU TIME   CL 8 SUSP TIME  CL8 SUSP          1                  
      DSNESM68            PACKAGE     7783   00:01.686075    00:00.192203         1.458596       137                             
RDHAUS   TSO                                                                                                                     
RDHAUS   RDHAUS       05/15/06 13:47:10.80          2       3       0        0 3:21:20.5055 00:00.021953     833       0       0
DSNESPCS ALLIED       NORMAL DEALLOCATION           0     212       0        3 00:00.040641 00:00.018262       0      50       0

      PROGRAM NAME        TYPE     SQLSTMT  CL7 ELAP TIME    CL7 CPU TIME   CL 8 SUSP TIME  CL8 SUSP          1                  
      DSNESM68            PACKAGE      224   00:00.021947    00:00.018257         0.001109        12

This section contains the following topics:

Related topic

Data-Collector-report-output

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*