环境是aix6.1
tsm自身的db2数据库,tsm在备份的时候产生了很多日志,导致/home目录使用率100%,当时不懂db2,就手动把/home/tsmlog下的日志给刪了,后来又扩了/home目录的空间,tsm无法启动,报db2不能正常启动,当时刪日志的时候备份了一部分,后来又给恢复了,但是还是无法启动.
tsm报错信息如下:
2014-02-21-00.43.29.906129+480 I76309844A307 LEVEL: Event
PID : 54853808 TID : 1 PROC : db2set
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2_KEEPTABLELOCK: From: "OFF" To: "OFF"
2014-02-21-00.43.29.948004+480 I76310152A304 LEVEL: Event
PID : 54853810 TID : 1 PROC : db2set
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2_SKIPINSERTED: From: "ON" To: "ON"
2014-02-21-00.43.29.989911+480 I76310457A307 LEVEL: Event
PID : 54853812 TID : 1 PROC : db2set
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2_EVALUNCOMMITTED: From: "ON" To: "ON"
2014-02-21-00.43.30.031840+480 I76310765A303 LEVEL: Event
PID : 54853814 TID : 1 PROC : db2set
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2_SKIPDELETED: From: "ON" To: "ON"
2014-02-21-00.43.30.073745+480 I76311069A301 LEVEL: Event
PID : 54853816 TID : 1 PROC : db2set
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2_PARALLEL_IO: From: "*" To: "*"
2014-02-21-00.43.30.121708+480 I76311371A301 LEVEL: Event
PID : 54853818 TID : 1 PROC : db2set
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2COMM: From: "TCPIP" To: "TCPIP"
2014-02-21-00.43.30.318364+480 I76311673A313 LEVEL: Event
PID : 54853824 TID : 1 PROC : db2start
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:21
DATA #1 :
Single node instance [0] is starting
2014-02-21-00.43.30.342303+480 I76311987A1645 LEVEL: Event
PID : 54853824 TID : 1 PROC : db2start
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/tsminst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x0FFFFFFFFFFF4CB0 : 2F68 6F6D 652F 7473 6D69 6E73 7431 2F73 /home/tsminst1/s
0x0FFFFFFFFFFF4CC0 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0x0FFFFFFFFFFF4CD0 : 7232 004E 4F4D 5347 0000 0000 0000 0000 r2.NOMSG........
0x0FFFFFFFFFFF4CE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4CF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4DA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2014-02-21-00.43.30.451476+480 E76313633A1312 LEVEL: Event
PID : 57278676 TID : 258 PROC : db2sysc
INSTANCE: tsminst1 NODE : 000
EDUID : 258
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1
START : DB2 DBM
DATA #1 : Build Level, 152 bytes
Instance "tsminst1" uses "64" bits and DB2 code release "SQL09074"
with level identifier "08050107".
Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23236", Fix Pack "4".
DATA #2 : System Info, 224 bytes
System: AIX erpprd 1 7 00F874264C00
CPU: total:24 online:24 Threading degree per core:4
Physical Memory(MB): total:78592 free:19058
Virtual Memory(MB): total:144128 free:84456
Swap Memory(MB): total:65536 free:65398
Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304
shmMax:68719476736 shmMin:1 shmIDs:131072
shmSegments:68719476736 semIDs:131072 semNumPerID:65535
semOps:1024 semMaxVal:32767 semAdjustOnExit:16384
Cur cpu time limit (seconds) = 0x7FFFFFFFFFFFFFFF
Cur file size limit (bytes) = 0x7FFFFFFFFFFFFFFF
Cur data size (bytes) = 0x7FFFFFFFFFFFFFFF
Cur stack size (bytes) = 0x0000000100000000
Cur core size (bytes) = 0x00000000FFFFFFFF
Cur memory size (bytes) = 0x7FFFFFFFFFFFFFFF
nofiles (descriptors) = 0x7FFFFFFFFFFFFFFF
2014-02-21-00.43.31.709857+480 I76314946A536 LEVEL: Event
PID : 43581564 TID : 258 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10
START : Starting FCM Buffer Manager
1 resource group(s).
1491 buffers allocated.
Maximum number of buffers supported is 524470.
Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 27893776 bytes.
2014-02-21-00.43.31.714907+480 I76315483A542 LEVEL: Event
PID : 43581564 TID : 258 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10
START : Starting FCM Channel Manager
1 resource group(s).
895 channels allocated.
Maximum number of channels supported is 524470.
Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 11444248 bytes.
2014-02-21-00.43.31.718710+480 I76316026A537 LEVEL: Event
PID : 43581564 TID : 258 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10
START : Starting FCM Session Manager
1 resource group(s).
298 sessions allocated.
Maximum number of sessions supported is 64440.
Total session manager memory required for 1 logical and 0 fail-over partitions is 7122944 bytes.
2014-02-21-00.43.31.720306+480 I76316564A418 LEVEL: Event
PID : 43581564 TID : 258 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500
START : FCM infrastructure started
FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IPv4
2014-02-21-00.43.36.463621+480 E76316983A314 LEVEL: Event
PID : 28901556 TID : 1 PROC : db2star2
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
2014-02-21-00.43.36.664218+480 E76317298A414 LEVEL: Info
PID : 43581564 TID : 4114 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
EDUID : 4114 EDUNAME: db2loggr (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog, probe:1440
DATA #1 :
Cleaning up logs from RenameArchNum 27 to delLimit 52.
2014-02-21-00.43.36.673282+480 I76317713A437 LEVEL: Warning
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2014-02-21-00.43.40.194076+480 E76318151A468 LEVEL: Event
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START : DATABASE: TSMDB1 : ACTIVATED: YES
2014-02-21-00.43.40.194505+480 I76318620A500 LEVEL: Warning
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000000690AB8069 MinbuffLSN
0000000690AB8069
2014-02-21-00.43.40.194765+480 E76319121A454 LEVEL: Warning
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : ADM1530E Crash recovery has been initiated.
2014-02-21-00.43.40.195618+480 I76319576A496 LEVEL: Warning
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 :
Using parallel recovery with 6 agents 12 QSets 60 queues and 16 chunks
2014-02-21-00.43.40.219354+480 I76320073A421 LEVEL: Info
PID : 43581564 TID : 4114 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
EDUID : 4114 EDUNAME: db2loggr (TSMDB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlpgSwitchFromRedoToUndo, probe:824
DATA #1 :
TailIndex 0 firstLso 27818536961 nextLso 28059281914 logGapSize 0
2014-02-21-00.43.40.219620+480 I76320495A452 LEVEL: Warning
PID : 43581564 TID : 4114 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
EDUID : 4114 EDUNAME: db2loggr (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgarl, probe:99
MESSAGE : INFO ONLY: Found an old page in the log file: ByteOffset 0, PageLso
0 highLso 28059285901 lowLso 28059281825
2014-02-21-00.43.40.219847+480 I76320948A540 LEVEL: Severe
PID : 43581564 TID : 4114 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
EDUID : 4114 EDUNAME: db2loggr (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgarl, probe:2780
MESSAGE : BADLSN: RelativeByte 0, ByteOffset 88, PageNumber 59065, extNum 52,
ReadCount 1, rc1 3 Loop(i) 0, BlkOffset 59066 lastDiskLso 28059281914
HighPso 0000000690AB9010 LowPso 0000000690AB8010
2014-02-21-00.43.40.220060+480 I76321489A179 LEVEL: Severe
PID:43581564 TID:4114 NODE:000 Title: SQLP_DBCB
Dump File:/home/tsminst1/sqllib/db2dump/43581564.4114.000.dump.bin
2014-02-21-00.43.40.234734+480 I76321669A179 LEVEL: Severe
PID:43581564 TID:4114 NODE:000 Title: SQLP_LFPB
Dump File:/home/tsminst1/sqllib/db2dump/43581564.4114.000.dump.bin
2014-02-21-00.43.40.234933+480 I76321849A179 LEVEL: Severe
PID:43581564 TID:4114 NODE:000 Title: SQLP_LFPB
Dump File:/home/tsminst1/sqllib/db2dump/43581564.4114.000.dump.bin
2014-02-21-00.43.40.235125+480 I76322029A179 LEVEL: Severe
PID:43581564 TID:4114 NODE:000 Title: SQLP_DBCB
Dump File:/home/tsminst1/sqllib/db2dump/43581564.4114.000.dump.bin
2014-02-21-00.43.40.235372+480 I76322209A474 LEVEL: Error
PID : 43581564 TID : 4114 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
EDUID : 4114 EDUNAME: db2loggr (TSMDB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlpgSwitchFromRedoToUndo, probe:3380
RETCODE : ZRC=0x87100029=-2028994519=SQLP_BADLSN "Invalid LSN value."
DIA8538C An invalid log sequence number (LSN), the value was "".
2014-02-21-00.43.40.235695+480 I76322684A464 LEVEL: Error
PID : 43581564 TID : 4114 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
EDUID : 4114 EDUNAME: db2loggr (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgasn, probe:650
RETCODE : ZRC=0x87100029=-2028994519=SQLP_BADLSN "Invalid LSN value."
DIA8538C An invalid log sequence number (LSN), the value was "".
2014-02-21-00.43.40.235947+480 I76323149A479 LEVEL: Error
PID : 43581564 TID : 12595 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 12595 EDUNAME: db2redom (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgPostLoggrWithoutLatching, probe:930
MESSAGE : db2logger: rc=-2028994519 sem rc=0 type=28
2014-02-21-00.43.40.236236+480 I76323629A180 LEVEL: Error
PID:43581564 TID:12595 NODE:000 Title: SQLP_DBCB
Dump File:/home/tsminst1/sqllib/db2dump/43581564.12595.000.dump.bin
2014-02-21-00.43.40.240723+480 I76323810A550 LEVEL: Error
PID : 43581564 TID : 12595 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 12595 EDUNAME: db2redom (TSMDB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:3980
RETCODE : ZRC=0x87100029=-2028994519=SQLP_BADLSN "Invalid LSN value."
DIA8538C An invalid log sequence number (LSN), the value was "".
2014-02-21-00.43.40.241411+480 I76324361A566 LEVEL: Error
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
DATA #1 : String, 140 bytes
Crash recovery failed with rc -2028994519
LowtranLSN 0000000690AB8069 MinbuffLSN 0000000690AB8069
Recovery started on log file S0000052.LOG.
2014-02-21-00.43.40.241648+480 I76324928A520 LEVEL: Severe
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RecoverDatabase, probe:16
DATA #1 : Hexdump, 4 bytes
0x0A0000000CFF6DE0 : 8710 0029 ...)
2014-02-21-00.43.40.241853+480 I76325449A519 LEVEL: Error
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RecoverDatabase, probe:16
DATA #2 : Hexdump, 4 bytes
0x0A0000000CFF6DE0 : 8710 0029 ...)
2014-02-21-00.43.40.242055+480 E76325969A491 LEVEL: Error
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RecoverDatabase, probe:60
MESSAGE : ADM1532E Crash recovery has failed with SQLCODE "-1042".
2014-02-21-00.43.40.252594+480 E76326461A970 LEVEL: Critical
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred:
"DBMarkedBad". The instance may have been shutdown as a result.
"Automatic" FODC (First Occurrence Data Capture) has been invoked and
diagnostic information has been recorded in directory
"/home/tsminst1/sqllib/db2dump/FODC_DBMarkedBad_2014-02-21-00.43.40.2
42517_0000/". Please look in this directory for detailed evidence
about what happened and contact IBM support if necessary to diagnose
the problem.
2014-02-21-00.43.40.253057+480 E76327432A461 LEVEL: Severe
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10
MESSAGE : ADM7518C "TSMDB1 " marked bad.
2014-02-21-00.43.40.253510+480 I76327894A474 LEVEL: Severe
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:210
MESSAGE : Database logging stopped due to mark db bad.
2014-02-21-00.43.40.267320+480 I76328369A494 LEVEL: Severe
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2014-02-21-00.43.40.299866+480 I76328864A507 LEVEL: Severe
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2014-02-21-00.43.40.300473+480 I76329372A623 LEVEL: Event
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10
STOP : AUTOMATIC FODC : DBMarkedBad : success
IMPACT : None
DATA #1 : String, 113 bytes
Check /home/tsminst1/sqllib/db2dump/FODC_DBMarkedBad_2014-02-21-00.43.40.242517_0000/ for diagnostic information.
2014-02-21-00.43.40.300714+480 I76329996A560 LEVEL: Severe
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RestartDatabase, probe:202
MESSAGE : If 'DATALINK: file server not registered' appears above and
DATALINKS=NO, set DATALINKS=YES and try RESTART again
2014-02-21-00.43.40.300929+480 I76330557A452 LEVEL: Severe
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:140
RETCODE : ZRC=0xFFFFFBEE=-1042
2014-02-21-00.43.40.301203+480 I76331010A486 LEVEL: Warning
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbCleanupBeforeTerm, probe:4949
DATA #1 : String, 41 bytes
Recovery failed, dirty pages not flushed.
2014-02-21-00.43.40.678193+480 E76331497A469 LEVEL: Event
PID : 43581564 TID : 3343 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.140220164336
AUTHID : TSMINST1
EDUID : 3343 EDUNAME: db2agent (idle) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP : DATABASE: TSMDB1 : DEACTIVATED: YES
2014-02-21-00.43.42.688457+480 I76331967A519 LEVEL: Error
PID : 43581564 TID : 12595 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-9 APPID: *LOCAL.tsminst1.140220164342
AUTHID : TSMINST1
EDUID : 12595 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, base sys utilities, sqeDBMgr::StartUsingLocalDatabase, probe:72
DATA #2 : Hexdump, 4 bytes
0x0780000002A05B8C : 0000 05D8 ....
2014-02-21-00.43.42.737645+480 I76332487A1644 LEVEL: Event
PID : 28901560 TID : 1 PROC : db2stop
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/tsminst1/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0x0FFFFFFFFFFF4C60 : 2F68 6F6D 652F 7473 6D69 6E73 7431 2F73 /home/tsminst1/s
0x0FFFFFFFFFFF4C70 : 716C 6C69 622F 6164 6D2F 6462 3273 746F qllib/adm/db2sto
0x0FFFFFFFFFFF4C80 : 7032 004E 4F4D 5347 0046 4F52 4345 0053 p2.NOMSG.FORCE.S
0x0FFFFFFFFFFF4C90 : 4E00 0000 0000 0000 0000 0000 0000 0000 N...............
0x0FFFFFFFFFFF4CA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4CB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4CC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4CD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4CE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4CF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF4D50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2014-02-21-00.43.42.755484+480 I76334132A395 LEVEL: Event
PID : 54853830 TID : 1 PROC : db2stop2
INSTANCE: tsminst1 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
0x0FFFFFFFFFFF9EE4 : 0000 0000 ....
2014-02-21-00.43.42.755993+480 I76334528A477 LEVEL: Event
PID : 43581564 TID : 258 PROC : db2sysc 0
INSTANCE: tsminst1 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
0x0A000000003FC364 : 0000 0001 ....
2014-02-21-00.43.42.756377+480 I76335006A320 LEVEL: Event
PID : 54853830 TID : 1 PROC : db2stop2
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108
DATA #1 : String, 47 bytes
Force phase is completed and preparing to stop.
2014-02-21-00.43.42.756564+480 I76335327A398 LEVEL: Event
PID : 54853830 TID : 1 PROC : db2stop2
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFF9EE0 : 0000 0001 ....
2014-02-21-00.43.42.756745+480 I76335726A418 LEVEL: Event
PID : 54853830 TID : 1 PROC : db2stop2
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFF9EE0 : 0000 0001 ....
2014-02-21-00.43.42.756925+480 I76336145A299 LEVEL: Event
PID : 54853830 TID : 1 PROC : db2stop2
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2014-02-21-00.43.42.757104+480 I76336445A314 LEVEL: Event
PID : 54853830 TID : 1 PROC : db2stop2
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2014-02-21-00.43.42.805751+480 I76336760A316 LEVEL: Event
PID : 54853830 TID : 1 PROC : db2stop2
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2014-02-21-00.43.42.805943+480 I76337077A335 LEVEL: Event
PID : 54853830 TID : 1 PROC : db2stop2
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : unsigned integer, 4 bytes
0
2014-02-21-00.43.42.812981+480 I76337413A453 LEVEL: Warning
PID : 57278676 TID : 258 PROC : db2wdog 0
INSTANCE: tsminst1 NODE : 000
EDUID : 258 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x0A000000003FDE70 : 0000 0000 ....
2014-02-21-00.43.43.510292+480 E76337867A313 LEVEL: Event
PID : 54853830 TID : 1 PROC : db2stop2
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2014-02-21-00.43.43.569121+480 I76338181A305 LEVEL: Event
PID : 28901560 TID : 1 PROC : db2stop
INSTANCE: tsminst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:190
DATA #1 :
Single node stopped [-1064].附件:
20140221.zip (2.28 MB)