Skip to Content
Information
Limited support BMC 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 .

SQL create thread index report (BSQLIX)

The following figure shows a sample of the SQL create thread index report (BSQLIX).

Warning

Note

This report is based on IFCID 73.

1                       BSQLIX  : SQL CREATE THREAD INDEX                                12/12/14 09:31:27    PAGE     1

   GROUP : DSNDGR              DGR                            SQL SUMMARY                            DB2 SUBSYSTEM: DGR1 10.
   MEMBER: DGR1                                                                                      DB2 LOCATION : DGR

    CREATE THREAD END TIME    CONNECT   CORRELATION   PRIMAUTH  ORIGAUTH  PLANNAME  REQUESTER         LUWID / ACE ADDRESS
    ------------------------  --------  ------------  --------  --------  --------  ----------------  ------------------------------
 +  07/22/13 14:38:44.472148  RRSAF     DMRQA-CORRID  RDHJMB    RDHJMB    DGRRRS01                    USBMCN01.DGR1LU.CBB2FF25951B
                                                                                                      317C4950
 +  07/22/13 15:19:04.555903  DB2CALL   BARTMBS1      RDHJMB2   RDHJMB2   DMRSEL01                    USBMCN01.DGR1LU.CBB30829B102
                                                                                                      317C6180
 +  07/23/13 10:50:47.620404  RRSAF     DMRQA-CORRID  RDHJMB    RDHJMB    DGRRRS01                    USBMCN01.DGR1LU.CBB40E0FEBDC
                                                                                                      3D695C20
 +  07/23/13 11:04:40.775299  RRSAF     DMRQA-CORRID  RDHJMB    RDHJMB    DGRRRS01                    USBMCN01.DGR1LU.CBB4112A7AD0
                                                                                                      3D695970
 +  08/15/13 16:22:16.845312  RRSAF     DMR-CORR16    DMRQA16   DMRQA16   DMRQAW16                    USBMCN01.DGR1LU.CBD1430D499A
                                                                                                      257DD470
 +  08/15/13 16:22:16.869641  RRSAF     DMR-CORR16    DMRQA16   DMRQA16   DMRQAW02                    USBMCN01.DGR1LU.CBD1430D6059
                                                                                                      257DD470
 +  08/15/13 16:25:49.300052  RRSAF     DMR-CORR09    DMRQA09   DMRQA09   DMRQAW09                    USBMCN01.DGR1LU.CBD143D7F92B
                                                                                                      257DD470
 +  08/15/13 16:25:49.314340  RRSAF     DMR-CORR09    DMRQA09   DMRQA09   DMRQAW01                    USBMCN01.DGR1LU.CBD143D7FAF4
                                                                                                      257DD470
 +  08/15/13 16:26:04.711728  RRSAF     DMR-CORR04    DMRQA04   DMRQA04   DMRQAW04                    USBMCN01.DGR1LU.CBD143E6AC15
                                                                                                      257DCF10
 +  08/15/13 16:26:20.206812  RRSAF     DMRQA-CORRID  RDHJMB3   RDHJMB3   DGRRRS01                    USBMCN01.DGR1LU.CBD143F57416
                                                                                                      257DCF10

Related topic

SQL-activity-reports

 

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

BMC AMI Ops Monitor for Db2 12.2