NACTIVE


The NACTIVE option allows you to specify that you want

Some content is unavailable due to permissions.

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

The NACTIVE option allows you to specify that you want

Some content is unavailable due to permissions.

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,

    Some content is unavailable due to permissions.

    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,

Some content is unavailable due to permissions.

uses the number of pages copied, which might or might not match the value calculated by RUNSTATS.

Important

Some content is unavailable due to permissions.

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

Some content is unavailable due to permissions.

.

Important

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

NACTIVE YES

NACTIVE YES causes

Some content is unavailable due to permissions.

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*