DBCC_LOG_PROGRESS Option

ON, OFF

OFF

Option can be set at the database (PUBLIC) or user level. At the database level, the value becomes the default for any new user, but has no impact on existing users. 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