- 论坛徽章:
- 0
|
各位前辈,请帮助分析以下问题:
环境:16C48G power 5+ 570 DS8100 AIX 5300-07 db2 V9.5 (no fix)
凌晨1:10通过crontab进行脱机全备份,发现进程hang住,备份不成功,数据库无法使用
$ db2 connect to XXXdb
SQL6036N START or STOP DATABASE MANAGER command is already in progress.
$ db2 force application all
SQL6036N START or STOP DATABASE MANAGER command is already in progress.
后来通过db2_kill+ipclean 重启实例才能使用,请教被hang住的原因!附1:10 db2diag.log 和备份命令。
备份命令
backdb2() {
db2 force application all
db2 terminate
db2stop force
db2start
db2 force application all
db2 terminate
db2 backup db XXXDB to /TDbackup with 4 buffers buffer 1024 compress
}
……
db2diag.log:
2008-09-07-01.10.13.620447+480 I195858988A621 LEVEL: Error
PID : 385846 TID : 1321 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1321 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Automatic Table Maintenance, atmRefreshInfoTable, probe:320
DATA #1 : String, 11 bytes
AutoStats:
DATA #2 : String, 223 bytes
[IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has
terminated your particular request due to an error or, a force interrupt. SQLSTATE=55032
DATA #3 : String, 5 bytes
40003
2008-09-07-01.10.13.657458+480 I195859610A1644 LEVEL: Event
PID : 336472 TID : 1 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0x0FFFFFFFFFFF7A10 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x0FFFFFFFFFFF7A20 : 716C 6C69 622F 6164 6D2F 6462 3273 746F qllib/adm/db2sto
0x0FFFFFFFFFFF7A30 : 7032 004E 4F4D 5347 0046 4F52 4345 0053 p2.NOMSG.FORCE.S
0x0FFFFFFFFFFF7A40 : 4E00 0000 0000 0000 0000 0000 0000 0000 N...............
0x0FFFFFFFFFFF7A50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7A60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7A70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7A80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7A90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7AA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7AB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7AC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7AD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7AE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7AF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF7B00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2008-09-07-01.10.13.686601+480 I195861255A395 LEVEL: Event
PID : 549894 TID : 1 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104
DATA #1 : String, 26 bytes
Force phase is in progress
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFFCC10 : 0000 0000 ....
2008-09-07-01.10.13.687037+480 I195861651A477 LEVEL: Event
PID : 431490 TID : 258 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1000
DATA #1 : String, 47 bytes
[Force]->Number of applications to be forced :
DATA #2 : Hexdump, 4 bytes
0x07000000003FC664 : 0000 0001 ....
2008-09-07-01.10.27.234165+480 I195862129A795 LEVEL: Warning
PID : 385846 TID : 1578 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1578 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup, probe:130
CALLED : DB2 UDB, Health Monitor, hmonBkpGetActiveLogInfo
RETCODE : ZRC=0xFFFFE86C=-6036
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -6036 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLJCMN
sqlerrd : (1) 0x81360012 (2) 0x00000012 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) ( (9) (10) (11)
sqlstate:
2008-09-07-01.10.27.234859+480 I195862925A369 LEVEL: Event
PID : 385846 TID : 1578 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1578 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup, probe:270
STOP : Automatic Backup: evaluation has finished with errors on database XXXDB
2008-09-07-02.59.35.321603+480 I195863295A441 LEVEL: Error
PID : 431490 TID : 2057 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2057 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0x070000000E3FC424 : FFFF E86C ...l
2008-09-07-02.59.35.381775+480 I195863737A441 LEVEL: Error
PID : 431490 TID : 2057 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
EDUID : 2057 EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0x070000000E3FC424 : FFFF E86C
…… |
|