The following issues affect database startup.
In order for a database to start, all files of IQ_SYSTEM_MAIN, all files of IQ_SYSTEM_TEMP, and the catalog file SYSTEM must be available. A database can be started skipping dbspaces that cannot be fully opened. If any writeable files of IQ main store dbspaces other than IQ_SYSTEM_MAIN or any catalog dbspace files other than SYSTEM cannot be opened on server startup, Sybase IQ logs an error and marks the dbspace dynamically offline (marked offline in memory, as opposed to marking it offline in the catalog). If all files of IQ_SYSTEM_TEMP cannot be opened, the database will not start unless the -iqnotemp startup parameter is used.
Sybase IQ checks the consistency of the commit_id in each dbspace file header against the value in the system tables ISYSDBFILE and ISYSIQDBSPACE and marks any file or dbspace that does not match offline as above.
A dbspace that has been marked offline at start time may be brought online via the ALTER DBSPACE ONLINE statement, assuming that the problem has been corrected and the dbspace can be opened. To correct path problems, you can correct the path of the dbspace file using ALTER DBSPACE dbspace name ALTER FILE logical filename RENAME PATH new pathname.
A table object that resides in an offline dbspace is unavailable. Any DDL or DML request except ALTER DBSPACE ONLINE to any table object in an offline dbspace generates an error. Note that after you make a dbspace offline, there may still be data pages in the buffer cache. In the case of a very small table, the entire table may be in memory in the buffer cache and temporarily available, even if the dbspace is offline.
The server holds database information in memory using pages of a fixed size. Once a server has been started, you cannot load a database that has a larger catalog page size or IQ page size than the server. For this reason, you should always set the catalog page size to its maximum value, 32768 bytes, with the -gp switch.
The -gd server command-line option determines the permission level required to start databases. By default, this option is set to DBA, so that only users with database administrator privileges can start IQ databases. However, you can also set this option to ALL or NONE. ALL means that all users can start a database. NONE means that no users, including the DBA, can start a database.
