Error 3019

Severity

10 (when sent to a client)
18 (when sent to the Adaptive Server error log)

Message text

Unable to write statistics for object %ld in database %ld. Please run update statistics on this table after loading this database or prior to accessing the table in the loaded database.

Explanation

The systabstats system table stores table- and index-level statistics such as page and row counts, empty pages, number of leaf and non-leaf pages in an index, cluster ratios and average length of data and index rows for each object.

Descriptors are in-memory representations of Adaptive Server objects. Table descriptors contain (among other information) current statistics for the table. Adaptive Server periodically flushes these statistics to systabstats so that queries have access to the most current statistics for a table and its indexes. Statistics are flushed to systabstats during:

Error 3019 is raised when Adaptive Server attempts to flush table statistics to systabstats during a database dump, but due to contention for the systabstats row or some other reason, the server is unable to write out the statistics.

Error 3019 is raised with the following states:

State

Meaning

1

Cannot flush statistics during a transaction.

2

Failed attempt to flush statistics to systabstats.

Action

This is not a serious error, but does indicate that the dump does not contain the latest statistics maintained in memory for the table. Consequently, when the dump is loaded, systabstats will not contain the latest statistics.

Resolve the issue by running update statistics for the table after loading the database.

The syntax for update statistics appears in the Reference Manual: Commands.

Versions in which this error is raised

Version 11.9.2 and later