Shut Down/Bring Up Adaptive Server in Single-User Mode

  1. At a Sybase bin directory prompt, invoke isql:

    isql -Usa -P  << EOF
    

  2. Shut down the server. Use the with nowait option to avoid misleading error messages. At the isql prompt, enter:

    1> shutdown with nowait
    2> go
    

  3. Start the server in single user mode. Refer to “How to Start Adaptive Server in Single-User Mode”.

  4. If the sort order is changing, the server rebuilds some indexes and shuts down again. In this case, simply repeat step 3.