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.

+LOB

The +LOB parameter specifies whether to include LOB auxiliary table spaces when processing a wildcard list of table spaces.

LOB.png

Related topic

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


NO

(default) Excludes associated LOB auxiliary table spaces

YES

Processes associated LOB auxiliary table spaces

Important

  • The BMC AMI Reorg AUX YES AUX keyword overrides the +LOB parameter. If you specify +LOB(NO) and AUX, the LOB table space will be processed.
  • Specifying LOB AUX TS and +LOB(NO) in BMC AMI Reorg statement is an error and returns as:
    NGTB090W TABLESPACE dbname.lobtsname IS A LOB - PROCESSING SKIPPED FOR TABLESPACE (+LOB).
    NGTR219E TABLESPACE dbname.lobtsname PROCESSING ABORTED.

Important

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

Example
+LOB(YES)

BMC AMI Reorg processes all LOB table spaces when reorganizing the base table space.

 

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