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.

+IGNDEFNO

The +IGNDEFNO parameter specifies whether to ignore indexes specified with DEFINE NO and to process other tables in the underlying table space. Use +IGNDEFNO when you have table spaces containing either of the following tables:

  • Tables with DEFINE NO indexes 
  • Tables with DEFER YES indexes 

GUID-56F932AB-7F1E-4FDB-B566-D369B2BF021A-low.png

Related topic

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


YES

Ignores deferred indexes on empty tables and processes the table space for the other tables in the table space

NO

(Default) Does not process table spaces that have deferred indexes

+IGNDEFNO(YES) is familiar with users with packaged software who have table spaces with many empty tables with deferred indexes.

Important

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

Example
+IGNDEFNO(YES)

BMC AMI Reorg processes table spaces that have deferred indexes on empty tables.


 

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