Reports the progress of the sp_iqcheckdb system stored procedure.
Option can be set at the database (PUBLIC) or user level. When set at the database level, the value becomes the default for any new user, but has no impact on existing users. When set at the user level, overrides the PUBLIC value for that user only. No system privilege is required to set option for self. System privilege is required to set at database level or at user level for any user other than self.
Requires the SET ANY PUBLIC OPTION system privilege to set this option. Can be set temporary for an individual connection or for the PUBLIC role. Takes effect immediately.
When DBCC_LOG_PROGRESS is ON, the sp_iqcheckdb system stored procedure sends progress messages to the IQ message file. These messages allow the user to follow the progress of the sp_iqcheckdb operation.
Stored procedures are documented in Reference: Building Blocks, Tables, and Procedures.
Sample progress log output of the command sp_iqcheckdb ‘check database’:
IQ Utility Check Database Start CHECK STATISTICS table: tloansf Start CHECK STATISTICS for field: aqsn_dt Start CHECK STATISTICS processing index: IQ_IDX_T444_C1_FP Start CHECK STATISTICS processing index: tloansf_aqsn_dt_HNG Done CHECK STATISTICS field: aqsn_dt
Sample progress log output of the command sp_iqcheckdb ‘allocation table nation’:
Start ALLOCATION table: nation Start ALLOCATION processing index: nationhg1 Done ALLOCATION table: nation Done ALLOCATION processing index: nationhg1