SAP Basis snippets #3

Start/Stop commands for MaxDB

First switch to the sqd<sid> user.

su - sqd<sid>

Then logon to database manager command line interface

dbmcli -d <SID> -u <username>,<password>

Once logged in to dbmcli using your details, execute the below commands.

Stop command 👇

db_offline

Start command 👇

db_online

Check db state 👇

db_state