Trace output file samples

When running a DRDA trace, you receive an output file with information about current DRDA operations in the database. You can use this information to troubleshoot your database.

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® for z/OS® Version 8 over a TCP/IP connection.

Figure 1. Example of Trace Output (TCP/IP connection)
1	data Db2 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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             ........$..       ..}........