トレース出力ファイル・サンプル
DRDA トレースを実行すると、データベース内の現行 DRDA 操作に関する情報を含む出力ファイルを受け取ります。 この情報を使用して、データベースのトラブルシューティングを行うことができます。
次の図は、Db2ConnectワークステーションとホストまたはSystem iデータベースサーバー間で交換されるDRDAデータストリームの出力例を示しています。 ユーザーの観点から、 コマンド行プロセッサー (CLP) を使用して CONNECT TO データベース・コマンドが発行されました。
図1は、 Db2 Connect Enterprise Edition バージョン 9.1 および Db2 for z/OS バージョン 8 を TCP/IP 接続で使用しています。
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:
2332 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:
1054 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:
2336 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:
1768 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.i9 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:
1010 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:
5412 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:
12614 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:
10216 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:
1018 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:
5420 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 ........$.. ..}........