MATRIX report
This is a sample SUMMARY report from an NGTDISP MATRIX. It shows when Db2 objects have a shared or exclusive lock within
BMC AMI Utilities
. It also shows which UID is holding or waiting for that lock. For information about producing this report, see NGTDISP-command.
You can use the BMC AMI Utilities matrix to prevent two BMC AMI Utilities from processing the same object at the same time. This BMC AMI Utilities lock does not affect Db2 or other non-BMC AMI Utilities object processing.
10/05/12 06:18:57 SUMMARY PAGE 1
DATABASE OBJECT OBJECT LOCK LOCK
NAME NAME PART TYPE TYPE STATUS UTILITY-ID JOBNAME JOB # TIMESTAMP
-------- -------- ----- ------ --------- --------- ----------- -------- -------- --------------------
CDB1DSU2 TSRSPTV2 TS EXCLUSIVE HOLDING JOBF6244 JOBF6244 JOB46834 2012-09-25-16.44.16
CDB1DSU2 IRSPTV20 IX EXCLUSIVE HOLDING JOBF6244 JOBF6244 JOB46834 2012-09-25-16.44.16
CDB1DSU2 IRSPTV21 IX EXCLUSIVE HOLDING JOBF6244 JOBF6244 JOB46834 2012-09-25-16.44.16
CDBDB01 TSMC35IX 1 TS SHARED HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.44
CDBDB01 TSMC35IX 2 TS SHARED HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.44
CDBDB01 TSMC35IX 3 TS SHARED HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.44
CDBDB01 IMC35I01 1 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
CDBDB01 IMC35I01 2 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
CDBDB01 IMC35I01 3 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
CDBDB01 IMC35I02 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
CDBDB01 IMC35I03 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
DATABASE OBJECT OBJECT LOCK LOCK
NAME NAME PART TYPE TYPE STATUS UTILITY-ID JOBNAME JOB # TIMESTAMP
-------- -------- ----- ------ --------- --------- ----------- -------- -------- --------------------
CDB1DSU2 TSRSPTV2 TS EXCLUSIVE HOLDING JOBF6244 JOBF6244 JOB46834 2012-09-25-16.44.16
CDB1DSU2 IRSPTV20 IX EXCLUSIVE HOLDING JOBF6244 JOBF6244 JOB46834 2012-09-25-16.44.16
CDB1DSU2 IRSPTV21 IX EXCLUSIVE HOLDING JOBF6244 JOBF6244 JOB46834 2012-09-25-16.44.16
CDBDB01 TSMC35IX 1 TS SHARED HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.44
CDBDB01 TSMC35IX 2 TS SHARED HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.44
CDBDB01 TSMC35IX 3 TS SHARED HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.44
CDBDB01 IMC35I01 1 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
CDBDB01 IMC35I01 2 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
CDBDB01 IMC35I01 3 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
CDBDB01 IMC35I02 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
CDBDB01 IMC35I03 IX EXCLUSIVE HOLDING RBXTEST REORGIDX JOB40314 2012-09-10-11.58.43
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*