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