学习trace跟踪1040N错误
db2diag.告警日志
2013-12-17-09.35.53.280010-300 I4300E461 LEVEL: Severe
PID : 12060 TID : 47144564156736PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-599 APPID: *LOCAL.db2inst1.131217143553
AUTHID : DB2INST1
EDUID : 133 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::SubsequentConnect, probe:40
RETCODE : ZRC=0xFFFFFBF0=-1040
从告警日志看时EDUID 133,调用函数sqeLocalDatabase 出错,
于是查看flw格式化后的文件
31836 0.007373000 | | | | | | | | | | | | | | sqeLocalDatabase::SubsequentConnect entry [eduid 133 eduname db2agent]
31837 0.007374000 | | | | | | | | | | | | | | | hdrCheckDb entry [eduid 133 eduname db2agent]
31838 0.007374000 | | | | | | | | | | | | | | | hdrCheckDb exit
31839 0.007374000 | | | | | | | | | | | | | | | sqleCheckMaxApplications entry [eduid 133 eduname db2agent]
31840 0.007375000 | | | | | | | | | | | | | | | sqleCheckMaxApplications exit
31841 0.007376000 | | | | | | | | | | | | | | | sqeLocalDatabase::RegisterApp entry [eduid 133 eduname db2agent]
31842 0.007376000 | | | | | | | | | | | | | | | | sqeDatabase::RegisterApp entry [eduid 133 eduname db2agent]
31843 0.007377000 | | | | | | | | | | | | | | | | | sqlogmt2 entry [eduid 133 eduname db2agent]
31844 0.007377000 | | | | | | | | | | | | | | | | | sqlogmt2 exit
31845 0.007377000 | | | | | | | | | | | | | | | | sqeDatabase::RegisterApp exit
.........
66030 6.112144000 | | | | | | | | | | | | | | | sqleCheckMaxApplications entry [eduid 133 eduname db2agent]
66031 6.112146000 | | | | | | | | | | | | | | | sqleCheckMaxApplications error [probe 400]
66032 6.112146000 | | | | | | | | | | | | | | | sqleCheckMaxApplications exit [rc = 0xFFFFFBF0 = -1040]
可以查看fmt格式化的文件 第66032行的详细信息
66032 exit DB2 UDB base sys utilities sqleCheckMaxApplications fnc (2.3.5.22.0)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112146000
rc = 0xFFFFFBF0 = -1040
66033 entry DB2 UDB trace services sqlt_logerr_zrc cei (1.3.20.22.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112147000
eduid 133 eduname db2agent
66034 data DB2 UDB trace services sqlt_logerr_zrc cei (3.3.20.22.2.10)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112147000 probe 10
bytes 12
Data1 (PD_TYPE_DEFAULT,4) Hexdump:66047 data DB2 UDB trace services sqltGetDiagPath cei (3.3.20.5.2.10)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112155000 probe 10
bytes 41
Data1 (PD_TYPE_DEFAULT,33) Hexdump:
2F64 6232 686F 6D65 2F64 6232 696E 7374 /db2home/db2inst
312F 7371 6C6C 6962 2F64 6232 6475 6D70 1/sqllib/db2dump
2F /
。。。。。
66048 exit DB2 UDB trace services sqltGetDiagPath cei (2.3.20.5.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112155000
rc = 0
66049 data DB2 UDB RAS/PD component pdLogInternal fnc (3.3.134.9.0.130)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112156000 probe 130
bytes 120
Data1 (PD_TYPE_BITMASK,8) Bitmask:
0x0000000000000001
Data2 (PD_TYPE_ECFID,4) Function:
DB2 UDB, base sys utilities, sqeLocalDatabase::SubsequentConnect
Data3 (PD_TYPE_HEXINT,8) Hex integer:
0x0000000000000000
Data4 (PD_TYPE_ECFID,4) Function:
<0>, <0>, <0>
Data5 (PD_TYPE_HEXINT,8) Hex integer:
0x02100000FFFFFBF0
Data6 (PD_TYPE_UINT,8) unsigned integer:
40
Data7 (PD_TYPE_UINT,8) unsigned integer:
1
Data8 (PD_TYPE_UINT,8) unsigned integer:
0 F0FB FFFF ....
。。。。。。
申请db2diag.log写告警信息
66070 mbt DB2 UDB oper system services sqloopenp cei (6.3.15.823.2.32769)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112180000
Marker:PD_SQO_OPEN_WRITE_FOR_SHARED_LOCK
Description: The file mode is being switch to read/write in order to lock the file
66071 entry DB2 UDB oper system services sqloflock cei (1.3.15.725.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112184000
eduid 133 eduname db2agent
bytes 34
Data1 (PD_TYPE_SQO_FILE_HDL,8) File handle:
File Handle = 20
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = No
Write-through Mode = No
File Not Tracked = No
Data2 (PD_TYPE_HEXINT,1) Hex integer:
0x01
Data3 (PD_TYPE_HEXINT,1) Hex integer:
0x03
66072 exit DB2 UDB oper system services sqloflock cei (2.3.15.725.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112185000
rc = 0
66073 exit DB2 UDB oper system services sqloopenp cei (2.3.15.823.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112185000
codepath = 5:6:7:15:51:52
rc = 0x070F00CB = 118423755 = SQLO_FREV
bytes 16
Data1 (PD_TYPE_SQO_FILE_HDL,8) File handle:
File Handle = 20
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = No
Write-through Mode = No
File Not Tracked = No
66074 entry DB2 UDB oper system services sqloSigMask fnc (1.3.15.1211.0)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112186000
eduid 133 eduname db2agent
66075 exit DB2 UDB oper system services sqloSigMask fnc (2.3.15.1211.0)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112186000
rc = 0
66076 entry DB2 UDB oper system services sqlochgfileptr cei (1.3.15.665.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112187000
eduid 133 eduname db2agent
bytes 44
Data1 (PD_TYPE_SQO_FILE_HDL,8) File handle:
File Handle = 20
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = No
Write-through Mode = No
File Not Tracked = No
Data2 (PD_TYPE_UINT,4) unsigned integer:
2
Data3 (PD_TYPE_FILE_OFFSET,8) File Offset:
0
66077 exit DB2 UDB oper system services sqlochgfileptr cei (2.3.15.665.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112188000
rc = 0
bytes 16
Data1 (PD_TYPE_FILE_OFFSET,8) File Offset:
4299
66078 data DB2 UDB RAS/PD component pdLogInternal fnc (3.3.134.9.0.100)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112227000 probe 100
bytes 12
Data1 (PD_TYPE_HEXDUMP,4) Hexdump:
F0FB FFFF ....
66079 entry DB2 UDB global services sqlzGetZRCInfo cei (1.3.26.1.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112249000
eduid 133 eduname db2agent
66080 exit DB2 UDB global services sqlzGetZRCInfo cei (2.3.26.1.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112249000
rc = 0xFFFFFC7B = -901
66081 entry DB2 UDB oper system services sqlowrite cei (1.3.15.895.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112251000
eduid 133 eduname db2agent
bytes 48
Data1 (PD_TYPE_SQO_FILE_HDL,8) File handle:
File Handle = 20
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = No
Write-through Mode = No
File Not Tracked = No
Data2 (PD_TYPE_HEXDUMP,8) Hexdump:
808B E0A4 E02A 0000 .....*..
Data3 (PD_TYPE_UINT,8) unsigned integer:
462
66082 exit DB2 UDB oper system services sqlowrite cei (2.3.15.895.2)
pid 12060 tid 47144564156736 cpid 773 node 0 sec 6 nsec 112263000
rc = 0
bytes 486
Data1 (PD_TYPE_HEXDUMP,462) Hexdump:
0A32 3031 332D 3132 2D31 372D 3039 2E33 .2013-12-17-09.3
352E 3533 2E32 3830 3031 302D 3330 3020 5.53.280010-300
4934 3330 3045 3436 3120 2020 2020 2020 I4300E461
2020 2020 4C45 5645 4C3A 2053 6576 6572 LEVEL: Sever
650A 5049 4420 2020 2020 3A20 3132 3036 e.PID : 1206
3020 2020 2020 2020 2020 2020 2020 2020 0
2054 4944 2020 3A20 3437 3134 3435 3634 TID : 47144564
3135 3637 3336 5052 4F43 203A 2064 6232 156736PROC : db2
7379 7363 2030 0A49 4E53 5441 4E43 453A sysc 0.INSTANCE:
2064 6232 696E 7374 3120 2020 2020 2020 db2inst1
2020 2020 2020 4E4F 4445 203A 2030 3030 NODE : 000
2020 2020 2020 2020 2020 4442 2020 203A DB :
2053 414D 504C 450A 4150 5048 444C 2020 SAMPLE.APPHDL
3A20 302D 3539 3920 2020 2020 2020 2020 : 0-599
2020 2020 2020 2041 5050 4944 3A20 2A4C APPID: *L
4F43 414C 2E64 6232 696E 7374 312E 3133 OCAL.db2inst1.13
3132 3137 3134 3335 3533 0A41 5554 4849 1217143553.AUTHI
4420 203A 2044 4232 494E 5354 310A 4544 D : DB2INST1.ED
5549 4420 2020 3A20 3133 3320 2020 2020 UID : 133
2020 2020 2020 2020 2020 2020 2045 4455 EDU
4E41 4D45 3A20 6462 3261 6765 6E74 2028 NAME: db2agent (
5341 4D50 4C45 2920 300A 4655 4E43 5449 SAMPLE) 0.FUNCTI
4F4E 3A20 4442 3220 5544 422C 2062 6173 ON: DB2 UDB, bas
6520 7379 7320 7574 696C 6974 6965 732C e sys utilities,
2073 7165 4C6F 6361 6C44 6174 6162 6173 sqeLocalDatabas
653A 3A53 7562 7365 7175 656E 7443 6F6E e::SubsequentCon
6E65 6374 2C20 7072 6F62 653A 3430 0A52 nect, probe:40.R
4554 434F 4445 203A 205A 5243 3D30 7846 ETCODE : ZRC=0xF
4646 4646 4246 303D 2D31 3034 300A FFFFBF0=-1040.
Data2 (PD_TYPE_UINT,8) unsigned integer:
0