Skip to Content

Default language.

Information
Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

Lock monitors

The monitors listed in the following table measure locking activity.

Monitor

Title

View name

Description, Parameters, Warning

CLM

Claim Requests

DCLM

Reports the number of claim requests during the sampling period (QTXACLNO)

Parameters: none

Error
Warning

DS0770W (nn) hh:mm:ss CLAIM REQUESTS(TOTAL) = v IN x intrvl (>thrshld)

CLMF

Claim Failures

DCLMF

Reports the number of unsuccessful claim requests during the sampling period (QTXACLUN)

Parameters: none

Error
Warning

DS0780W (nn) hh:mm:ss CLAIM FAILURES(TOTAL) = v IN x intrvl (>thrshld)

DRN

Drain Requests

DDRN

Reports the number of drain requests during the sampling period (QTXADRNO)

Parameters: none

Error
Warning

DS0790W (nn) hh:mm:ss DRAIN REQUESTS(TOTAL) = v IN x intrvl (>thrshld)

DRNF

Drain Failures

DDRNF

Reports the number of unsuccessful drain requests during the sampling period (QTXADRUN)

Parameters: none

Error
Warning

DS0800W (nn) hh:mm:ss DRAIN FAILURES(TOTAL) = v IN x intrvl (>thrshld)

GNEG

Negotiate P-Lock

DGNEG

Reports the number of times this DB2 was driven to negotiate a P-Lock or the number of P-Lock change requests (QTGSPPPE, QTGSPGPE, QTGSCHNP, QTGSOTPE)

Parameters: [PGSET|PAGE|CHNG|OTHER]

Error
Warning

DS1440W (nn) hh:mm:ss NEGOTIATE P-LOCK(TOTAL) = v IN x intrvl (>thrshld)

GNOEN

No Engines--P-Lock

DGNOEN

Reports the number of times an engine is not available for a P-Lock exit or a notify exit request (QTGSPEQW)

Parameters: none

Error
Warning

DS1450W (nn) hh:mm:ss NO ENGINES - P-LOCK(TOTAL) = v IN x intrvl (>thrshld)

GNTFM

Notify Messages

DGNTFM

Reports the number of notify messages sent or received (QTGSNTFY, QTGSNTFR)

Parameters: [SENT|RECV]

Error
Warning

DS1480W (nn) hh:mm:ss NOTIFY MESSAGES(TOTAL) = v IN x intrvl (>thrshld)

GPLK

Global P-Lock Requests

DGPLK

Reports the number of P-Lock lock, change, and unlock requests (QTGSLPLK, QTGSCPLK, QTGSUPLK)

Parameters: [LOCK|CHANGE|UNLOCK]

Error
Warning

DS1410W (nn) hh:mm:ss GLOBAL P-LOCK REQ(TOTAL) = v IN x intrvl (>thrshld)

GSUSP

Global Lock Suspensions

DGSUSP

Reports the number of suspends or global lock or change requests denied (QTGSIGLO, QTGSSGLO, QTGSFLSE, QTGSDRTA)

Parameters: [IRLM|XES|FALSE|INCOMPAT]

Error
Warning

DS1430W (nn) hh:mm:ss GLOBAL LOCK SUSPENDS(TOTAL) = v IN x intrvl (>thrshld)

GXES

Global Lock XES Requests

DGXES

Reports the number of both L-Lock and P-Lock lock, change, and unlock requests propagated to z/OS XES synchronously (QTGSLSLM, QTGSCSLM, QTGSUSLM, QTGSKIDS)

Parameters: [LOCK|CHANGE|UNLOCK|ASYNC]

Error
Warning

DS1420W (nn) hh:mm:ss GLOBAL LOCK XES REQ(TOTAL) = v IN x intrvl (>thrshld)

ILREQ

IRLM Request Counts

DILREQ

Reports the number of requests to the IMS resource lock manager during the sampling period by one of the following types:

  • Query
  • Change
  • Other
  • All requests to the IRLM address space

Parameters: [QUERY|CHANGE|OTHER]

Error
Warning

DS0580W (nn) hh:mm:ss IRLM REQUEST COUNTS(TOTAL) = v IN x intrvl (>thrshld)

IXLOK

Index Space Locks

DIXLOK

Reports the number of index space locks during the sampling period

An index space lock can be one of the following types:

  • Shared–Shared index space locks that include SHARE, INTENT SHARE, and SHARE with INTENT EXCLUSIVE
  • Exclusive–Exclusive index space locks that include UPDATE, INTENT EXCLUSIVE, and EXCLUSIVE

If the IXLOK monitor is started without parameters (blank), the reported number is the sum of all index space locks during the sampling period.

Parameters: [SHR|EXCL]

Error
Warning

DS0230W (nn) hh:mm:ss INDEX SPACE LOCK COUNT(parm) = v (>thrshld)

