Reports the progress of the sp_iqcheckdb system stored procedure.
Can be set for an individual connection or the PUBLIC group. Takes effect at the next execution of sp_iqcheckdb.
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 ALLCOATION processing index: nationhg1