Default language.

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

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI LOBMaster for Db2 13.1.

+LOBORPHANS(action,message)

The +LOBORPHANS(action,message) parameter specifies what to do if 

BMC AMI Reorg

 finds a LOB orphan.

Important

(PTF BQU2620 applied) If LOBMaster REPORTONLY detects orphaned LOBs, it will end with:

  • Return code 4 if you have configured or specified +LOBORPHANS(IGNORE) or +LOBORPHANS(ERASE)
  • Return code 8 if you have configured or specified +LOBORPHANS(ABEND)

LOBORPHANS.png

A LOB orphan is an existing and complete LOB that is not referenced by a base table space row. BMC AMI Reorg detects orphans at the end of the base table space read phase.

Important

A LOB can be an orphan regardless of whether it has a LOB index entry. In this case, a message is issued first that it is a missing LOB.

action

ABEND or A

(default) This value tells BMC AMI Reorg to abend the reorganization.

ERASE or E

This value tells BMC AMI Reorg to remove the orphaned LOB entry from the LOB index and the LOB table space.

IGNORE, IGN, or I

This value tells BMC AMI Reorg to leave the orphaned LOB in the LOB table space and complete the reorganization.

Important

The orphaned LOB is not accessible.

message

MESSAGE, MSG, or M

(default) This value tells BMC AMI Reorg to print up to 50 error messages to SYSERROR, followed by messages for the total orphan counts. For a sample report, see Messages-to-the-SYSERROR-DD.

NOMESSAGE, NOMSG, or NOM

This value tells BMC AMI Reorg not to write error messages to SYSERROR.

Example

The following example deletes the orphaned LOBs and issues messages to SYSERROR for each orphan:

+LOBORPHANS(ERASE,MSG)

The +LOBORPHANS(ERASE,MSG) parameter is the equivalent of running the following commands:

  • CHECK INDEX
  • CHECK LOB
  • CHECK DATA ...SCOPE AUXONLY...LOBERROR REPORT
  • (for each orphan found) REPAIR...LOCATE...ROWID...DUMP

Important

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

Related topics

Command and syntax reference

BMC-AMI-LOBMaster-parameters-RRGPARMS-DD 

LOBMISSING-action-message

Reporting-for-BMC-AMI-LOBMaster

Working-with-infrastructure

Running-BMC-AMI-LOBMaster

 

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