BMCDICT table

The BMCDICT table stores the compression dictionary during load or reorganization processing.

The following table describes the contents of the BMCDICT table:

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

Related topics

Common-utility-tables

Maintaining-the-BMCDICT-table

BMCDICT table considerations

This topic describes important information that you need to know about the BMCDICT table:

  • 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 or reorganizing with REORG PLUS).
  • LOADPLUS inserts rows into the BMCDICT table during the PRELOAD phase and deletes those rows following compression processing in the LOAD phase.
  • REORG PLUS inserts rows into the BMCDICT table during the UNLOAD phase and deletes those rows following compression processing in the RELOAD phase.

 

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