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 CHECK PLUS for DB2 13.1.

BMCDICT table

This section 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. 

Related topics

Command-and-syntax-reference

Examples-of-CHECK-PLUS-jobs

CHECK-command-syntax

SQL-batch-execution-program

Common-utility-tables

 

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