DBCC_LOG_PROGRESS option

Function

Reports the progress of the sp_iqcheckdb system stored procedure.

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 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.

Examples

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:
IQ_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

See also

Chapter 13, “System Recovery and Database Repair” in the System Administration Guide: Volume 1

“sp_iqcheckdb procedure” in Chapter 7, “System Procedures” in Reference: Building Blocks, Tables, and Procedures