SYSCAT.BUFFERPOOLEXCEPTIONS 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 SYSBUFFERPOOLS).

Table 1. SYSCAT.BUFFERPOOLEXCEPTIONS Catalog View
Column Name Data Type Nullable Description
BUFFERPOOLID INTEGER   Internal buffer pool identifier.
MEMBER SMALLINT   Member number.
NPAGES INTEGER   The number of pages in this buffer pool on this member.