Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, see BMC AMI Reorg for Db2 13.1.

+PBGKEEPDICT

The +PBGKEEPDICT parameter enables you to stop the compression dictionaries in different partitions from changing during a reorganization. 

Important

This parameter applies only to partition-by-growth (PBG) table spaces. 

Related topic

BMC-AMI-Reorg-parameters-RRGPARMS-DD-RRGPARMX-DD 

PBGKEEPDICT.png

 recommends that you select +PBGKEEPDICT(YES) if you are using a data replication product to replicate identical data objects across partitions ("mirroring").

With all PBG objects, BMC AMI Reorg builds the new compression dictionary for comparison but uses the options in the table to determine whether it is used or not. This parameter interacts with the PBGCHKDICT parameter as described in the following table:

+PBGKEEPDICT and +PBGCHKDICT options

+PBGKEEPDICT

+PBGCHKDICT

Result

NO

NO

BMC AMI Reorg does not check that all partitions have the same compression dictionary and does not build a new compression dictionary, subject to the following exceptions:

  • The table contains short rows.BMC AMI Reorg reports a short row condition in either of the following cases:
    • A column is added to table with a fixed-length row.
    • You have set the ROWFORMAT option to convert the row format.
  • The reorganization involves discard processing.

If all partitions do not have the same compression dictionary, the reorganization fails.

NO

YES

BMC AMI Reorg checks that all partitions have the same compression dictionary and builds a new compression dictionary in either of the following cases:

  • Not all partitions have the same compression dictionary.
  • All partitions have the same compression dictionary, but the new compression dictionary will improve the compression ratio.

YES

NO

BMC AMI Reorg does not check that all partitions have the same compression dictionary and does not replace compression dictionary, subject to the following exceptions:

  • If you have altered a PBG table space to COMPRESS YES and the first partition does not have a compression dictionary, BMC AMI Reorg builds a compression dictionary for all partitions and compresses the table spaces with RC=4. For more information, see Job-completion-and-return-codes.
  • If you have altered a PBG table space to COMPRESS NO, BMC AMI Reorg decompresses the table spaces and removes all compression dictionaries with RC=4.
  • The table contains short rows.BMC AMI Reorg reports a short row condition in either of the following cases:
    • A column is added to table with a fixed length row.
    • You have set the ROWFORMAT option to convert the row format.
  • The reorganization involves discard processing.

If all partitions do not have the same compression dictionary, the reorganization fails.

YES

YES

BMC AMI Reorg acts as if you had selected +PBGKEEPDICT(YES) and +PBGCHKDICT(NO).

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

Example
+PBGKEEPDICT(YES)

BMC AMI Reorg does not check that all partitions have the same compression dictionary and does not build a new compression dictionary, regardless of the setting for the +PBGCHKDICT parameter.

 

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