NACTIVE
- NACTIVE is ignored if you specify RUNSTATS YES.
- NACTIVE is valid for full, DSNUM ALL copies only; otherwise,
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,
uses the number of pages copied, which might or might not match the value calculated by RUNSTATS.
Values of NACTIVE
Value | Description |
---|---|
NACTIVE NO | (Default) NACTIVE NO indicates that no NACTIVE column statistics should be updated or gathered by . |
NACTIVE YES | NACTIVE YES causes 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*