LDEAD

Lock Deadlock Failures

DLDEAD

Reports the number of lock deadlock failures during the sampling period

Parameters: none

Error
Warning

DS0260W (nn) hh:mm:ss LOCK DEADLOCK FAILURES(TOTAL) = v IN intrvl (>thrshld)

LESCL

Lock Escalations

DLESCL

Reports the number of lock escalations during the sampling period

A lock escalation can be one of the following types:

  • Shared–Shared index space locks that include SHARE, INTENT SHARE, and SHARE with INTENT EXCLUSIVE
  • Exclusive–Exclusive index space locks that include UPDATE, INTENT EXCLUSIVE, and EXCLUSIVE

If the LESCL monitor is started without parameters (blank), the reported number is the sum of all lock escalations during the sampling period.

Parameters: [SHR|EXCL]

Error
Warning

DS0290W (nn) hh:mm:ss LOCK ESCALATIONS(parm) = v IN x intrvl (>thrshld)

LREQ

Lock Requests

DLREQ

Reports the number of lock or unlock requests during the sampling period

If the LREQ monitor is started without parameters (blank), the reported number is the sum of all lock and unlock requests during the sampling period.

Parameters: [LOCK|UNLOCK]

Error
Warning

Warning: DS0570W (nn) hh:mm:ss LOCK REQUESTS(TOTAL) = v IN x intrvl (>thrshld)

LSUSP

Suspensions

DLSUSP

Reports the number of lock suspensions during the sampling period by one of the following types:

  • Lock suspensions
  • Latch suspensions
  • Other suspensions
  • All suspensions

Parameters: [LOCK|LATCH|OTHER]

Error
Warning

DS0270W (nn) hh:mm:ss SUSPENSIONS(TOTAL) = v IN x intrvl (>thrshld)

LTIME

Lock Timeout Failures

DLTIME

Reports the number of lock timeout failures during the sampling period

Parameters: none

Error
Warning

DS0280W (nn) hh:mm:ss LOCK TIMEOUT FAILURES(TOTAL) = v IN x intrvl (>thrshld)

MXLOK

Maximum Page Lock Held by User

DMXLOK

Reports the maximum number of locks of any kind (page, row, or table) held by a single user during the sampling period

Parameters: none

Error
Warning

DS0250W (nn) hh:mm:ss MAX PAGE LOCKS(TOTAL) = v (>thrshld)

PGLOK

Page Locks

DPGLOK

Reports the number of page locks during the sampling period

A page lock can be one of the following types:

  • Shared–Shared index space locks that include SHARE, INTENT SHARE, and SHARE with INTENT EXCLUSIVE
  • Exclusive–Exclusive index space locks that include UPDATE, INTENT EXCLUSIVE, and EXCLUSIVE

If the PGLOK monitor is started without parameters (blank), the reported number is the sum of all page locks during the sampling period.

Parameters: [SHR|EXCL]

Error
Warning

DS0240W (nn) hh:mm:ss PAGE LOCK COUNT(parm) = v (>thrshld)

RTLOK

Retained Locks

DRTLOK

Reports the number of retained locks held during the sampling period

Parameters: none

Error
Warning

DS0254W (nn) hh:mm:ss RETAINED LOCK COUNT(parm) = v (>thrshld)

TSLOK

Table Space Locks

DTSLOK

Reports the number of table space locks during the sampling period

A table space lock can be one of the following types:

  • Shared–Shared index space locks that include SHARE, INTENT SHARE, and SHARE with INTENT EXCLUSIVE
  • Exclusive–Exclusive index space locks that include UPDATE, INTENT EXCLUSIVE, and EXCLUSIVE

If the TSLOK monitor is started without parameters (blank), the reported number is the sum of all table space locks during the sampling period.

Parameters: [SHR|EXCL]

Error
Warning

DS0220W (nn) hh:mm:ss TABLESPACE LOCK COUNT(parm) = v (>thrshld)

USLOK

Users Suspended for Locks

DUSLOK

Reports the number of suspended users because of lock conflicts during the sampling period

Lock conflicts are reported by the following attach types:

  • TSO
  • Batch
  • CICS
  • IMS
  • Utility
  • Call Attach Facility
  • Database Access (DDF servers)
  • Distributed Allied Agent (DDF requestors)
  • Both Database Access and Distributed Allied Agent
  • All (blank parameter)

Parameters: [TSO|BATCH|CAF|UTIL|DBAT| DIST|DDF|IMS|CICS|SPAS| RRSAF]

Error
Warning

DS0210W (nn) hh:mm:ss USERS SUSPENDED FOR LOCK(parm) = v (>thrshld)

Related topic

Alphabetical-reference-of-monitors

 

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

MainView for DB2 6.1