论坛 › DB2 › db2stop force 挂起问题求助！

zou_hope 发表于 2007-07-03 18:46

db2stop force 挂起问题求助！

环境：db2+tsm+AIX+HACMP+online备份和日志存档.
         采用logretain=on做TSM在线备份，不是出口程序。
      
问题：
   DB2stop force挂起。通过分析db2log.log，基本确认问题原因。DB2有15个active log 在此时关闭，需要向TSM存档，大约需要20分钟。db2stop等待5分钟后就会失效挂起，导致DB2实例无法停止。
    我可以在运行db2stop force前，运行achive log命令解决这个问题。
    但在双机环境下，如果主机连接的网卡全部故障，需要切换到备机。为保证主机DB2能够关闭，并切换到备机。需要HACMP脚本里加入achive log命令并等待（sleep)20分钟.但双机切换需要20分钟以上是不能接受的。
   
请高手帮忙，不胜感谢！

zou_hope 发表于 2007-07-03 19:57

我的分析可能并不正确,补上db2diag.log. 大概12点执行db2stop force挂1起, 1点db2_kill实例重启.

zou_hope 发表于 2007-07-03 20:00

2007-07-02-12.01.18.827574+480 I32539493A371      LEVEL: Warning
PID   : 503978               TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0001611.LOG to TSM chain 0 from
          /ncbdblogdir/ncbprod/NODE0000/.

2007-07-02-12.01.19.974310+480 I32539865A368      LEVEL: Error
PID   : 503978               TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-12.01.19.974755+480 I32540234A428      LEVEL: Error
PID   : 503978               TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0001611.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/NCBPROD/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-12.01.19.974918+480 I32540663A391      LEVEL: Warning
PID   : 503978               TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 1611 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-12.17.02.335713+480 I32541055A322      LEVEL: Event
PID   : 3440714            TID: 1027      PROC : db2hmon 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:100
START   : Automatic Runstats: evaluation has started on database ABSTEST

