DEFAULT BUFFER POOL FOR USER INDEXES field (IDXBPOOL subsystem parameter)
The IDXBPOOL subsystem parameter identifies the default buffer pool that is to be used for indexes on user data.
Db2 uses the IDXBPOOL value if a value for INDEXBP is not specified on a CREATE DATABASE statement. Db2 does not use this value for a CREATE INDEX statement without the BUFFERPOOL option. In that case, Db2 uses the default index buffer pool for the database.
| Acceptable values: | Any 4-KB, 8-KB, 16-KB, or 32-KB buffer pool names |
|---|---|
| Default: | BP0 |
| Update: | option 21 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP IDXBPOOL |