SAP On DB2旧摘要

1、之前关闭不了sap应用，关闭不了db2数据，发现应该是归档目录和 log_dir目录盛满的原因，扩大了目录，激活数据库，查看如下：

2、修改了数据的为pending状态
sapprd1:db2lbp 3> db2 rollforward database LBP query status

                             Rollforward Status

Input database alias = LBP
Number of nodes have returned status = 1

Node number = 0
Rollforward status = DB pending
Next log file to be read = S0000117.LOG
Log files processed = -
Last committed transaction = 2011-08-06-06.50.15.000000 UTC

db2 rollforward db sample to end of logs and stop 执行指令之后；

sapprd1:db2lbp 5> db2 rollforward database LBP query status

                             Rollforward Status

Input database alias = LBP
Number of nodes have returned status = 1

Node number = 0
Rollforward status = DB working
Next log file to be read = S0000117.LOG
Log files processed = -
Last committed transaction = 2011-08-07-01.40.09.000000 UTC

3、据说配置了catalog与 远程node 后，db2会容易crash，所以执行以下语句清除。

sapprd1:db2lbp 3> db2 uncatalog node NODELBP
DB20000I The UNCATALOG NODE command completed successfully.

sapprd1:db2lbp 9> db2 uncatalog database LBPL
DB20000I The UNCATALOG DATABASE command completed successfully.