DBCC_LOG_PROGRESS Option

Allowed Values

ON, OFF

Default

OFF

Scope

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

Description

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.

Examples

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