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.

+LOBORPHANS(action,message)

The +LOBORPHANS(action,message) parameter specifies what to do if BMC AMI Reorg finds a LOB orphan.

Important

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

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

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.

 

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