The following figures show sample output illustrating some DRDA® data streams exchanged between DB2 Connect™ workstations and a host or System i™ database server. From the user's viewpoint, a CONNECT TO database command has been issued using the command line processor (CLP).
Figure 1 uses DB2 Connect Enterprise Edition Version 9.1 and DB2® Universal Database (UDB) for z/OS® Version 8 over a TCP/IP connection.
Figure 1. Example of Trace Output (TCP/IP connection)1 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 0 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 233
2 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177)
pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 19532 probe 1177 bytes 250
SEND BUFFER(AR):
EXCSAT RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 00C3D041000100BD 1041007F115E8482 ...A.....A...^.. .C}........".;db 0010 F282974040404040 4040404040404040 ...@@@@@@@@@@@@@ 2bp
0020 4040F0F0F0C3F5F0 C3C3F0F0F0000000 @@.............. 000C50CC000... 0030 0000000000000000 0000000000000000 ................ ................ 0040 0000000000000000 000000000060F0F0 .............`.. .............-00 0050 F0F1A2A495404040 4040404040404040 .....@@@@@@@@@@@ 01sun
0060 4040404040404040 4040404040404040 @@@@@@@@@@@@@@@@
0070 C4C5C3E5F8404040 F0A2A49540404040 .....@@@....@@@@ DECV8 0sun
0080 4040404040404040 4000181404140300 @@@@@@@@@....... ....... 0090 0724070008147400 05240F0008144000 .$....t..$....@. .............. . 00A0 08000E1147D8C4C2 F261C1C9E7F6F400 ....G....a...... .....QDB2/AIX64. 00B0 08116D9481A29200 0C115AE2D8D3F0F9 ..m.......Z..... .._mask...]SQL09 00C0 F0F0F0 ... 000
ACCSEC RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 0026D00100020020 106D000611A20003 .&..... .m...... ..}......_...s.. 0010 00162110E2E3D3C5 C3F1404040404040 ..!.......@@@@@@ ....STLEC1
0020 404040404040 @@@@@@
3 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 110546200 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 105
4 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178)
pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 110549755 probe 1178 bytes 122
RECEIVE BUFFER(AR):
EXCSATRD OBJDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 0059D04300010053 1443000F115EE5F8 .Y.C...S.C...^.. ..}..........;V8 0010 F1C14BE2E3D3C5C3 F100181404140300 ..K............. 1A.STLEC1....... 0020 0724070007147400 05240F0007144000 .$....t..$....@. .............. . 0030 0700081147D8C4C2 F20014116DE2E3D3 ....G.......m... .....QDB2..._STL 0040 C5C3F14040404040 4040404040000C11 ...@@@@@@@@@@... EC1 ... 0050 5AC4E2D5F0F8F0F1 F5 Z........ ]DSN08015
ACCSECRD OBJDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 0010D0030002000A 14AC000611A20003 ................ ..}..........s..
5 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 110656806 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 233
Figure 2. Example of Trace Output (TCP/IP connection) continued
6 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177)
pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 110659711 probe 1177 bytes 250
SEND BUFFER(AR):
SECCHK RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 003CD04100010036 106E000611A20003 .<.A...6.n...... ..}......>...s.. 0010 00162110E2E3D3C5 C3F1404040404040 ..!.......@@@@@@ ....STLEC1
0020 404040404040000C 11A1D9858799F485 @@@@@@.......... ....Regr4e 0030 A599000A11A09585 A6A39695 ............ vr....newton
ACCRDB RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 00ADD001000200A7 20010006210F2407 ........ ...!.$. ..}....x........ 0010 00172135C7F9F1C1 F0C4F3C14BD7C1F8 ..!5........K... ....G91A0D3A.PA8 0020 F806030221064600 162110E2E3D3C5C3 ....!.F..!...... 8..........STLEC 0030 F140404040404040 4040404040000C11 .@@@@@@@@@@@@... 1 ... 0040 2EE2D8D3F0F9F0F0 F0000D002FD8E3C4 ............/... .SQL09000....QTD 0050 E2D8D3C1E2C30016 00350006119C0333 .........5.....3 SQLASC.......... 0060 0006119D04B00006 119E0333003C2104 ...........3.
7 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 259908001 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 176
8 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178)
pid 807116 tid 1 cpid -1 node 0 sec 0 nsec 259911584 probe 1178 bytes 193
RECEIVE BUFFER(AR):
SECCHKRM RPYDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 0015D0420001000F 1219000611490000 ...B.........I.. ..}............. 0010 000511A400 ..... ...u.
ACCRDBRM RPYDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 009BD00200020095 2201000611490000 ........"....I.. ..}....n........ 0010 000D002FD8E3C4E2 D8D3F3F7F0000C11 .../............ ....QTDSQL370... 0020 2EC4E2D5F0F8F0F1 F500160035000611 ............5... .DSN08015....... 0030 9C04B80006119E04 B80006119D04B000 ................ ................ 0040 0C11A0D5C5E6E3D6 D540400006212524 .........@@..!%$ ...NEWTON ..... 0050 34001E244E000624 4C00010014244D00 4..$N..$L....$M. ....+...<.....(. 0060 06244FFFFF000A11 E8091E768301BE00 .$O........v.... ..!.....Y...c... 0070 2221030000000005 68B3B8C7F9F1C1F0 "!......h....... ...........G91A0 0080 C4F3C1D7C1F8F840 4040400603022106 .......@@@@...!. D3APA88 ..... 0090 46000A11E8091E76 831389 F......v... ....Y...c.i
9 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 2 nsec 364420503 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 10
Figure 3. Example of Trace Output (TCP/IP connection) continued
10 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177)
pid 807116 tid 1 cpid -1 node 0 sec 2 nsec 364440751 probe 1177 bytes 27
SEND BUFFER(AR):
RDBCMM RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 000AD00100010004 200E ........ . ..}.......
11 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 2 nsec 475009631 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 54
12 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178)
pid 807116 tid 1 cpid -1 node 0 sec 2 nsec 475014579 probe 1178 bytes 71
RECEIVE BUFFER(AR):
ENDUOWRM RPYDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 002BD05200010025 220C000611490004 .+.R...%"....I.. ..}............. 0010 00162110E2E3D3C5 C3F1404040404040 ..!.......@@@@@@ ....STLEC1
0020 4040404040400005 211501 @@@@@@..!.. .....
SQLCARD OBJDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 000BD00300010005 2408FF ........$.. ..}........
13 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 721710319 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 126
14 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177)
pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 721727276 probe 1177 bytes 143
SEND BUFFER(AR):
EXCSQLIMM RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 0053D0510001004D 200A00442113E2E3 .S.Q...M ..D!... ..}....(......ST 0010 D3C5C3F140404040 4040404040404040 ....@@@@@@@@@@@@ LEC1
0020 D5E4D3D3C9C44040 4040404040404040 ......@@@@@@@@@@ NULLID
0030 4040E2D8D3C3F2C6 F0C1404040404040 @@........@@@@@@ SQLC2F0A
0040 4040404041414141 41484C5600CB0005 @@@@AAAAAHLV.... ......<..... 0050 2105F1 !.. ..1
SQLSTT OBJDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 002BD00300010025 2414000000001B64 .+.....%$......d ..}............. 0010 656C657465206672 6F6D206464637375 elete from ddcsu .%......?_...... 0020 73312E6D79746162 6C65FF s1.mytable. ..._`./.%..
15 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 832901261 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 102
Figure 4. Example of Trace Output (TCP/IP connection) continued
16 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178)
pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 832906528 probe 1178 bytes 119
RECEIVE BUFFER(AR):
SQLCARD OBJDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 0066D00300010060 240800FFFFFF3434 .f.....`$.....44 ..}....-........ 0010 3237303444534E58 4F544C2000FFFFFE 2704DSNXOTL .... ......+.!.<..... 0020 0C00000000000000 00FFFFFFFF000000 ................ ................ 0030 0000000000572020 2057202020202020 .....W W ................ 0040 001053544C454331 2020202020202020 ..STLEC1 ....<........... 0050 2020000F44444353 5553312E4D595441 ..DDCSUS1.MYTA ............(... 0060 424C450000FF BLE... .<....
17 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.100) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 833156953 probe 100 bytes 16 Data1 (PD_TYPE_UINT,8) unsigned integer: 10
18 data DB2 UDB DRDA Communication Manager sqljcSend fnc (3.3.54.5.0.1177)
pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 833159843 probe 1177 bytes 27
SEND BUFFER(AR):
RDBRLLBCK RQSDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 000AD00100010004 200F ........ . ..}.......
19 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.100) pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 943302832 probe 100 bytes 12 Data1 (PD_TYPE_UINT,4) unsigned integer: 54
20 data DB2 UDB DRDA Communication Manager sqljcReceive fnc (3.3.54.3.0.1178)
pid 807116 tid 1 cpid -1 node 0 sec 5 nsec 943306288 probe 1178 bytes 71
RECEIVE BUFFER(AR):
ENDUOWRM RPYDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 002BD05200010025 220C000611490004 .+.R...%"....I.. ..}............. 0010 00162110E2E3D3C5 C3F1404040404040 ..!.......@@@@@@ ....STLEC1
0020 4040404040400005 211502 @@@@@@..!.. .....
SQLCARD OBJDSS (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF 0000 000BD00300010005 2408FF ........$.. ..}........
Parent topic: DRDA traces
Related reference
Subsequent buffer information for DRDA traces