SQL Reference

SYSCAT.BUFFERPOOLNODES

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


[ Top of Page | Previous Page | Next Page ]