DB2 用db2start启动后自动停止,connect to 连接不上,求大神帮忙看看,以下是db2diag日志
2017-01-17-19.27.20.665297+480 I1E1699 LEVEL: Event
PID : 8845 TID : 140392260519712 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 232 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL10056"
with level identifier "0607010E".
Informational tokens are "DB2 v10.5.0.6", "s150731", "IP23643", Fix Pack "6".
DATA #2 : System Info, 664 bytes
System: Linux ftpdb 6 2 x86_64
CPU: total:4 online:4 Cores per socket:2 Threading degree per core:1 SIMD:Y
CPU binding: not in use
Physical Memory(MB): total:3834 free:3507
Virtual Memory(MB): total:9906 free:9503
Swap Memory(MB): total:6072 free:5996
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:7659
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:68719476736 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:256000 semIDs:1024 semNum:256000
semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds) = 0xFFFFFFFFFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFFFFFFFFFF
Cur data size (bytes) = 0xFFFFFFFFFFFFFFFF
Cur stack size (bytes) = 0x0000000000A00000
Cur core size (bytes) = 0x0000000000000000
Cur memory size (bytes) = 0xFFFFFFFFFFFFFFFF
nofiles (descriptors) = 0x0000000000001000
Cur maximum number of processes = 0x0000000000000400
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2017-01-17-19.27.20.669262+480 I1701E384 LEVEL: Event
PID : 8845 TID : 140392260519712 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:15083
MESSAGE : Obtained exclusive mode lock on the file:
DATA #1 : String, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
2017-01-17-19.27.20.696840+480 I2086E1655 LEVEL: Event
PID : 8845 TID : 140392260519712 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x00007FFF8B5035F0 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x00007FFF8B503600 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0x00007FFF8B503610 : 7232 004E 4F4D 5347 0000 0000 0000 0000 r2.NOMSG........
0x00007FFF8B503620 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B503630 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B503640 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B503650 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B503660 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B503670 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B503680 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B503690 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B5036A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B5036B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B5036C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B5036D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF8B5036E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2017-01-17-19.27.20.858692+480 I3742E384 LEVEL: Event
PID : 8847 TID : 139842640848672 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:15083
MESSAGE : Obtained exclusive mode lock on the file:
DATA #1 : String, 39 bytes
/home/db2inst1/sqllib/ctrl/db2stst.0000
2017-01-17-19.27.21.203144+480 E4127E259 LEVEL: Warning
PID : 8847 TID : 139842640848672 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, license manager, sqllcRequestAccess, probe:0
2017-01-17-19.27.21.660982+480 E4387E1566 LEVEL: Event
PID : 8851 TID : 140533506762496 PROC : db2syscr
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1
START : DB2 DBM
DATA #1 : Build Level, 232 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL10056"
with level identifier "0607010E".
Informational tokens are "DB2 v10.5.0.6", "s150731", "IP23643", Fix Pack "6".
DATA #2 : System Info, 664 bytes
System: Linux ftpdb 6 2 x86_64
CPU: total:4 online:4 Cores per socket:2 Threading degree per core:1 SIMD:Y
CPU binding: not in use
Physical Memory(MB): total:3834 free:3321
Virtual Memory(MB): total:9906 free:9317
Swap Memory(MB): total:6072 free:5996
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:7659
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:68719476736 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:256000 semIDs:1024 semNum:256000
semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds) = 0xFFFFFFFFFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFFFFFFFFFF
Cur data size (bytes) = 0xFFFFFFFFFFFFFFFF
Cur stack size (bytes) = 0x0000000000A00000
Cur core size (bytes) = 0x0000000000000000
Cur memory size (bytes) = 0xFFFFFFFFFFFFFFFF
nofiles (descriptors) = 0x0000000000001000
Cur maximum number of processes = 0x0000000000000400
2017-01-17-19.27.22.218859+480 I5954E553 LEVEL: Event
PID : 8853 TID : 140128202778368 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10
START : Starting FCM Buffer Manager
1 resource group(s).
128 buffers allocated.
Maximum number of buffers supported is 8192.
Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 925704 bytes.
2017-01-17-19.27.22.224212+480 I6508E560 LEVEL: Event
PID : 8853 TID : 140128202778368 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10
START : Starting FCM Channel Manager
1 resource group(s).
128 channels allocated.
Maximum number of channels supported is 8192.
Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 512024 bytes.
2017-01-17-19.27.22.227168+480 I7069E559 LEVEL: Event
PID : 8853 TID : 140128202778368 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10
START : Starting FCM Session Manager
1 resource group(s).
128 sessions allocated.
Maximum number of sessions supported is 64000.
Total session manager memory required for 1 logical and 0 fail-over partitions is 1957888 bytes.
2017-01-17-19.27.22.234167+480 I7629E440 LEVEL: Event
PID : 8853 TID : 140128202778368 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 1 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
2017-01-17-19.27.22.249402+480 I8070E423 LEVEL: Info
PID : 8853 TID : 140128202778368 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmAttachToShmAtStartup, probe:1178
MESSAGE : Attached to STMM shared memory segment.
DATA #1 : Pointer, 8 bytes
0x00007f7246e87000
2017-01-17-19.27.22.255209+480 I8494E2571 LEVEL: Info
PID : 8853 TID : 140128202778368 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, base sys utilities, sqleRollupCacheALInfo, probe:249
DATA #1 : String, 25 bytes
Rollup History at Startup
DATA #2 : sqeRollupALHistory, PD_TYPE_sqeRollupALHistory, 152 bytes
sqeRollupALHistory: Address:0x200839350, Size:x98, Size:152
x0088 m_activateNewRollupSetLatch {
state = 0x0000000000000000
= {
held X: 0
reserved for X: 0
shared holders: 0
firstSharIndex: 0x0
firstExclIndex: 0x0
}
starve X mode = true
xWaitCount = 0
requestCount = 0
identity = sqeRollupALHistory::m_activateNewRollupSetLatch (853)
}
x0080 m_activeRollupLevelSet 1
x0000 m_rollupLevelSets[0] SQLE_ROLLUP_LEVEL_SET: Address:0x200839350, Size:x20, Size:32
x0000 levelSetActivationTime 1970-01-01 08:00:00.000000
x0008 ceal
V:0 R:0 M:0 F:0 I:0 SB:0
x0010 cecl
V:0 R:0 M:0 F:0 I:0 SB:0
x0018 cesl
V:0 R:0 M:0 F:0 I:0 SB:0
x0020 m_rollupLevelSets[1] SQLE_ROLLUP_LEVEL_SET: Address:0x200839370, Size:x20, Size:32
x0000 levelSetActivationTime 2017-01-17 19:27:22.255201
x0008 ceal
V:10 R:5 M:0 F:6 I:0 SB:0
x0010 cecl
V:10 R:5 M:0 F:6 I:0 SB:0
x0018 cesl
V:0 R:0 M:0 F:0 I:0 SB:0
x0040 m_rollupLevelSets[2] SQLE_ROLLUP_LEVEL_SET: Address:0x200839390, Size:x20, Size:32
x0000 levelSetActivationTime 1970-01-01 08:00:00.000000
x0008 ceal
V:0 R:0 M:0 F:0 I:0 SB:0
x0010 cecl
V:0 R:0 M:0 F:0 I:0 SB:0
x0018 cesl
V:0 R:0 M:0 F:0 I:0 SB:0
x0060 m_rollupLevelSets[3] SQLE_ROLLUP_LEVEL_SET: Address:0x2008393b0, Size:x20, Size:32
x0000 levelSetActivationTime 1970-01-01 08:00:00.000000
x0008 ceal
V:0 R:0 M:0 F:0 I:0 SB:0
x0010 cecl
V:0 R:0 M:0 F:0 I:0 SB:0
x0018 cesl
V:0 R:0 M:0 F:0 I:0 SB:0
2017-01-17-19.27.22.377208+480 I11066E396 LEVEL: Event
PID : 8853 TID : 140128202778368 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfNodeManager::initNodeManager, probe:9
DATA #1 :
Is Cluster Manager enabled? true or false = 0
2017-01-17-19.27.22.622960+480 I11463E389 LEVEL: Event
PID : 8853 TID : 140128202778368 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 1 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, Columnar Data Engine, cdeStartup, probe:130
DATA #1 :
BLU: HW SIMD enabled: SCAN(Y), ARITH(Y), HASH(Y), CPU(0)
2017-01-17-19.27.23.697124+480 E11853E488 LEVEL: Event
PID : 8847 TID : 139842640848672 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM ARCHITECTURE LEVEL: A05000600000000 CURRENT EFFECTIVE ARCHITECTURE LEVEL: A05000600000000 CODE LEVEL: A05000600000000 CURRENT EFFECTIVE CODE LEVEL: A05000600000000
2017-01-17-19.27.23.700868+480 I12342E375 LEVEL: Warning
PID : 8847 TID : 139842640848672 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:14796
MESSAGE : Released lock on the file:
DATA #1 : String, 39 bytes
/home/db2inst1/sqllib/ctrl/db2stst.0000
2017-01-17-19.27.23.711402+480 I12718E1263 LEVEL: Event
PID : 8845 TID : 140392260519712 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:10813
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL10056
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1063 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEPFIN
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
false
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Boolean, 1 bytes
false
DATA #7 : Boolean, 1 bytes
false
2017-01-17-19.27.23.712254+480 I13982E375 LEVEL: Warning
PID : 8845 TID : 140392260519712 PROC : db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:14796
MESSAGE : Released lock on the file:
DATA #1 : String, 39 bytes
/home/db2inst1/sqllib/ctrl/db2strst.lck
2017-01-17-19.27.26.772548+480 I14358E671 LEVEL: Event
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqleCalculateDbHeaps, probe:70
MESSAGE : RLMS - DB Memory Set for Resident Member
DATA #1 : String, 10 bytes
totalBytes
DATA #2 : unsigned integer, 8 bytes
5720244224
DATA #3 : String, 11 bytes
dbHeapBytes
DATA #4 : unsigned integer, 8 bytes
191758336
2017-01-17-19.27.26.773668+480 I15030E671 LEVEL: Event
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqleCalculateDbHeaps, probe:70
MESSAGE : RLMS - DB Memory Set for Resident Member
DATA #1 : String, 10 bytes
totalBytes
DATA #2 : unsigned integer, 8 bytes
5589893120
DATA #3 : String, 11 bytes
dbHeapBytes
DATA #4 : unsigned integer, 8 bytes
191758336
2017-01-17-19.27.26.774826+480 E15702E989 LEVEL: Warning
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, Self tuning memory manager, stmmCalcAutoScaleFactor, probe:100
MESSAGE : Current DB configuration exceeds free physical memory. Self-tuning
memory manager resetting automatic memory consumers to default
values.
DATA #1 : unsigned integer, 8 bytes
6292307968
DATA #2 : unsigned integer, 8 bytes
6148915200
DATA #3 : unsigned integer, 8 bytes
4019675136
DATA #4 : unsigned integer, 8 bytes
2916116071
DATA #5 : unsigned integer, 8 bytes
3069214720
DATA #6 : unsigned integer, 8 bytes
81735961
DATA #7 : unsigned integer, 8 bytes
2834380110
DATA #8 : Decimal, 8 bytes
-1
2017-01-17-19.27.26.777785+480 I16692E671 LEVEL: Event
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqleCalculateDbHeaps, probe:70
MESSAGE : RLMS - DB Memory Set for Resident Member
DATA #1 : String, 10 bytes
totalBytes
DATA #2 : unsigned integer, 8 bytes
5720244224
DATA #3 : String, 11 bytes
dbHeapBytes
DATA #4 : unsigned integer, 8 bytes
191758336
2017-01-17-19.27.26.982778+480 E17364E473 LEVEL: Info
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:5744
MESSAGE : Crash Recovery is needed.
2017-01-17-19.27.43.089188+480 I17838E537 LEVEL: Info
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:10
DATA #1 :
Perform check to start before crash recovery clientAction:0x0 acbInfo:0x4100
2017-01-17-19.27.43.160719+480 E18376E505 LEVEL: Event
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START : DATABASE: FTPDB : ACTIVATED: NO
2017-01-17-19.27.43.173806+480 E18882E489 LEVEL: Info
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:200
MESSAGE : ADM1530I Crash recovery has been initiated.
2017-01-17-19.27.43.179110+480 I19372E1504 LEVEL: Info
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:300
DATA #1 :
Crash recovery started.
Recovery status for log stream 0
lowtranlsn: 000000000A74220A
minbufflsn: 000000000A74220A
headlsn: 000000000A74220A
streamLowTranLfsLsnDbRedo: 0/0000000000000000
recoveryStartingLFSLSN: 0/0000000000000000
initialRecoveryStartingLFSLSN: 0/0000000000000000
groupHeadLsn: 000000000A74220A
groupMinBuffLSN: 000000000A74220A
FileCount: 50
FileArray[0]: 18
HeadExtentID: 18
GroupHeadExtentID: 17
rfwdLogChainId: 0
rfwdHeadChainId: 0
numLogFilesInRecovery: 0
nextLso: 80608084673
nextLsn: 000000000A74220A
minPseudoLsn: FFFFFFFFFFFFFFFF
LastFullRecLfsLsnLso: 3454883/000000000A773C57/80694367298
LastRecLfsLsnLsoLFH: 3454883/000000000A773C57/80694367298
logTailHeartBeat: LFS/LSN: 0/0000000000000000 - 0/0000000000000000, LSO: 0
2017-01-17-19.27.43.180080+480 I20877E804 LEVEL: Info
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:1300
DATA #1 : String, 146 bytes
Crash recovery started.
Group Recovery status
groupLowTranLfsLsnDbRedo: 0/0000000000000000
globalReclaimLfsLsnDbRedo: 0/0000000000000000
DATA #2 : Global Truncation Array, PD_TYPE_SQLP_GTA, 728 bytes
idx Lfs Lsn ChainTime Signature
0 0 0000000000000000 1481960453 790770804
2017-01-17-19.27.43.188989+480 I21682E489 LEVEL: Info
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlpAllocatePRCB, probe:1182
DATA #1 :
numWOCB set to 4096.
2017-01-17-19.27.43.193023+480 I22172E537 LEVEL: Info
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlpAllocatePRCB, probe:2000
DATA #1 :
Using parallel recovery with 4 agents 9 QSets 27 queues and 0 chunks
2017-01-17-19.27.43.193572+480 I22710E1537 LEVEL: Info
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpSetRecoveryStartingPoint, probe:100
DATA #1 :
Set recovery starting point.
Recovery status for log stream 0
lowtranlsn: 000000000A74220A
minbufflsn: 000000000A74220A
headlsn: 000000000A74220A
streamLowTranLfsLsnDbRedo: 0/0000000000000000
recoveryStartingLFSLSN: 0/0000000000000000
initialRecoveryStartingLFSLSN: 0/0000000000000000
groupHeadLsn: 000000000A74220A
groupMinBuffLSN: 000000000A74220A
FileCount: 50
FileArray[0]: 18
HeadExtentID: 18
GroupHeadExtentID: 17
rfwdLogChainId: 0
rfwdHeadChainId: 0
numLogFilesInRecovery: 0
nextLso: 80608084673
nextLsn: 000000000A74220A
minPseudoLsn: FFFFFFFFFFFFFFFF
LastFullRecLfsLsnLso: 3454883/000000000A773C57/80694367298
LastRecLfsLsnLsoLFH: 3454883/000000000A773C57/80694367298
logTailHeartBeat: LFS/LSN: 0/0000000000000000 - 0/0000000000000000, LSO: 0
2017-01-17-19.27.43.196851+480 I24248E837 LEVEL: Info
PID : 8853 TID : 140128416687872 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 22 EDUNAME: db2agent (FTPDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpSetRecoveryStartingPoint, probe:1100
DATA #1 : String, 151 bytes
Set recovery starting point.
Group Recovery status
groupLowTranLfsLsnDbRedo: 0/0000000000000000
globalReclaimLfsLsnDbRedo: 0/0000000000000000
DATA #2 : Global Truncation Array, PD_TYPE_SQLP_GTA, 728 bytes
idx Lfs Lsn ChainTime Signature
0 0 0000000000000000 1481960453 790770804
2017-01-17-19.27.43.234164+480 I25086E578 LEVEL: Info
PID : 8853 TID : 140128290858752 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 52 EDUNAME: db2redom (FTPDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpParallelRecoveryCalculateShredderScanMemory, probe:300
DATA #1 :
numMembers to allocate memory for: 1
shrScanMemBytesPerWorker: 19464192
2017-01-17-19.27.43.236215+480 I25665E524 LEVEL: Info
PID : 8853 TID : 140128290858752 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 52 EDUNAME: db2redom (FTPDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlpshrScanOpen, probe:100
DATA #1 :
Starting shredder scan with 1 workers and flags 0x800004.
2017-01-17-19.27.43.260913+480 I26190E578 LEVEL: Info
PID : 8853 TID : 140128282470144 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : FTPDB
APPHDL : 0-7 APPID: 189.168.2.78.51435.170117112726
AUTHID : VPETL HOSTNAME: ftpdb
EDUID : 54 EDUNAME: db2shred (FTPDB) 0
FUNCTION: DB2 UDB, recovery manager, sqlpshrEdu, probe:100
DATA #1 :
stream: 0, startLfsLsn: 0/000000000A74220A - 0/FFFFFFFFFFFFFFFF, startLso: 0 - 18446744073709551615, flags: 0x800004
2017-01-17-19.28.55.512464+480 E26769E590 LEVEL: Severe
PID : 8851 TID : 140533506762496 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20
MESSAGE : ADM0503C An 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.
2017-01-17-19.28.55.571819+480 E27360E465 LEVEL: Error
PID : 8851 TID : 140533506762496 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:8959
DATA #1 : Process ID, 4 bytes
8853
DATA #2 : Hexdump, 8 bytes
0x00007FD081BFD1E8 : 0201 0000 0900 0000 ........
2017-01-17-19.28.55.575590+480 I27826E431 LEVEL: Info
PID : 8851 TID : 140533506762496 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5475
DATA #1 : String, 24 bytes
Process Termination Code
DATA #2 : Hex integer, 4 bytes
0x00000102
2017-01-17-19.28.55.581428+480 I28258E858 LEVEL: Event
PID : 8851 TID : 140533506762496 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10
MESSAGE : Sending SIGKILL to the following process id
DATA #1 : signed integer, 4 bytes
8871
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007FD09D9C2FC7 sqlossig + 0x167
[1] 0x000000000040FE09 _Z20sqleCleanupResourcesi + 0x959
[2] 0x000000000040F1BE _Z12sqleWatchDogm + 0x2CDE
[3] 0x000000000040C0BA DB2main + 0x166A
[4] 0x00007FD09DA3991F sqloEDUEntry + 0x87F
[5] 0x00000030320079D1 /lib64/libpthread.so.0 + 0x79D1
[6] 0x00000030318E8B6D clone + 0x6D
2017-01-17-19.28.55.593064+480 I29117E858 LEVEL: Event
PID : 8851 TID : 140533506762496 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10
MESSAGE : Sending SIGKILL to the following process id
DATA #1 : signed integer, 4 bytes
8863
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007FD09D9C2FC7 sqlossig + 0x167
[1] 0x000000000040FE63 _Z20sqleCleanupResourcesi + 0x9B3
[2] 0x000000000040F1BE _Z12sqleWatchDogm + 0x2CDE
[3] 0x000000000040C0BA DB2main + 0x166A
[4] 0x00007FD09DA3991F sqloEDUEntry + 0x87F
[5] 0x00000030320079D1 /lib64/libpthread.so.0 + 0x79D1
[6] 0x00000030318E8B6D clone + 0x6D
2017-01-17-19.28.55.933609+480 I29976E403 LEVEL: Event
PID : 8851 TID : 140533506762496 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, oper system services, sqloCleanUpPosixIPCResources, probe:100
MESSAGE : Clean up POSIX resources attempt from engine.
2017-01-17-19.28.55.934089+480 I30380E404 LEVEL: Event
PID : 8851 TID : 140533506762496 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, oper system services, sqloCleanUpSystemVIPCResources, probe:1570
DATA #1 :
Remove trace memory segments
2017-01-17-19.28.56.964037+480 I30785E426 LEVEL: Severe
PID : 8859 TID : 140533506762496 PROC : db2ckpwd 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:110
DATA #2 : Hexdump, 4 bytes
0x00007FD081BFB140 : 4200 0F87 B...
2017-01-17-19.28.56.964014+480 I31212E426 LEVEL: Severe
PID : 8860 TID : 140533506762496 PROC : db2ckpwd 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:110
DATA #2 : Hexdump, 4 bytes
0x00007FD081BFB140 : 4200 0F87 B...
2017-01-17-19.28.56.964520+480 I31639E426 LEVEL: Severe
PID : 8861 TID : 140533506762496 PROC : db2ckpwd 0
INSTANCE: db2inst1 NODE : 000
HOSTNAME: ftpdb
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:110
DATA #2 : Hexdump, 4 bytes
0x00007FD081BFB140 : 4200 0F87 B...