Buffer pool requirements
Due to the large size of tables in Product Master, the page size that is used to create the buffer pools is 16 KB and 32 KB.
You must create the buffer pools, and stop and restart the DB2® instance, before you create the table spaces.
The following table lists the buffer pools that are needed for use by table spaces and the size
for each buffer pool:
Size: Automatic
| Buffer pool | Used by this table space |
|---|---|
| USERSBP | USERS |
| INDXBP | INDX |
| BLOBBP | BLOB_TBL_DATA |
| XML_DATA_BP | XML_DATA |
| XML_LARGE_BP | XML_LARGE_DATA |
| XML_INDX_BP | XML_INDEX |
| ITA_DATA_BP | ITA_DATA |
| ITA_IX_BP | ITA_IX |
| ITM_DATA_BP | ITM_DATA |
| ITM_IX_BP | ITM_IX |
| ITD_DATA_BP | ITD_DATA |
| ITD_IX_BP | ITD_IX |
| ICM_DATA_BP | ICM_DATA |
| ICM_IX_BP | ICM_IX |
| LCK_DATA_BP | LCK_DATA |
| LCK_IX_BP | LCK_IX |
| TEMPUSRBP | user's temporary table space |
| TEMPSYSBP | system's temporary table space |
| IBMDEFAULTBP |
SYSCATSPACE This table space is automatically created when you create the database. |
|
|