SAP Basis snippets #4

Sybase DB start/stop commands

First switch to the syb<sid> user

su - syb<sid>

Logon to the isql interface

isql -U <username> -P <password -S <SID>

To stop the sybase db, use the below command

shutdown

Execute ‘go’ after ‘shutdown’ command, which completes the execution of the latter.

go

To start the Sybase DB, we run startserver -f RUN_SID.

For this we need to go to the location of the RUN_SID file, which is generally present in /sybase/<SID>/ASE*/install/ path.

Once inside this directory, run the below commands as syb<SID> user

startserver -f RUN_SID

startserver -f RUN_SID_BS