SAP MaxDB Notes

Connect to remote DB

dbmcli -d <SID> -n <server name> -u <username>,<password>

Switch to log overwrite mode

dbmcli> db_execute set log auto overwrite on

Switch to a different user while logged in

dbmcli> user_logon <user name>,<password>

Run SQL

dbmcli> sql_execute <command>

Check status

dbmcli> db_state -v

SAP note on XUSER mechanism

39439 - XUSER entries for SAP MaxDB
Recreate DBM user:
xuser -U c -u CONTROL,<password> -d <SID> -n <server> -S INTERNAL set

SAP URL Shortcuts

Go to http://<server>:<port>/urlapi_app_manager

Create new Application ID

Go to http://<server>:<port>/sap/url/go/<app ID>