IDXBPOOL—Default index buffer pool
Use the Modify Default Index Buffer Pool panel or the IDXBPOOL command to specify the default buffer pool to be used for indexes. You can use this element to ensure that newly-created indexes that are installed by applications or users default to specific index buffer pools.
Modify Default Index Buffer Pool panel
Command ===> _______________________________________________________________
Command: CURRENT
Description . . . . . . . . : DEFAULT INDEX BUFFER POOL
Type the new Default Index Buffer Pool that you wish to change to. Then pressEnter.
Default Index Buffer Pool
Buffer Pool Name . . . . . . ____ (BP0 - BP49)
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). |
bpID | Buffer pool ID of the buffer pool to be used for indexes. Specify a value in the range BP0–BP49. |
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 | IDXBPOOL | DSN6SYSP | IDXBPOOL |