2007-07-02-12.17.02.788947+480 E32541378A468      LEVEL: Warning
PID   : 3215546            TID: 1         PROC : db2agent (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000         DB   : ABSTEST
APPHDL: 0-270                APPID: *LOCAL.db2inst1.070702041706
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:3
MESSAGE : ADM5502WThe escalation of "641" locks on table
          "SYSTOOLS.HMON_ATM_INFO" to lock intent "X" was successful.

2007-07-02-12.17.05.544033+480 I32541847A323      LEVEL: Event
PID   : 3440714            TID: 1027      PROC : db2hmon 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:900
STOP    : Automatic Runstats: evaluation has finished on database ABSTEST

2007-07-02-12.17.07.586607+480 I32542171A323      LEVEL: Event
PID   : 3440714            TID: 1284      PROC : db2hmon 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:900
STOP    : Automatic Runstats: evaluation has finished on database NCBPROD

2007-07-02-12.18.47.642077+480 I32542495A336      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1390
MESSAGE : ExtNum 295, state 401, baselsn 0000000084918000 nextlsn
          0000000084BB30A3

2007-07-02-12.19.42.665628+480 I32542832A297      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.

2007-07-02-12.20.42.666018+480 I32543130A297      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.

2007-07-02-12.21.42.666424+480 I32543428A297      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.

2007-07-02-12.22.42.666825+480 I32543726A297      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.

2007-07-02-12.23.42.667245+480 I32544024A402      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1800
DATA #1 : String, 131 bytes
DB2 was unable to confirm logs were archived.
Return code -2029059911, FirstArchNum 274, FirstArchNum2 4294967295, HeadExtentID 296

2007-07-02-12.28.44.681513+480 I32544427A383      LEVEL: Warning
PID   : 921672               TID: 1         PROC : db2agent (idle) 0
INSTANCE: db2inst1             NODE : 000         DB   : ABSTEST
APPHDL: 0-50               APPID: *LOCAL.db2inst1.070628165841
FUNCTION: DB2 UDB, data protection, sqlpterm, probe:2330
MESSAGE : Some daemon is taking too long to shut down

2007-07-02-12.33.46.631926+480 I32544811A383      LEVEL: Warning
PID   : 921672               TID: 1         PROC : db2agent (idle) 0
INSTANCE: db2inst1             NODE : 000         DB   : ABSTEST
APPHDL: 0-50               APPID: *LOCAL.db2inst1.070628165841
FUNCTION: DB2 UDB, data protection, sqlpterm, probe:2330
MESSAGE : Some daemon is taking too long to shut down

2007-07-02-12.38.25.385648+480 E32545195A507      LEVEL: Severe
PID   : 3751956            TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:490
MESSAGE : ADM0503CAn unexpected internal processing error has occurred.ALL
          DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
          Diagnostic information has been recorded.Contact IBM Support for
          further assistance.

2007-07-02-12.38.25.386133+480 I32545703A362      LEVEL: Severe
PID   : 3751956            TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:500
MESSAGE : DiagData
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFFE8C8 : 0000 0102 0000 0009                        ........

zou_hope 发表于 2007-07-03 20:02

2007-07-02-13.29.34.853295+480 I32581814A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.29.34.853708+480 I32582183A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000286.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.29.34.853888+480 I32582612A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 286 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.29.36.780372+480 I32583003A383      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluvintCall, probe:10
MESSAGE : Signal encountered in sqluvint
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFC540 : 800F 00AF                                  ....

2007-07-02-13.29.36.780976+480 I32583387A560      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpInitVendorDevice, probe:1030
MESSAGE : Init failed!Vendor rc:
DATA #1 : Hexdump, 48 bytes
0x0FFFFFFFFFFFC600 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x0FFFFFFFFFFFC610 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x0FFFFFFFFFFFC620 : 0000 0000 1880 0000 0000 0000 0000 0000    ................

2007-07-02-13.29.36.781151+480 I32583948A335      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpInitVendorDevice, probe:1050
RETCODE : ZRC=0x0000001E=30
          DIA8030C Invalid filename "" was specified.

2007-07-02-13.29.36.781853+480 I32584284A336      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1820
RETCODE : ZRC=0x0000001E=30
          DIA8030C Invalid filename "" was specified.

2007-07-02-13.29.36.782083+480 I32584621A399      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000293.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ with rc = 30.

2007-07-02-13.29.36.782259+480 I32585021A314      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc 30 for LOGARCHMETH1.

2007-07-02-13.29.36.782476+480 I32585336A368      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.29.36.782670+480 I32585705A428      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000287.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.29.36.782840+480 I32586134A390      LEVEL: Warning
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 287 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.29.37.816424+480 I32586525A560      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpInitVendorDevice, probe:1030
MESSAGE : Init failed!Vendor rc:
DATA #1 : Hexdump, 48 bytes
0x0FFFFFFFFFFFC600 : 0000 07F9 3433 3520 3230 3431 0000 0000    ....435 2041....
0x0FFFFFFFFFFFC610 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x0FFFFFFFFFFFC620 : 0000 0000 1880 0000 0000 0000 0000 0000    ................

2007-07-02-13.29.37.816625+480 I32587086A281      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpInitVendorDevice, probe:1050
RETCODE : ZRC=0x0000000B=11

2007-07-02-13.29.37.816832+480 I32587368A282      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1820
RETCODE : ZRC=0x0000000B=11

2007-07-02-13.29.37.817036+480 I32587651A399      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000294.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ with rc = 11.

2007-07-02-13.29.37.817226+480 I32588051A314      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc 11 for LOGARCHMETH1.

2007-07-02-13.29.38.836587+480 I32588366A560      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpInitVendorDevice, probe:1030
MESSAGE : Init failed!Vendor rc:
DATA #1 : Hexdump, 48 bytes
0x0FFFFFFFFFFFC600 : 0000 07F9 3433 3520 3230 3431 0000 0000    ....435 2041....
0x0FFFFFFFFFFFC610 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x0FFFFFFFFFFFC620 : 0000 0000 1880 0000 0000 0000 0000 0000    ................

2007-07-02-13.29.38.836785+480 I32588927A281      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpInitVendorDevice, probe:1050
RETCODE : ZRC=0x0000000B=11

2007-07-02-13.29.38.836989+480 I32589209A282      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1820
RETCODE : ZRC=0x0000000B=11

2007-07-02-13.29.38.837193+480 I32589492A399      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000295.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ with rc = 11.

2007-07-02-13.29.38.837364+480 I32589892A314      LEVEL: Error
PID   : 811148               TID: 1387      PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc 11 for LOGARCHMETH1.

2007-07-02-13.29.40.449073+480 E32590207A523      LEVEL: Severe
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503CAn unexpected internal processing error has occurred.ALL
          DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
          Diagnostic information has been recorded.Contact IBM Support for
          further assistance.

2007-07-02-13.29.40.449289+480 E32590731A655      LEVEL: Severe
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
4
DATA #2 : Siginfo, 64 bytes
0x0FFFFFFFFFFF7CD0 : 0000 0004 0000 0000 0000 001E 0000 0000    ................
0x0FFFFFFFFFFF7CE0 : 0000 0000 0000 0000 0000 0001 1000 0538    ...............8
0x0FFFFFFFFFFF7CF0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x0FFFFFFFFFFF7D00 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

2007-07-02-13.29.46.553970+480 I32591387A432      LEVEL: Severe
PID   : 495658               TID: 1         PROC : db2gds 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUSIGCHLDHandler, probe:50
DATA #1 : String, 159 bytes
Detected the death of an EDU with process id 811148
The signal number that terminated this process was 4
Look for trap files (t811148.*) in the dump directory

2007-07-02-13.29.46.641918+480 E32591820A510      LEVEL: Severe
PID   : 495658               TID: 1         PROC : db2gds 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503CAn unexpected internal processing error has occurred.ALL
          DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
          Diagnostic information has been recorded.Contact IBM Support for
          further assistance.

2007-07-02-13.29.46.642201+480 E32592331A642      LEVEL: Severe
PID   : 495658               TID: 1         PROC : db2gds 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
6
DATA #2 : Siginfo, 64 bytes
0x0FFFFFFFFFFFD8F0 : 0000 0006 0000 0000 0000 0009 0000 0000    ................
0x0FFFFFFFFFFFD900 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x0FFFFFFFFFFFD910 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x0FFFFFFFFFFFD920 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

2007-07-02-13.29.46.700672+480 I32592974A371      LEVEL: Severe
PID   : 340134               TID: 1         PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:15
MESSAGE : DiagData
DATA #1 : Hexdump, 15 bytes
0x000000010000A004 : 416E 2045 4455 2063 7261 7368 6564 2E      An EDU crashed.

2007-07-02-13.29.46.706103+480 I32593346A359      LEVEL: Severe
PID   : 340134               TID: 1         PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDE34 : 0007 902A                                  ...*

2007-07-02-13.29.46.706236+480 I32593706A359      LEVEL: Severe
PID   : 340134               TID: 1         PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:17
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDE38 : 0000 0101                                  ....

2007-07-02-13.29.46.706362+480 I32594066A359      LEVEL: Severe
PID   : 340134               TID: 1         PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:18
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDE3C : FFFF FFFF                                  ....

2007-07-02-13.29.46.706489+480 I32594426A359      LEVEL: Severe
PID   : 340134               TID: 1         PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:19
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDE30 : FFFF FC88                                  ....

2007-07-02-13.29.46.706618+480 I32594786A349      LEVEL: Severe
PID   : 340134               TID: 1         PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleSysCtlr, probe:10
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFE7B4 : 0000 0001                                  ....

2007-07-02-13.29.46.824031+480 E32595136A507      LEVEL: Severe
PID   : 577590               TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:490
MESSAGE : ADM0503CAn unexpected internal processing error has occurred.ALL
          DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
          Diagnostic information has been recorded.Contact IBM Support for
          further assistance.

2007-07-02-13.29.46.824488+480 I32595644A362      LEVEL: Severe
PID   : 577590               TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:500
MESSAGE : DiagData
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFFE8C8 : 0000 0102 0000 0009                        ........

2007-07-02-13.29.46.825662+480 I32596007A359      LEVEL: Severe
PID   : 577590               TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFE820 : 0000 0102                                  ....

2007-07-02-13.29.46.833533+480 I32596367A405      LEVEL: Warning
PID   : 577590               TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFE610 : 0000 0000                                  ....

2007-07-02-13.29.50.982888+480 I32596773A342      LEVEL: Severe
PID   : 471198               TID: 1         PROC : db2ckpwd 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:50
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDF70 : 870F 0042                                  ...B

2007-07-02-13.29.50.982881+480 I32597116A342      LEVEL: Severe
PID   : 286800               TID: 1         PROC : db2ckpwd 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:50
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDF70 : 870F 0042                                  ...B

2007-07-02-13.29.50.982896+480 I32597459A342      LEVEL: Severe
PID   : 573686               TID: 1         PROC : db2ckpwd 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:50
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDF70 : 870F 0042                                  ...B

2007-07-02-13.31.47.039912+480 I32597802A311      LEVEL: Event
PID   : 577602               TID: 1         PROC : db2star2
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE: CFG DBM: "Instance_Memory" <automatic> From: "7248" To: "7248"

2007-07-02-13.31.48.397699+480 I32598114A365      LEVEL: Warning
PID   : 471204               TID: 1         PROC : db2spmrsy 0
INSTANCE: db2inst1             NODE : 000
APPHDL: 0-6
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : errno:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFF5AD0 : 0000 0011                                  ....

2007-07-02-13.31.48.398295+480 I32598480A281      LEVEL: Warning
PID   : 471204               TID: 1         PROC : db2spmrsy 0
INSTANCE: db2inst1             NODE : 000
APPHDL: 0-6
MESSAGE : Path/Filename
DATA #1 : String, 39 bytes
/home/db2inst1/sqllib/spmlog/SPMLOG.LCF

2007-07-02-13.31.48.413791+480 E32598762A980      LEVEL: Event
PID   : 577602               TID: 1         PROC : db2star2
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513WDatabase manager has started.
START   : DB2 DBM
DATA #1 : Build Level, 144 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.1.64", "s040812", "U498350", FixPak "7".
DATA #2 : System Info, 192 bytes
System: AIX P690M 2 5 00374BFE4C00
CPU: total:16 online:12
Physical Memory: total:16384 free:13597
VirtualMemory: total:49152 free:46350
Swap   Memory: total:32768 free:32753
Kernel   Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304
               shmMax:68719476736 shmMin:1 shmIDs:131072 shmSegments:0
               semIDs:131072 semNumPerID:65535 semOps:1024 semMaxVal:32767
               semAdjustOnExit:16384

zou_hope 发表于 2007-07-03 20:02

2007-07-02-13.32.08.613486+480 I32599743A370      LEVEL: Warning
PID   : 1491166            TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-7                  APPID: *LOCAL.db2inst1.070702053206
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.

2007-07-02-13.32.17.123505+480 I32600114A433      LEVEL: Warning
PID   : 1491166            TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-7                  APPID: *LOCAL.db2inst1.070702053206
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 000000127075800C MinbuffLSN
          000000127075800C

2007-07-02-13.32.17.125892+480 I32600548A415      LEVEL: Warning
PID   : 1491166            TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-7                  APPID: *LOCAL.db2inst1.070702053206
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 13 agents 7 QSets 84 queues and 625 chunks

2007-07-02-13.32.19.029742+480 I32600964A443      LEVEL: Warning
PID   : 1491166            TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-7                  APPID: *LOCAL.db2inst1.070702053206
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed.Next LSN is
          "0000001270776A35".

2007-07-02-13.32.19.053678+480 I32601408A398      LEVEL: Warning
PID   : 1491166            TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-7                  APPID: *LOCAL.db2inst1.070702053206
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : Crash recovery completed. Next LSN is 000000127077755F

2007-07-02-13.32.53.521976+480 I32601807A371      LEVEL: Warning
PID   : 1343636            TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0001612.LOG to TSM chain 0 from
          /ncbdblogdir/ncbprod/NODE0000/.

2007-07-02-13.32.54.715207+480 I32602179A368      LEVEL: Error
PID   : 1343636            TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.32.54.716426+480 I32602548A428      LEVEL: Error
PID   : 1343636            TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0001612.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/NCBPROD/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.32.54.716593+480 I32602977A391      LEVEL: Warning
PID   : 1343636            TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 1612 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

unixnewbie 发表于 2007-07-04 08:57

diag里rc 11 initfailed和很多log archiving failed信息说明log 备份不成功，所以在db2stop时db2不断重试，所以不能shutdown。类似问题在我配sun cluster 3.2时也碰过不少。你把这个db2diag.log改名，再运行一个archive log命令，再把新的db2diag.log贴上来看看?

zou_hope 发表于 2007-07-04 11:44

db2diag.log贴错,我重新贴一下.

zou_hope 发表于 2007-07-04 11:45

2007-07-02-11.18.34.248333+480 I32539101A391      LEVEL: Warning
PID   : 503978               TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 1610 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-12.01.18.827574+480 I32539493A371      LEVEL: Warning
PID   : 503978               TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0001611.LOG to TSM chain 0 from
          /ncbdblogdir/ncbprod/NODE0000/.

2007-07-02-12.01.19.974310+480 I32539865A368      LEVEL: Error
PID   : 503978               TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-12.01.19.974755+480 I32540234A428      LEVEL: Error
PID   : 503978               TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0001611.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/NCBPROD/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-12.01.19.974918+480 I32540663A391      LEVEL: Warning
PID   : 503978               TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 1611 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-12.17.02.335713+480 I32541055A322      LEVEL: Event
PID   : 3440714            TID: 1027      PROC : db2hmon 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:100
START   : Automatic Runstats: evaluation has started on database ABSTEST

2007-07-02-12.17.02.788947+480 E32541378A468      LEVEL: Warning
PID   : 3215546            TID: 1         PROC : db2agent (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000         DB   : ABSTEST
APPHDL: 0-270                APPID: *LOCAL.db2inst1.070702041706
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:3
MESSAGE : ADM5502WThe escalation of "641" locks on table
          "SYSTOOLS.HMON_ATM_INFO" to lock intent "X" was successful.

2007-07-02-12.17.05.544033+480 I32541847A323      LEVEL: Event
PID   : 3440714            TID: 1027      PROC : db2hmon 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:900
STOP    : Automatic Runstats: evaluation has finished on database ABSTEST

2007-07-02-12.17.07.586607+480 I32542171A323      LEVEL: Event
PID   : 3440714            TID: 1284      PROC : db2hmon 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:900
STOP    : Automatic Runstats: evaluation has finished on database NCBPROD

2007-07-02-12.18.47.642077+480 I32542495A336      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1390
MESSAGE : ExtNum 295, state 401, baselsn 0000000084918000 nextlsn
          0000000084BB30A3

2007-07-02-12.19.42.665628+480 I32542832A297      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.

2007-07-02-12.20.42.666018+480 I32543130A297      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.

2007-07-02-12.21.42.666424+480 I32543428A297      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.

2007-07-02-12.22.42.666825+480 I32543726A297      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.

2007-07-02-12.23.42.667245+480 I32544024A402      LEVEL: Warning
PID   : 524484               TID: 1         PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1800
DATA #1 : String, 131 bytes
DB2 was unable to confirm logs were archived.
Return code -2029059911, FirstArchNum 274, FirstArchNum2 4294967295, HeadExtentID 296

2007-07-02-12.28.44.681513+480 I32544427A383      LEVEL: Warning
PID   : 921672               TID: 1         PROC : db2agent (idle) 0
INSTANCE: db2inst1             NODE : 000         DB   : ABSTEST
APPHDL: 0-50               APPID: *LOCAL.db2inst1.070628165841
FUNCTION: DB2 UDB, data protection, sqlpterm, probe:2330
MESSAGE : Some daemon is taking too long to shut down

2007-07-02-12.33.46.631926+480 I32544811A383      LEVEL: Warning
PID   : 921672               TID: 1         PROC : db2agent (idle) 0
INSTANCE: db2inst1             NODE : 000         DB   : ABSTEST
APPHDL: 0-50               APPID: *LOCAL.db2inst1.070628165841
FUNCTION: DB2 UDB, data protection, sqlpterm, probe:2330
MESSAGE : Some daemon is taking too long to shut down

2007-07-02-12.38.25.385648+480 E32545195A507      LEVEL: Severe
PID   : 3751956            TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:490
MESSAGE : ADM0503CAn unexpected internal processing error has occurred.ALL
          DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
          Diagnostic information has been recorded.Contact IBM Support for
          further assistance.

2007-07-02-12.38.25.386133+480 I32545703A362      LEVEL: Severe
PID   : 3751956            TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloRunInstance, probe:500
MESSAGE : DiagData
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFFE8C8 : 0000 0102 0000 0009                        ........

2007-07-02-12.38.25.401866+480 I32546066A359      LEVEL: Severe
PID   : 3751956            TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFE820 : 0000 0102                                  ....

2007-07-02-12.38.25.489068+480 I32546426A405      LEVEL: Warning
PID   : 3751956            TID: 1         PROC : db2wdog 0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFE610 : 0000 0000                                  ....

2007-07-02-12.38.25.522852+480 I32546832A285      LEVEL: Severe
PID   : 2826334            TID: 1         PROC : db2fmp (C) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:3
RETCODE : ZRC=0x83000024=-2097151964

2007-07-02-12.38.31.446696+480 I32547118A342      LEVEL: Severe
PID   : 3617006            TID: 1         PROC : db2ckpwd 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:50
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDF70 : 870F 0042                                  ...B

2007-07-02-12.38.31.457019+480 I32547461A342      LEVEL: Severe
PID   : 3412074            TID: 1         PROC : db2ckpwd 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:50
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDF70 : 870F 0042                                  ...B

2007-07-02-12.38.31.450883+480 I32547804A342      LEVEL: Severe
PID   : 3592422            TID: 1         PROC : db2ckpwd 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:50
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDF70 : 870F 0042                                  ...B

2007-07-02-12.52.50.324426+480 E32548147A321      LEVEL: Error (OS)
PID   : 3731642            TID: 1         PROC : db2stop
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:3
CALLED: OS, -, unspecified_system_function
OSERR   : EINVAL (22) "Invalid argument"

zou_hope 发表于 2007-07-04 11:47

2007-07-02-12.52.50.357396+480 E32548469A318      LEVEL: Error (OS)
PID   : 3731642            TID: 1         PROC : db2stop
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED: OS, -, unspecified_system_function
OSERR   : EBADF (9) "Bad file number"

2007-07-02-12.52.50.357590+480 I32548788A280      LEVEL: Error
PID   : 3731642            TID: 1         PROC : db2stop
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:30
RETCODE : ZRC=0x83000009=-2097151991

2007-07-02-12.52.50.420128+480 I32549069A272      LEVEL: Error
PID   : 3731642            TID: 1         PROC : db2stop
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlePrintFinalMessage, probe:10
RETCODE : ZRC=0xFFFFFBEE=-1042

2007-07-02-13.12.27.790802+480 I32549342A311      LEVEL: Event
PID   : 438340               TID: 1         PROC : db2star2
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE: CFG DBM: "Instance_Memory" <automatic> From: "7248" To: "7248"

2007-07-02-13.12.30.579150+480 I32549654A365      LEVEL: Warning
PID   : 606248               TID: 1         PROC : db2spmrsy 0
INSTANCE: db2inst1             NODE : 000
APPHDL: 0-6
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : errno:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFF5AD0 : 0000 0011                                  ....

2007-07-02-13.12.30.611471+480 I32550020A281      LEVEL: Warning
PID   : 606248               TID: 1         PROC : db2spmrsy 0
INSTANCE: db2inst1             NODE : 000
APPHDL: 0-6
MESSAGE : Path/Filename
DATA #1 : String, 39 bytes
/home/db2inst1/sqllib/spmlog/SPMLOG.LCF

2007-07-02-13.12.30.783557+480 E32550302A980      LEVEL: Event
PID   : 438340               TID: 1         PROC : db2star2
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513WDatabase manager has started.
START   : DB2 DBM
DATA #1 : Build Level, 144 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.1.64", "s040812", "U498350", FixPak "7".
DATA #2 : System Info, 192 bytes
System: AIX P690M 2 5 00374BFE4C00
CPU: total:16 online:12
Physical Memory: total:16384 free:14509
VirtualMemory: total:49152 free:47272
Swap   Memory: total:32768 free:32763
Kernel   Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304
               shmMax:68719476736 shmMin:1 shmIDs:131072 shmSegments:0
               semIDs:131072 semNumPerID:65535 semOps:1024 semMaxVal:32767
               semAdjustOnExit:16384

2007-07-02-13.12.39.855032+480 I32551283A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.12.39.902113+480 I32551652A419      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000274.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ with rc =
          -2045837302.

2007-07-02-13.12.39.902307+480 I32552072A323      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchivePendingLogs, probe:1500
MESSAGE : Log archive failed with rc -2045837302 for LOGARCHMETH1.

2007-07-02-13.12.42.781833+480 I32552396A325      LEVEL: Warning
PID   : 1110046            TID: 1         PROC : db2loggr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgLoggrInitDelOldLog, probe:1440
MESSAGE : Cleaning up logs from RenameArchNum 1500 to delLimit 1611

2007-07-02-13.12.44.899367+480 I32552722A370      LEVEL: Warning
PID   : 958678               TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-59               APPID: *LOCAL.db2inst1.070702051331
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.

2007-07-02-13.12.53.457292+480 I32553093A433      LEVEL: Warning
PID   : 958678               TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-59               APPID: *LOCAL.db2inst1.070702051331
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 000000126EABD8E3 MinbuffLSN
          000000126C3689BF

2007-07-02-13.12.53.483450+480 I32553527A415      LEVEL: Warning
PID   : 958678               TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-59               APPID: *LOCAL.db2inst1.070702051331
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 13 agents 7 QSets 84 queues and 625 chunks

2007-07-02-13.13.31.489572+480 I32553943A443      LEVEL: Warning
PID   : 958678               TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-59               APPID: *LOCAL.db2inst1.070702051331
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
MESSAGE : DIA2051W Forward phase of crash recovery has completed.Next LSN is
          "000000126EB2E8FA".

2007-07-02-13.13.31.527800+480 I32554387A398      LEVEL: Warning
PID   : 958678               TID: 1         PROC : db2agent (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000         DB   : NCBPROD
APPHDL: 0-59               APPID: *LOCAL.db2inst1.070702051331
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
MESSAGE : Crash recovery completed. Next LSN is 000000126EB2E8FA

2007-07-02-13.15.54.516759+480 I32554786A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000275.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.16.41.410494+480 I32555179A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000276.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.17.28.116118+480 I32555572A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000277.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.18.14.537577+480 I32555965A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000278.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.19.01.620824+480 I32556358A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000279.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.19.02.699696+480 I32556751A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.19.02.700082+480 I32557120A419      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000274.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ with rc =
          -2045837302.

2007-07-02-13.19.02.700244+480 I32557540A391      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive, probe:4760
MESSAGE : Unable to find log file 274 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.19.03.700525+480 I32557932A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.19.03.700775+480 I32558301A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000274.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.19.03.700936+480 I32558730A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 274 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.19.55.204505+480 I32559121A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000280.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.20.45.071674+480 I32559514A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000281.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.20.45.147815+480 I32559907A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.20.45.148200+480 I32560276A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000275.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.20.45.148374+480 I32560705A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 275 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.21.32.811952+480 I32561096A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000282.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.21.32.888552+480 I32561489A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.21.32.888948+480 I32561858A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000276.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.21.32.889123+480 I32562287A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 276 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.22.20.648055+480 I32562678A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000283.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.22.20.735332+480 I32563071A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.22.20.735757+480 I32563440A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000277.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.22.20.735933+480 I32563869A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 277 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.23.08.392745+480 I32564260A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000284.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.23.08.469349+480 I32564653A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.23.08.469746+480 I32565022A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000278.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.23.08.469921+480 I32565451A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 278 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.23.56.237203+480 I32565842A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000285.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.23.56.322840+480 I32566235A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.23.56.323237+480 I32566604A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000279.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.23.56.323412+480 I32567033A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 279 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.24.43.986562+480 I32567424A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000286.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

zou_hope 发表于 2007-07-04 11:51

2007-07-02-13.24.44.063338+480 I32567817A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.24.44.063735+480 I32568186A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000280.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.24.44.063910+480 I32568615A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 280 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.25.31.254638+480 I32569006A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000287.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.25.31.331503+480 I32569399A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.25.31.331903+480 I32569768A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000281.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.25.31.332078+480 I32570197A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 281 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.26.18.833351+480 I32570588A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000288.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.26.18.918718+480 I32570981A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.26.18.919112+480 I32571350A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000282.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.26.18.919310+480 I32571779A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 282 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.27.06.575323+480 I32572170A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000289.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.27.06.652453+480 I32572563A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.27.06.652853+480 I32572932A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000283.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.27.06.653029+480 I32573361A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 283 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.27.54.238353+480 I32573752A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000290.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.27.54.326381+480 I32574145A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.27.54.326770+480 I32574514A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000284.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.27.54.326945+480 I32574943A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 284 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.28.42.158785+480 I32575334A392      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0000291.LOG to TSM chain 0 from
          /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/.

2007-07-02-13.28.42.236349+480 I32575727A368      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogVendor, probe:1630
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2007-07-02-13.28.42.236760+480 I32576096A428      LEVEL: Error
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000285.LOG to TSM chain 0 from
          /home/db2inst1/arclogdir/db2inst1/ABSTEST/NODE0000/C0000000/ with rc
          = -2045837302.

2007-07-02-13.28.42.236935+480 I32576525A390      LEVEL: Warning
PID   : 811148               TID: 1         PROC : db2logmgr (ABSTEST) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4930
MESSAGE : Unable to find log file 285 for LOGARCHMETH1 using method 2 and
          target .Assume log was archived and continue.

2007-07-02-13.28.56.523799+480 I32576916A337      LEVEL: Warning
PID   : 1110046            TID: 1         PROC : db2loggr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1390
MESSAGE : ExtNum 1612, state 401, baselsn 000000126E048000 nextlsn
          000000126EE3A323

2007-07-02-13.29.09.906675+480 I32577254A401      LEVEL: Error
PID   : 1093654            TID: 1         PROC : db2logmgr (NCBPROD) 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpCloseVendorDevice, probe:2800
MESSAGE : Return code from sqlpCloseVendorDevice:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFC750 : 0000 0011                                  ....

查看完整版本: db2stop force 挂起问题求助！