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.

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).