TBSBP32K—Default 32 KB buffer pool
Use the panel or the TBSBP32K command to specify the name of the buffer pool to be used by:
- Table spaces with 32 KB pages in implicitly created databases
- Table spaces with 32 KB pages that are created explicitly without the BUFFERPOOL clause
Modify panel
DDTAM32 N Modify Default 32K Buffer Pool
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : DEFAULT 32K BUFFERPOOL
Type the new Default 32K Table Space Buffer Pool that you wish to change to. Then Press Enter.
Default 32K Buffer Pool
Buffer Pool Name . . . . . . ______ (BP32K0-BP32K9)
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : DEFAULT 32K BUFFERPOOL
Type the new Default 32K Table Space Buffer Pool that you wish to change to. Then Press Enter.
Default 32K Buffer Pool
Buffer Pool Name . . . . . . ______ (BP32K0-BP32K9)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
value | The buffer pool to use for:
Specify a value of BP32K or a value in the range BP32K1-BP32K9). The Db2 default is BP32K. |
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Buffer Pool Name | DSNTIP1 | TBSBP32K | DSN6SYSP | TBSBP32K |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*