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.

Using BMC AMI LOBMaster

This topic provides examples of specific tasks that you can perform by using BMC AMI LOBMaster.

Reorganizing a table space with LOB columns

To reorganize a table space, add the AUX keyword to the REORG TABLESPACE statement, as follows:

//SYSIN  DD *
REORG TABLESPACE NWDB.TSWLOB AUX

With the AUX keyword, BMC AMI Reorg reorganizes all associated LOB table spaces while reorganizing the base table space. If the base table space does not have LOB columns defined, BMC AMI Reorg ignores the AUX keyword.

For more information about using the BMC AMI Reorg with BMC AMI LOBMaster for Db2, see Running-BMC-AMI-LOBMaster.

Related topics

BMC-AMI-LOBMaster-command-and-syntax-reference

SYSIN syntax for BMC AMI LOBMaster

BMC-AMI-LOBMaster-DD-statements

BMC-AMI-LOBMaster-parameters-RRGPARMS-DD

Reporting-for-BMC-AMI-LOBMaster

Working-with-infrastructure

Running-BMC-AMI-LOBMaster

LOBORPHANS-action-message

Reorganizing a table space and cleaning up orphaned LOBs

To reorganize a table space, add the AUX keyword to the REORG TABLESPACE statement. To clean up orphaned LOBs, specify +LOBORPHANS(ERASE,MSG) in your RRGPARMS DD. Alternatively, you can configure this value for +LOBORPHANS as the system default.

//RRGPARMS DD *
  +LOBORPHANS(ERASE,MSG)
//SYSIN    DD *
  REORG TABLESPACE NWDB.TSWLOB AUX

If you specify +LOBORPHANS(ERASE,MSG), BMC AMI Reorg performs the equivalent of CHECK LOB, CHECK INDEX, CHECK DATA, and REPAIR to delete the orphans.

For more information about handling orphaned LOBs, see LOBORPHANS-action-message.


 

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