DBCC_LOG_PROGRESS option

Reports the progress of the sp_iqcheckdb system stored procedure.

ON, OFF

OFF

Can be set for an individual connection or the PUBLIC group. Takes effect at the next execution of sp_iqcheckdb.

When the DBCC_LOG_PROGRESS option 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.

The following is 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:
ASIQ_IDX_T444_C1_FP
Start CHECK STATISTICS processing index: 
tloansf_aqsn_dt_HNG
Done CHECK STATISTICS field: aqsn_dt

The following is 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