Adding Space if You Cannot Connect to a Server

If you run out of space during an operation and are unable to 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 Sybase IQ window, and 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. Rerun the operation that originally failed due to insufficient space