SAP MaxDB日常维护
1、检查MaxDB状态,并启动
su - pe0csc
cd /sapdb/SDB/db/bin
./dbmcli -d SDB -u superdba,Mypassword db_state
OK
State
ONLINE
MaxDB启动
./dbmcli -d SDB -u superdba,Mypassword db_online
2、启动xs_server
su - sdb
/sapdb/SDB/db/bin/x_server -S 7210 start
3、启动apache
su -
apachectl start
4、验证,健康监控
http://10.12.61.16:1090/ContentServer/ContentServer.dll?serverInfo
serverType="SAP HTTP Content Server";serverVendorId="SAP AG";serverPatch="1";serverStatus="running";serverDate="2019-09-12";serverTime="09:20:25";
startUpDate="2007-02-28";startUpTime="03:26:20";lastAccessDate="2019-09-10";lastAccessTime="08:18:53";contRep="Z_REP_DMS_PE0";contRepStatus="running";
关闭
1、关闭apache
su - sapcs
apachectl stop
2、关闭 xs_server
su - sdb
/sapdb/programs/bin/x_server -S 7210 stop
3、关闭MaxDB
su - sqdgcs
dbmcli -d gcs -u superdba,Mypassword db_offline