Skip to content

Instantly share code, notes, and snippets.

@neuro-sys

neuro-sys/db2diag.log

Created February 18, 2013 10:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save neuro-sys/4976415 to your computer and use it in GitHub Desktop.
Save neuro-sys/4976415 to your computer and use it in GitHub Desktop.
Download ZIP
db2diag.log
Raw
db2diag.log
2013-02-18-12.14.24.675378+120 E55288E468 LEVEL: Event
PID : 27388 TID : 140038633416448PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : JFCRM03
APPHDL : 0-12 APPID: GA000102.PD2E.130218101425
AUTHID : DB2INST1
EDUID : 20 EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP : DATABASE: JFCRM03 : DEACTIVATED: NO
2013-02-18-12.16.17.939695+120 I55757E1636 LEVEL: Event
PID : 27498 TID : 140363412481824PROC : db2stop
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0x00007FFFE8072A50 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x00007FFFE8072A60 : 716C 6C69 622F 6164 6D2F 6462 3273 746F qllib/adm/db2sto
0x00007FFFE8072A70 : 7032 0053 4E00 0000 0000 0000 0000 0000 p2.SN...........
0x00007FFFE8072A80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072A90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072AA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072AB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072AC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072AD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072AE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072AF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072B00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072B10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072B20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072B30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFFE8072B40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-02-18-12.16.18.004079+120 I57394E390 LEVEL: Event
PID : 27500 TID : 140232805775136PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0x00007FFFF2743F10 : 0100 0000 ....
2013-02-18-12.16.18.004356+120 I57785E410 LEVEL: Event
PID : 27500 TID : 140232805775136PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
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
0x00007FFFF2743F10 : 0100 0000 ....
2013-02-18-12.16.18.004407+120 I58196E291 LEVEL: Event
PID : 27500 TID : 140232805775136PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2013-02-18-12.16.18.004454+120 I58488E306 LEVEL: Event
PID : 27500 TID : 140232805775136PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2013-02-18-12.16.18.013859+120 I58795E429 LEVEL: Error
PID : 27388 TID : 140038650193664PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 16 EDUNAME: db2tcpcm
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:155
MESSAGE : DIA3208E Error encountered in TCP/IP protocol support. TCP/IP
function "close". Socket was "5". Errno was "9".
2013-02-18-12.16.18.015048+120 I59225E308 LEVEL: Event
PID : 27500 TID : 140232805775136PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2013-02-18-12.16.18.015109+120 I59534E329 LEVEL: Event
PID : 27500 TID : 140232805775136PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:270
DATA #1 : String, 26 bytes
Active EDUs to be waited :
DATA #2 : unsigned integer, 4 bytes
1
2013-02-18-12.16.18.020597+120 I59864E453 LEVEL: Warning
PID : 27386 TID : 140445455738624PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x00007FBC017FC1E0 : 0000 0000 ....
2013-02-18-12.16.18.025256+120 I60318E327 LEVEL: Event
PID : 27500 TID : 140232805775136PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
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
2013-02-18-12.16.18.186908+120 E60646E305 LEVEL: Event
PID : 27500 TID : 140232805775136PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2013-02-18-12.16.18.193546+120 I60952E297 LEVEL: Event
PID : 27498 TID : 140363412481824PROC : db2stop
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:190
DATA #1 : <preformatted>
Single node stopped [-1064].
2013-02-18-12.16.19.808009+120 I61250E305 LEVEL: Event
PID : 27501 TID : 140461721798432PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:21
DATA #1 : <preformatted>
Single node instance [0] is starting
2013-02-18-12.16.19.808249+120 I61556E1637 LEVEL: Event
PID : 27501 TID : 140461721798432PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x00007FFF5AB3B9F0 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x00007FFF5AB3BA00 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0x00007FFF5AB3BA10 : 7232 0000 0000 0000 0000 0000 0000 0000 r2..............
0x00007FFF5AB3BA20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BA30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BA40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BA50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BA60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BA70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BA80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BA90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BAA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BAB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BAC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BAD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF5AB3BAE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2013-02-18-12.16.19.880726+120 E63194E314 LEVEL: Info
PID : 27503 TID : 139724971108128PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloKADetermineKernelIntegrity, probe:30
DATA #1 : <preformatted>
Indeterminable operating system.
2013-02-18-12.16.19.881105+120 E63509E271 LEVEL: Severe
PID : 27503 TID : 139724971108128PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloKAAnalyze, probe:10
DATA #1 : Codepath, 8 bytes
5
2013-02-18-12.16.19.962685+120 E63781E1403 LEVEL: Event
PID : 27505 TID : 140531619325696PROC : db2syscr
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1
START : DB2 DBM
DATA #1 : Build Level, 152 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL09071"
with level identifier "08020107".
Informational tokens are "DB2 v9.7.0.1", "s091114", "IP23034", Fix Pack "1".
DATA #2 : System Info, 440 bytes
System: Linux portal 6 2 x86_64
CPU: total:2 online:2 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:2010 free:306
Virtual Memory(MB): total:5762 free:4052
Swap Memory(MB): total:3752 free:3746
Kernel Params: msgMaxMessageSize:65535 msgMsgMap:65536 msgMaxQueueIDs:4016
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:1073741824 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds) = 0xFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFF
Cur data size (bytes) = 0xFFFFFFFF
Cur stack size (bytes) = 0x00800000
Cur core size (bytes) = 0x00000000
Cur memory size (bytes) = 0xFFFFFFFF
nofiles (descriptors) = 0x00000800
2013-02-18-12.16.20.055905+120 E65185E334 LEVEL: Warning
PID : 27507 TID : 140559654053632PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:18
DATA #1 : String, 28 bytes
Memory usage is limited to:
DATA #2 : signed integer, 8 bytes
2147483648
2013-02-18-12.16.20.071425+120 I65520E531 LEVEL: Event
PID : 27507 TID : 140559654053632PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
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 925712 bytes.
2013-02-18-12.16.20.072702+120 I66052E540 LEVEL: Event
PID : 27507 TID : 140559654053632PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10
START : Starting FCM Channel Manager
1 resource group(s).
1024 channels allocated.
Maximum number of channels supported is 8192.
Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 1441816 bytes.
2013-02-18-12.16.20.074446+120 I66593E537 LEVEL: Event
PID : 27507 TID : 140559654053632PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
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 1687552 bytes.
2013-02-18-12.16.20.076014+120 I67131E418 LEVEL: Event
PID : 27507 TID : 140559654053632PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
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
2013-02-18-12.16.21.099219+120 E67550E306 LEVEL: Event
PID : 27503 TID : 139724971108128PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment