Start of change

DSNB815I   PAGE P-LOCK LOCK/UNLOCK, REQUESTS FOR SPACE MAP = nn REQUESTS FOR DATA PAGES = nn REQUESTS FOR INDEX LEAF = nn UNLOCK REQUESTS = 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
End of change