Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

BMCDICT table

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

The following table describes the contents of the BMCDICT table.


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.

Was this page helpful? Yes No Submitting... Thank you

Comments