DEFAULT 4-KB BUFFER POOL FOR USER DATA field (TBSBPOOL subsystem parameter)
The TBSBPOOL subsystem parameter specifies the default buffer pool to use for 4 KB page size table spaces that are created implicitly.
| Acceptable values: | Any 4 KB buffer pool names |
|---|---|
| Default: | BP0 |
| Update: | option 21 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP TBSBPOOL |
If
you do not specify a buffer pool name, Db2
uses the TBSBPOOL value as the default buffer pool for 4 KB page size table spaces. Db2 uses the value differently for the following statements:
- CREATE DATABASE
- Db2 uses the TBSBPOOL value.
- CREATE TABLE
- If you do not specify a table space name, Db2 implicitly creates a table space and selects the buffer pool as described in Implicitly defined table spaces.