DEV Community

Ashwin Sharma P
Ashwin Sharma P

Posted on • Originally published at Medium

SAP Basis snippets #4

#sap #sapbasis #database #sybase

Sybase DB start/stop commands

First switch to the syb<sid> user

su - syb<sid>
Enter fullscreen mode Exit fullscreen mode

Logon to the isql interface

isql -U <username> -P <password -S <SID>
Enter fullscreen mode Exit fullscreen mode

To stop the sybase db, use the below command

shutdown
Enter fullscreen mode Exit fullscreen mode

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

go
Enter fullscreen mode Exit fullscreen mode

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
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

shadiajam profile image

Should We Rethink About IDs? A Deep Dive into "Snowflake IDs"

Shadi AJAM -

suzuki0430 profile image

Avoiding Connection Pinning in Lambda and RDS Proxy with NestJS and Proxy Splitting

Atsushi Suzuki -

alexmercedcoder profile image

Data Modeling - Entities and Events

Alex Merced -

dm8ry profile image

Understanding and Optimizing AWS RDS Performance Using Performance Insights

Dmitry Romanoff -