Buffer pool requirements

Due to the large size of tables in InfoSphere® Master Data Management Collaboration Server - Collaborative Edition, 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:
Table 1. Required buffer pools and sizes.
Buffer pool Used by this table space Size
USERSBP USERS Automatic
INDXBP INDX Automatic
BLOBBP BLOB_TBL_DATA Automatic
XML_DATA_BP XML_DATA Automatic
XML_LARGE_BP XML_LARGE_DATA Automatic
XML_INDX_BP XML_INDEX Automatic
ITA_DATA_BP ITA_DATA Automatic
ITA_IX_BP ITA_IX Automatic
ITM_DATA_BP ITM_DATA Automatic
ITM_IX_BP ITM_IX Automatic
ITD_DATA_BP ITD_DATA Automatic
ITD_IX_BP ITD_IX Automatic
ICM_DATA_BP ICM_DATA Automatic
ICM_IX_BP ICM_IX Automatic
LCK_DATA_BP LCK_DATA Automatic
LCK_IX_BP LCK_IX Automatic
TEMPUSRBP user's temporary table space Automatic
TEMPSYSBP system's temporary table space Automatic
IBMDEFAULTBP

SYSCATSPACE

This table space is automatically created when you create the database.

 Automatic
  • The buffer pools ITA_DATA_BP, ITA_IX_BP, ITD_DATA_BP, ITD_IX_BP, ITM_DATA_BP, ITM_IX_BP, LCK_DATA_BP, and LCK_IX_BP are required for InfoSphere Master Data Management Collaboration Server - Collaborative Edition production instances.