10 (when sent to a client) 18 (when sent to the Adaptive Server error log)
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.
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:
checkpoints
database dumps
housekeeper tasks
update statistics
optdiag runs
sp_flushstats
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. |
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.
Version 11.9.2 and later
