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:
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 |
|