shell脚本备份db2数据库解决方法
shell脚本备份db2数据库
在shell脚本里面核心的备份语句就下面两句话
db2 archive log for db tart
db2 backup db tart ONLINE to /home/db2inst1/DB2BakData INCLUDE LOGS
然后就报以下错误:
2012-05-21-08.49.31.398699+480 E633049996G504 LEVEL: Error
PID : 2821 TID : 2169498512 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : tart
APPHDL : 0-4813 APPID: *LOCAL.db2inst1.120521004907
AUTHID : DB2INST1
EDUID : 106 EDUNAME: db2agent (tart) 0
FUNCTION: DB2 UDB, database utilities, sqluhDeletionReport, probe:387
MESSAGE : ADM8509N Unable to delete the database logs "203 - 236" in log chain
"5".
2012-05-21-08.49.31.398894+480 E633050501G519 LEVEL: Error
PID : 2821 TID : 2169498512 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : tart
APPHDL : 0-4813 APPID: *LOCAL.db2inst1.120521004907
AUTHID : DB2INST1
EDUID : 106 EDUNAME: db2agent (tart) 0
FUNCTION: DB2 UDB, database utilities, sqluhPruneHistoryDeleteFile, probe:1071
MESSAGE : ADM8504I Successfully deleted the backup image with timestamp
"20110723030004".
2012-05-21-08.49.31.399112+480 I633051021G734 LEVEL: Error
PID : 2821 TID : 2169498512 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : tart
APPHDL : 0-4813 APPID: *LOCAL.db2inst1.120521004907
AUTHID : DB2INST1
EDUID : 106 EDUNAME: db2agent (tart) 0
FUNCTION: DB2 UDB, database utilities, sqluhDiskDelete, probe:949
MESSAGE : SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed.
在shell脚本里面核心的备份语句就下面两句话
db2 archive log for db tart
db2 backup db tart ONLINE to /home/db2inst1/DB2BakData INCLUDE LOGS
然后就报以下错误:
2012-05-21-08.49.31.398699+480 E633049996G504 LEVEL: Error
PID : 2821 TID : 2169498512 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : tart
APPHDL : 0-4813 APPID: *LOCAL.db2inst1.120521004907
AUTHID : DB2INST1
EDUID : 106 EDUNAME: db2agent (tart) 0
FUNCTION: DB2 UDB, database utilities, sqluhDeletionReport, probe:387
MESSAGE : ADM8509N Unable to delete the database logs "203 - 236" in log chain
"5".
2012-05-21-08.49.31.398894+480 E633050501G519 LEVEL: Error
PID : 2821 TID : 2169498512 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : tart
APPHDL : 0-4813 APPID: *LOCAL.db2inst1.120521004907
AUTHID : DB2INST1
EDUID : 106 EDUNAME: db2agent (tart) 0
FUNCTION: DB2 UDB, database utilities, sqluhPruneHistoryDeleteFile, probe:1071
MESSAGE : ADM8504I Successfully deleted the backup image with timestamp
"20110723030004".
2012-05-21-08.49.31.399112+480 I633051021G734 LEVEL: Error
PID : 2821 TID : 2169498512 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : tart
APPHDL : 0-4813 APPID: *LOCAL.db2inst1.120521004907
AUTHID : DB2INST1
EDUID : 106 EDUNAME: db2agent (tart) 0
FUNCTION: DB2 UDB, database utilities, sqluhDiskDelete, probe:949
MESSAGE : SQL0902C A system error (reason code = "") occurred. Subsequent SQL
statements cannot be processed.