start2000
作者start2000·2010-06-07 11:55
系统架构师·ABB

sql1042c when performing a sap db rollforward

字数 6049阅读 3771评论 0赞 0
EDQSV1:/db2/logtmp>ls -l
total 8577416
-rw-r--r--   1 root   system  178171904 Feb 21 12:32 S0000491.LOG
-rw-r--r--   1 db2gcq   dbgcqadm  209723392 Feb 21 12:32 S0000492.LOG
-rw-r--r--   1 db2gcq   dbgcqadm   18997248 Feb 21 12:30 S0000493.LOG
-rw-r--r--   1 db2gcq   dbgcqadm  209723392 Feb 21 13:42 S0000494.LOG
when perform :
db2 "rollforward db edq to END OF LOGS and complete OVERFLOW LOG PATH ('/db2/logtmp/')"
sql1042c an unexpected system error occurred
Db2diag.log:

MESSAGE : ADM1603I  DB2 is invoking the forward phase of the database
          rollforward recovery.
 
2008-02-21-13.38.27.109627+480 I70954A502         LEVEL: Warning
PID     : 303330               TID  : 1           PROC : db2agent (EDQ) 0
INSTANCE: db2edq               NODE : 000         DB   : EDQ
APPHDL  : 0-22                 APPID: *LOCAL.db2edq.080221053824
FUNCTION: DB2 UDB, recovery manager, sqlpForwardRecovery, probe:720
DATA #1 : String, 140 bytes
Invoking database rollforward forward recovery,
lowtranlsn 0000000F5EC5400C in log number 494
minbufflsn 0000000F43E3A5BA in log number 491

2008-02-21-13.38.27.116707+480 I71457A405         LEVEL: Warning
PID     : 303330               TID  : 1           PROC : db2agent (EDQ) 0
INSTANCE: db2edq               NODE : 000         DB   : EDQ
APPHDL  : 0-22                 APPID: *LOCAL.db2edq.080221053824
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 5 agents 36 QSets 144 queues and 64 chunks
 
2008-02-21-13.39.11.908235+480 I71863A420         LEVEL: Error
PID     : 721016               TID  : 1           PROC : db2loggr (EDQ) 0
INSTANCE: db2edq               NODE : 000         DB   : EDQ    
FUNCTION: DB2 UDB, data protection, sqlpgolf, probe:220
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
          DIA8701C Access denied for resource "", operating system return code
          was "".
 
2008-02-21-13.39.11.909380+480 I72284A462         LEVEL: Error
PID     : 721016               TID  : 1           PROC : db2loggr (EDQ) 0
INSTANCE: db2edq               NODE : 000         DB   : EDQ    
FUNCTION: DB2 UDB, data protection, sqlpgolf, probe:220
MESSAGE : Filename :
DATA #1 : Hexdump, 24 bytes
0x0FFFFFFFFFFFD038 : 2F64 6232 2F6C 6F67 746D 702F 5330 3030    /db2/logtmp/S000
0x0FFFFFFFFFFFD048 : 3034 3931 2E4C 4F47                        0491.LOG
2008-02-21-13.39.11.909565+480 I72747A322         LEVEL: Error
PID     : 721016               TID  : 1           PROC : db2loggr (EDQ) 0
INSTANCE: db2edq               NODE : 000         DB   : EDQ    
FUNCTION: DB2 UDB, data protection, sqlpgole, probe:1710
MESSAGE : Error -2079391743 opening database log extent 491:
 
2008-02-21-13.39.11.909687+480 I73070A358         LEVEL: Error
PID     : 721016               TID  : 1           PROC : db2loggr (EDQ) 0
INSTANCE: db2edq               NODE : 000         DB   : EDQ    
FUNCTION: DB2 UDB, recovery manager, sqlpgSwitchFromRedoToUndo, probe:1860
MESSAGE : rc -2079391743 when trying to open log extent 491, index 0 TailIndex
….


EDQSV1:/db2/logtmp>chown db2edq:dbedqadm *
EDQSV1:/db2/logtmp>ls -l
total 8577416
-rw-r--r--   1 db2edq   dbedqadm  178171904 Feb 21 12:32 S0000491.LOG
-rw-r--r--   1 db2edq   dbedqadm  209723392 Feb 21 12:32 S0000492.LOG
-rw-r--r--   1 db2edq   dbedqadm   18997248 Feb 21 12:30 S0000493.LOG
-rw-r--r--   1 db2edq   dbedqadm  209723392 Feb 21 13:42 S0000494.LOG
when perform :
db2 "rollforward db edq to END OF LOGS and complete OVERFLOW LOG PATH ('/db2/logtmp/')"
ok




如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关文章

相关问题

相关资料

X社区推广