Contains a row for every buffer pool in every nodegroup.
Table 35. 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 |