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).

Table 1. SYSCAT.BUFFERPOOLDBPARTITIONS Catalog View
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.