Progress Logging and Error Reporting

Database Statistics Reference Guide › Package Detail › Progress Logging and Error Reporting

Progress Logging and Error Reporting

Every step that wgn_stats performs is logged to a table called Wgn3StatsState:


Wgn3StatsState table
Column	Datatype	Description
Step	Number	A unique step number indicating the sequence of the step.
Created	Date	The date and time the entry was made.
Statement	Varchar	The actual statement submitted to the RDBMS.
Status	Varchar	The status of the step values STARTED or COMPLETED. If a step fails unexpectedly, the error message and code are written into this column.

Each step that wgn_stats performs has two entries written to this table, one before it starts and the other on completion (or failure). As the date and time is recorded this permits fine-grained tracking of how long each step takes, and where possible performance improvements may be made.

This table is transient in nature; the next time wgn_stats runs, it will remove the table entries from the previous run so the table only ever contains entries for the current (most recent) run.