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