DSNB816I PAGE P-LOCK SUSPENSIONS/NEGOTIATIONS, SUSPENSIONS FOR SPACE MAP = nn P-LOCK SUSPENSIONS FOR DATA = nn P-LOCK SUSPENSIONS FOR INDEX LEAF = nn NEGOTIATIONS FOR SPACE MAP = nn P-LOCK NEGOTIATIONS FOR DATA PAGES = nn NEGITIATIONS FOR INDEX LEAF PAGES = nn
Explanation
This message is a section of output from the DISPLAY GROUPBUFFERPOOL command, which is part of message DSNB750I.
DSNB815I and DSNB816I: P-lock status
The DISPLAY GROUPBUFFERPOOL command output includes the physical lock (P-lock) status for the group buffer pool. This P-lock information can be useful when you are monitoring and tuning database performance, especially in a data sharing environment.
DSNB815I - PAGE P-LOCK LOCK/UNLOCK,
REQUESTS FOR SPACE MAP = nn
REQUESTS FOR DATA PAGES = nn
REQUESTS FOR INDEX LEAF = nn
UNLOCK REQUESTS = nn
DSNB816I - PAGE P-LOCK SUSPENSIONS/NEGOTIATIONS,
SUSPENSIONS FOR SPACE MAP = nn
P-LOCK SUSPENSIONS FOR DATA = nn
P-LOCK SUSPENSIONS FOR INDEX LEAF = nn
NEGOTIATIONS FOR SPACE MAP = nn
P-LOCK NEGOTIATIONS FOR DATA PAGES = nn
NEGITIATIONS FOR INDEX LEAF PAGES = nn