Sybase Error – IQ had insufficient memory to create the buffer cache with the size specified with the Main_Cache_Memory_MB or Temp_Cache_Memory_MB options. Instead, the cache will be created using the default size.

In this blog post, you’ll learn more about the Sybase Error IQ had insufficient memory to create the buffer cache with the size specified with the Main_Cache_Memory_MB or Temp_Cache_Memory_MB options. Instead, the cache will be created using the default size. and the reason for receiving this error

Sybase SQL Error Message

IQ had insufficient memory to create the buffer cache with the size specified with the Main_Cache_Memory_MB or Temp_Cache_Memory_MB options. Instead, the cache will be created using the default size.

Reason for this Error

If we catch an OUTOFMEMORY exception when creating the MAIN or the TEMP buffer cache, we report this warning of our failure and retry to create the cache with the default settings (and NOT the settings in the hos_paramset). This will allow the DBA to re-open a database even if the Main_Cache_Memory_MB or Temp_Cache_Memory_MB options are set so high as to otherwise prevent the re-opening of the database. (QTS 183253.)