DAJ542E Invalid Process NPIs value - Enter Y to always collect statistics for non-partitioning indexes (NPIs); Enter N to not collect statistics for NPIs; Enter A to have exception processing determine whether or not to collect statistics for NPIs

Explanation

An invalid value was entered in the Process NPIs field.

User response

Type A in this field if you want exception processing to determine whether or not to collect statistics for non-partitioning indexes (NPIs) based on the following criteria:
  • Statistics will be collected when all partitions for an object are included in the objects profiles.
  • Statistics will not be collected when only some of the partitions (a subset) are included in the object profiles, such as when there are missing parts for an object. This can occur when:
    • Objects are at the PART level and only a subset of all the partitions are selected in the objects profiles. For example: only parts 2, 5, and 9 are included in the objects profiles.
    • Individual partitions are specifically excluded by using the EXClude indicator in the objects profiles.
Type Y in this field if you want to collect statistics for NPIs regardless of the above criteria. Type N to not collect statistics for NPIs.