BMCDICT table


This topic describes the BMCDICT, which stores the compression dictionary during load or reorganization processing:


Column name

Data type

Description

UTILID

CHAR(16)

Utility identifier

DBNAME

CHAR(8)

Database name

TSNAME

CHAR(8)

Table space name

PARTITION

SMALLINT

Partition number

For a nonpartitioned table space, the value is 0.

SEQNO

SMALLINT

Sequence number

DICTDATA

VARCHAR(4000)

Dictionary data

If you are processing a large number of compressed partitions, you might need to increase the size of the BMCDICT table space significantly from the standard size that was allocated during installation. To estimate the allocation, multiply 64 KB by the number of compressed partitions that you are processing concurrently (loading with LOADPLUS and reorganizing with REORG PLUS). LOADPLUS inserts rows into the BMCDICT table during the PRELOAD phase and deletes those rows compression processing in the LOAD phase. 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*