Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Copy for Db2 13.1.

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

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.

Related topics

Maintaining-the-BMCDICT-table

Common-utility-tables

 

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