Default language.

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 Utility Manager for Db2 13.1.

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.

Important

You can also view similar information in the BMCSYNC-report.

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


Related topic

 

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