WEB开发网
开发学院数据库DB2 诊断 DB2 Java 应用程序的性能问题 (2) 阅读

诊断 DB2 Java 应用程序的性能问题 (2)

 2008-09-16 16:29:15 来源:WEB开发网   
核心提示: 清单 30. CALL TEST_JAVASP(11)的 DRDA 跟踪51714data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177)pid 2088 tid 2484 cpid 526 node 0

清单 30. CALL TEST_JAVASP(11)的 DRDA 跟踪

51714  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 816354478 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 0B000000              ....       ....
 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)
    00000B000000            ......      ......

上一页  1 2 3 4 5 6 7 8  下一页

Tags:诊断 DB Java

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接