SYSCAT.BUFFERPOOLDBPARTITIONS catalog view
Each row represents a combination of a buffer pool and a member, in which the size of the buffer pool on that member is different from its default size for other members in the same database partition group (as represented in SYSCAT.BUFFERPOOLS).
Column Name | Data Type | Nullable | Description |
---|---|---|---|
BUFFERPOOLID | INTEGER | Internal buffer pool identifier. | |
DBPARTITIONNUM | SMALLINT | Member number. | |
NPAGES | INTEGER | Number of pages in this buffer pool on this member. |