Controls the percent of the cache used by the sp_iqcheckdb system stored procedure.
0 to 100
Can be set for an individual connection or the PUBLIC group. Takes effect at the next execution of sp_iqcheckdb.
50
The sp_iqcheckdb system stored procedure works with a fixed number of buffers, as determined by this option. A large percentage of the cache is reserved by default, to maximize sp_iqcheckdb performance.
“Resource issues running sp_iqcheckdb” in Chapter 2, “System Recovery and Database Repair” of the Sybase IQ Troubleshooting and Error Messages Guide
Chapter 2, “System Recovery and Database Repair” in the Sybase IQ Troubleshooting and Error Messages Guide
“sp_iqcheckdb procedure” in the Sybase IQ Reference Manual
