SQL Reference

SYSCAT.BUFFERPOOLS

Contains a row for every buffer pool in every nodegroup.

Table 44. SYSCAT.BUFFERPOOLS Catalog View
Column Name Data Type Nullable Description
BPNAME VARCHAR(18)
Name of buffer pool
BUFFERPOOLID INTEGER
Internal buffer pool identifier
NGNAME VARCHAR(18) Yes Nodegroup name (NULL if the buffer pool exists on all nodes in the database)
NPAGES INTEGER
Number of pages in the buffer pool
PAGESIZE INTEGER
Pagesize for this buffer pool
ESTORE CHAR(1)

N = This buffer pool does not use extended storage.

Y = This buffer pool uses extended storage.



[ Top of Page | Previous Page | Next Page ]