Creating very large databases

Attempting to create extremely large Sybase IQ databases on certain Windows configurations may fail with an exception occurring in the module hos_bion.cxx at or near line 182.

If you require a database that exceeds 100 GB, create a database of that size now to see if your system configuration exhibits the problem. If you create a smaller database and later try to add dbspaces, correcting the problem could be more difficult and time consuming.

This problem is intermittent but tends to occur when you have approximately 180GB of open files. Changing the setting of the OS_File_Cache_Buffering database option could trigger the problem. In some cases you might see an INSUFFICIENT_RESOURCES Windows error message.

The best way to avoid this problem is to create on a raw device any databases that may become larger than 180GB.

If you create a very large database on a file system, and either the CREATE DATABASE statement fails as described above or you see the INSUFFICIENT_RESOURCES message, apply Microsoft corrections. The problem is caused by a bug in the Windows kernel. More information is available on the Microsoft support Web site: