SYSCAT.BUFFERPOOLS catalog view
Each row represents the configuration of a buffer pool on one database partition group of a database, or on all database partitions of a database.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| BPNAME | VARCHAR (128) | Name of the buffer pool. | |
| BUFFERPOOLID | INTEGER | Identifier for the buffer pool. | |
| DBPGNAME | VARCHAR (128) | Y | Name of the database partition group (the null value if the buffer pool exists on all database partitions in the database). |
| NPAGES | INTEGER | Default number of pages in this buffer pool on database partitions in this database partition group. | |
| PAGESIZE | INTEGER | Page size for this buffer pool on database partitions in this database partition group. | |
| ESTORE | INTEGER | Always 'N'. Extended storage no longer applies. | |
| NUMBLOCKPAGES | INTEGER | Number of pages of the buffer pool that are to be in a block-based area. A block-based area of the buffer pool is only used by prefetchers doing a sequential prefetch. | |
| BLOCKSIZE | INTEGER | Number of pages in a block. | |
| NGNAME1 | VARCHAR (128) | Y | Name of the database partition group (the null value if the buffer pool exists on all database partitions in the database). |
Note:
|
|||