Skip to Content
Information
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.

+REPORT_DRAIN

The +REPORT_DRAIN parameter allows BMC AMI Reorg to perform any necessary drain processing while generating a REPORTONLY summary report.


Related topics

BMC-AMI-Reorg-parameters-RRGPARMS-DD-RRGPARMX-DD

REORG-INDEX-option-descriptions

REPORT_DRAIN.png

YES

(Default) Allows BMC AMI Reorg to perform drain processing

NO

Prohibits drain processing while generating a REPORTONLY summary report

Any of the following keywords on the REORG statement require drain processing, an error occurs if you run with +REPORT_DRAIN(NO).

  • INDEX
  • INDEXES
  • INDEXSPACE
  • AUX YES
Warning

Important

Running REORG TABLESPACE database.tablespace REPORTONLY RTS can produce a REORG INDEX and fail if you specify +REPORT_DRAIN(NO). A drain occurs if you specify +REPORT_DRAIN(YES).

Warning

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*

BMC AMI Reorg for Db2 13.1