Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
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:
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.
+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.