SYSUPDATECOUNTERWANTED

Definition

The system table SYSUPDATECOUNTERWANTED displays the tables and indexes for which the statistics counters in the file directory should be initialized.

Structure

SYSUPDATECOUNTERWANTED

SCHEMANAME

CHAR(32)

Name of the schema

TABLENAME

CHAR(32)

Name of the table

INDEXNAME

CHAR(32)

Name of the index

CANCELCOUNT

FIXED(5)

Specifies the number of cancelled attempts to update the statistics for this object

See also:

FILES

Glossary, Run Directory