Contains a row for each node in the buffer pool for which the size of the
buffer pool on the node is different from the default size in
SYSCAT.BUFFERPOOLS column NPAGES.
Table 43. SYSCAT.BUFFERPOOLNODES Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
BUFFERPOOLID | INTEGER |
| Internal buffer pool identifier |
NODENUM | SMALLINT |
| Node Number |
NPAGES | INTEGER |
| Number of pages in this buffer pool on this node |