Diagnostic Data Collection — Diagnostic Data Collection allows for a variety of critical information to be saved when certain events, such as lock table overflow, BI threshold, or a system error, occur. Collecting this data can aid in the analysis of the root cause of an event. Almost all aspects of this feature are customizable, including: the events for data collection, the amount of data collected, and the formatting of the data.
PROUTIL IDXCHECK Validate index against free cluster — The Validate index against free cluster option provides a quick, deterministic check of index errors in special schemas (encryption, auditing, and key events).
|
proutil my-dbname -C idxcheck
|
|
Index Check Utility
=================== Select one of the following: -------------------- All (a/A) - Choose all the indexes Some (s/S) - Choose only some of the indexes By Area (r/R) - Choose indexes in selected areas By Schema (c/C) - Choose indexes by schema owners By Table (t/T) - Choose indexes in selected tables -------------------- Validation (o/O) - Change validation options -------------------- Quit (q/Q) Enter your selection: |
|
Validation Options
---------------- * 1 - Validate physical consistency of index blocks * 2 - Validate keys for each record 3 - Validate record for each key * 4 - Validate key order 5 - Validate tree 6 - Validate index against free cluster R - Reset error limit, current: 500 C - Continue to execute Q - Quit |
|
Validate index against free cluster
Index -1610 (PUB._Constraint-Keys, _Con-Key-Ord): Validating the tree. |
If the index is a non-multi-tenant or table-partitioned index:
|
Index (index number)(owner.table, index name): object not found in the area.
|
If the index is a multi-tenant index:
|
Index (index number)(owner.table, index name) for tenant name: object not found in the area.
|
If the index is a table-partitioned index:
|
Index (index number)(owner.table, TP index info): object not found in the area.
|