Adding Space If You Cannot Connect to a Server

If you run out of space during an operation and cannot add space because you cannot connect to the server, add space using the CREATE DBSPACE command.

  1. Shut down the server using any of these methods:
    • On any platform, run dbstop.
    • On Windows, click the correct server icon on the Windows task bar to display the SAP Sybase IQ window, then click the Shutdown button.
    • On UNIX, run stop_iq or type q in the window where the server was started.
  2. Restart the engine with the start_iq command.
  3. Connect to the database.
  4. Use the CREATE DBSPACE command to add space.
  5. Re-run the operation that originally failed due to insufficient space.