DSNB460I   PAGE SET/PARTITION LIST INFORMATION

This message is a section of output from the DISPLAY BUFFERPOOL command, which is part of message DSNB401I.

DSNB460I: Page set and partition list information (for a data-sharing environment)

When you specify the LIST option, the output includes information about page sets and partition lists.

The message output begins with the introductory text PAGE SET/PARTITION LIST INFORMATION. The introductory text is followed by column headers and multiple lines of information.

DSNB460I  @
----------------PAGE SET/PARTITION LIST INFORMATION----------------
                                  --------DATA SHARING INFO--------
                               TS GBP  MEMBER  CASTOUT  USE  P-LOCK
DATABASE SPACE NAME  INST PART IX DEP   NAME    OWNER  COUNT STATE 
======== =========== ==== ==== == === ======== ======= ===== ======

DATABASE

The name of the database. This field is blank when the line provides information about the same database as the preceding line or lines.

SPACE NAME

The name of the table space. This field is blank when the line provides information about the same table space as the preceding line or lines.

INST

The instance number.

PART

One of the following values:

• The partition number.
• For a simple table space or simple index space: a blank.
• For non-partitioned indexes on a partitioned table space: the logical partition number preceded by the character L (for example, L01).

TS IX

The type of object: either TS for table space or IX for index space.

GBP DEP

An indicator of group buffer pool (GBP) dependency. The indicator can be either of the following values:

Y

The page set or partition is GBP-dependent.

N

The page set or partition is not GBP-dependent.

MEMBER NAME

The name of the member that the detail line pertains to.

CASTOUT OWNER

An indicator of whether the member is the castout owner. The indicator can be either of the following values:

Y

The member is the castout owner.

Blank

The member is not the castout owner.

USE COUNT

The number of active claimers or drainers for the page set or partition for the member.

P-LOCK STATE

The P-lock state that the member currently holds. The state can be any of the following values:

IS

R/O interest. Other members have interest in this page set or partition. The page set or partition is GBP-dependent.

IX

R/W interest. Other members have interest in this page set or partition. The page set or partition is GBP-dependent.

S

R/O interest. Other members might be reading the page set or partition. The page set or partition is not GBP-dependent.

SIX

R/W interest. Other members might be reading the page set or partition. The page set or partition is GBP-dependent.

NSU

R/W interest. The page set or partition is GBP-dependent.

X

R/W interest. No other members are accessing the page set or partition. The page set or partition is not GBP-dependent.

US

A temporary state that can be held by a restarting DB2® when "waiting for retained locks" is enabled.

number

A number for use as a diagnostic aid. A number is displayed only when a DISPLAY BUFFERPOOL command encounters an undefined lock state.

If the DISPLAY BUFFERPOOL LIST command finds more than 255 lines of output to display, the output is presented in multiple sections. Each section is a new instance of message DSNB460I with the addition of "(CONTINUED)" in the message heading:

DSNB460I  @ (CONTINUED)

Message DSNB460I is issued in a data-sharing environment. In a non-data-sharing environment, message DSNB464I is issued instead.

If no information is available, message DSNB460I is followed by message DSNB463I.