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 Copy for Db2 13.1.

NACTIVE


The NACTIVE option allows you to specify that you want 

BMC AMI Copy

 to update and collect statistics for only the NACTIVE column of SYSIBM.SYSTABLESPACE.

The NACTIVE option allows you to specify that you want BMC AMI Copy to update and collect statistics for only the NACTIVE column of SYSIBM.SYSTABLESPACE. This is done in combination with the production of image copies. The following rules apply to NACTIVE:

  • NACTIVE is ignored if you specify RUNSTATS YES.
  • NACTIVE is valid for full, DSNUM ALL copies only; otherwise, BMC AMI Copy issues an error.
  • NACTIVE is ignored for indexes and also if the copy is passed to the IBM Db2 COPY utility.
  • NACTIVE is not valid for DSNDB06.SYSCOPY or any spaces in DSNDB01.
  • NACTIVE is not valid for spaces in REORP status.
  • NACTIVE is ignored for Instant Snapshots.

To calculate NACTIVE statistics, BMC AMI Copy uses the number of pages copied, which may or may not match the value calculated by RUNSTATS.

Important

BMC AMI Recovery Manager uses the NACTIVE statistics for optimization.

Values of NACTIVE

Value

Description

NACTIVE NO

(Default) NACTIVE NO indicates that no NACTIVE column statistics should be updated or gathered by BMC AMI Copy.

Important

NACTIVE NO is ignored if you specify RUNSTATS YES UPDATE ALL.

NACTIVE YES

NACTIVE YES causes BMC AMI Copy to update and gather statistics on the NACTIVE column. NACTIVE statistics are reported in SYSPRINT. Using NACTIVE YES uses less CPU time than collecting all statistics if only this statistic is needed.




 

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