诊断 DB2 Java 应用程序的性能问题 (2)
2008-09-16 16:29:15 来源:WEB开发网我们看到 SEND (AR),它是客户机上的发送缓冲区。SQLDTA(SQL 数据结构)显示,我们以 9 作为 CALL TEST_JAVASP(?) 中的参数占位符的值。
清单 28. CALL TEST_JAVASP(10) 的 DRDA 跟踪
50460 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177)
pid 2088 tid 2484 cpid 526 node 0 sec 223546 nsec 533380764 probe 1177
bytes 174
SEND BUFFER(AR):
EXCSQLSTT RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 0079D05100010073 200B004421135341 .y.Q...s ..D!.SA .`}.............
0010 4D504C4520202020 2020202020202020 MPLE (&<.............
0020 4E554C4C49442020 2020202020202020 NULLID +.<<............
0030 2020535953534832 3030202020202020 SYSSH200 ................
0040 202020205359534C 564C303100040005 SYSLVL01.... .......<.<......
0050 2105F100052111F1 0008211400007FFF !....!....!..... ..1....1......".
0060 00062141FFFF0006 2140FFFF00052142 ..!A....!@....!B ......... ......
0070 C000081900800000 00 ......... {........
SQLDTA OBJDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 0024D0030001001E 2412001000100676 .$......$......v ..}.............
0010 D00300040671E4D0 0001000A147A0000 .....q.......z.. }.....U}.....:..
0020 0A000000 .... ....
SEND(AR) RQSDSS - Request Data Stream Structure
LL: 121 CORR: 0001 CHAINED: y CONT ON ERR: n SAME CORR FOR NEXT DSS: y
NM: EXCSQLSTT - Execute SQL Statement
LL: 115 CP: 200B
NM: PKGNAMCSN - RDB Pkg Name, Const Tkn & Sec Num
LL: 68 CP: 2113
* RDBNAM - Relational Database Name
ASCII: SAMPLE
EBCDIC: ..(&<.............
* RDBCOLID - RDB Collection Identifier
ASCII: NULLID
EBCDIC: +.<<..............
* PKGID - RDB Package Identifier
ASCII: SYSSH200
EBCDIC: ..................
* PKGCNSTKN - RDB Package Consistency Token
DATA: (ASCII) (EBCDIC)
5359534C564C3031 SYSLVL01 ...<.<..
* PKGSN - RDB Package Section Number
DECIMAL: 4
HEXADECIMAL: 0004
NM: RDBCMTOK - RDB Commit Allowed
LL: 5 CP: 2105
BOOLEAN: TRUE
NM: OUTEXP - Output Expected
LL: 5 CP: 2111
BOOLEAN: TRUE
NM: QRYBLKSZ - Query Block Size
LL: 8 CP: 2114
DECIMAL: 32767
HEXADECIMAL: 00007FFF
NM: MAXBLKEXT - Maximum Number of Extra Blocks
LL: 6 CP: 2141
DECIMAL: -1
HEXADECIMAL: FFFFFFFF
NM: MAXRSLCNT - Maximum Result Set Count
LL: 6 CP: 2140
DECIMAL: -1
HEXADECIMAL: FFFFFFFF
NM: RSLSETFLG - Result Set Flags
LL: 5 CP: 2142
FLAG: 0XC0Return Names, Return Labels,
NM: MONITOR - Monitor
LL: 8 CP: 1900
DECIMAL: -2147483648
HEXADECIMAL: 80000000
SEND(AR) OBJDSS - Object Data Stream Structure
LL: 36 CORR: 0001 CHAINED: n CONT ON ERR: n SAME CORR FOR NEXT DSS: n
NM: SQLDTA - SQL Program Variable Data
LL: 30 CP: 2412
NM: FDODSC - FD:OCA Data Descriptor
LL: 16 CP: 0010
N-GDA Len: 06 Type: 76 ID: D0
Var[00] Type: 0X03 Len: 0X0004
Footer: Length: 6
DATA: (ASCII) (EBCDIC)
0671E4D00001 .q.... ..U}..
NM: FDODTA - FD:OCA Data
LL: 10 CP: 147A
DATA: (ASCII) (EBCDIC)
00000A000000 ...... ......
更多精彩
赞助商链接