On 9/17/14 11:00 PM, Rocky.Hu wrote:
>
> Hi:
>
> I had been add the derby.properties file into the
> %DERBY_HOME%\bin，and I used the Derby in client/server mode, when I
> started and visited the database, it also procedure a file named
> Server1.trace in the %DERBY_HOME%\bin, but I opened the file, I
> couldn’t get any information because it was garbled, so how can I
> viewed the trace?
>
> Thanks,
>
> Rocky
>
Hi Rocky,
Not sure what you are seeing. I've attached a trace file which shows
what I get when I start a server with -Dderby.drda.traceAll=true. Can
you attach a trace file which shows garbling?
Thanks,
-Rick
(2014.9.23 5:19:3) Request fill DRDAConnThread_2 5
RECEIVE BUFFER: EXCSAT (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 0072D0410001006C 10410010115E8485 .r.A...l.A...^.. ..}....%.....;de
0010 9982A88495839481 89950009116DC485 .............m.. rbydncmain..._De
0020 9982A80029115AC4 D5C3F1F0F1F2F061 ....).Z........a rby...!DNC10120/
0030 F1F04BF1F24BF04B F040819397888140 ..K..K.K.@.....@ 10.12.0.0 alpha
0040 60404DF1F6F2F6F8 F0F7D45D00181404 `@M........].... - (1626807M)....
0050 1403000724070007 240F000714400007 ....$...$....@.. ............. ..
0060 1C0804B8000E1147 D8C4C5D9C2E861D1 .......G......a. ........QDERBY/J
0070 E5D4002AD0010002 0024106D000611A2 ...*.....$.m.... VM..}......_...s
0080 0004001A21109485 949699A87A8482F1 ....!.......z... ......memory:db1
0090 5E83998581A3857E A399A485 ^......~.... ;create=true
(2014.9.23 5:19:3) Reply flush DRDAConnThread_2 5
SEND BUFFER: EXCSATRD (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 0090D0420001008A 1443001D115ED585 ...B.....C...^.. ..}..........;Ne
0010 A3A6969992E28599 A58599C39695A399 ................ tworkServerContr
0020 9693409481899500 1814041403000724 ..@............$ ol main.........
0030 070007240F000714 4000071C0804B800 ...$....@....... ........ .......
0040 101147C197818388 8540C4859982A800 ..G......@...... ...Apache Derby.
0050 18116DD585A3A696 9992E28599A58599 ..m............. .._NetworkServer
0060 C39695A399969300 29115AC3E2E2F1F0 ........).Z..... Control...!CSS10
0070 F1F2F061F1F04BF1 F24BF04BF0408193 ...a..K..K.K.@.. 120/10.12.0.0 al
0080 9788814060404DF1 F6F2F6F8F0F7D45D ...@`@M........] pha - (1626807M)
0090 0010D0020002000A 14AC000611A20004 ................ ..}..........s..
(2014.9.23 5:19:3) Request fill DRDAConnThread_2 5
RECEIVE BUFFER: SECCHK (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 0031D0410001002B 106E000611A20004 .1.A...+.n...... ..}......>...s..
0010 001A21106D656D6F 72793A6462313B63 ..!.memory:db1;c ...._._?.`......
0020 72656174653D7472 7565000711A04150 reate=true....AP ../............&
0030 5000ACD001000200 A62001001A21106D P........ ...!.m &..}....w......_
0040 656D6F72793A6462 313B637265617465 emory:db1;create ._?.`......../..
0050 3D74727565000621 0F2407000C112E44 =true..!.$.....D ................
0060 4E43313031323000 3C210437C4D5C3F1 NC10120.<!.7.... +...........DNC1
0070 F0F1F2F0D1E5D440 4040404040404040 .......@@@@@@@@@ 0120JVM
0080 4040404040408485 9982A88495839481 @@@@@@.......... derbydncma
0090 8995404040404040 4040404040404040 ..@@@@@@@@@@@@@@ in
00A0 404000000D002F51 544453514C415343 @@..../QTDSQLASC ..........<...
00B0 00172135D5C6F0F0 F0F0F0F12EC5F1C4 ..!5............ ....NF000001.E1D
00C0 F60148A273628400 1600350006119C04 ..H.sb....5..... 6..s..d.........
00D0 B80006119D04B000 06119E04B8 ............. .............
(2014.9.23 5:19:5) Reply flush DRDAConnThread_2 5
SEND BUFFER: SECCHKRM (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 000511A4000039D0 5200020033220100 ......9.R...3".. ...u...}........
0020 0611490000000C11 2E43535331303132 ..I......CSS1012 ................
0030 30000D002F515444 53514C4153430010 0.../QTDSQLASC.. ..........<.....
0040 00350006119C04B8 0006119E04B80016 .5.............. ................
0050 D00200020010C000 0005C001020007C0 ................ }.....{...{....{
0060 02415050 .APP ..&&
(2014.9.23 5:19:5) Request fill DRDAConnThread_2 5
RECEIVE BUFFER: EXCSQLIMM (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 005DD05100010057 200A004E21130016 .].Q...W ..N!... .)}........+....
0010 6D656D6F72793A64 62313B6372656174 memory:db1;creat _._?.`......../.
0020 653D747275650012 4E554C4C49442020 e=true..NULLID ........+.<<....
0030 2020202020202020 202000125359534C ..SYSL ...............<
0040 4830303020202020 2020202020205359 H000 SY ................
0050 534C564C30310001 00052105F10027D0 SLVL01....!...'. .<.<........1..}
0060 4300010021241400 0000001763726561 C...!$......crea .............../
0070 7465207461626C65 207428206120696E te table t( a in ..../.%...../..>
0080 742029FF000AD001 00020004200E t )......... . ......}.......
(2014.9.23 5:19:5) Reply flush DRDAConnThread_2 5
SEND BUFFER: RDBUPDRM (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 002AD05200010024 2218000611490000 .*.R...$"....I.. ..}.............
0010 001A21106D656D6F 72793A6462313B63 ..!.memory:db1;c ...._._?.`......
0020 72656174653D7472 75650047D0430001 reate=true.G.C.. ../.........}...
0030 0041240800000000 0020202020204353 .A$...... CS ................
0040 5331303132300000 0000000000000000 S10120.......... ................
0050 0000000000000000 0000000000000020 ............... ................
0060 2020202020202020 2020000000000000 ...... ................
0070 FF0015D052000200 0F220C0006114900 ....R...."....I. ...}............
0080 0400052115010047 D003000200412408 ...!...G.....A$. ........}.......
0090 0000000000202020 2020435353313031 ..... CSS101 ................
00A0 3230000000000000 0000000000000000 20.............. ................
00B0 0000000000000000 0000002020202020 ........... ................
00C0 2020202020200000 00000000FF ....... .............
(2014.9.23 5:19:5) Request fill DRDAConnThread_2 5
RECEIVE BUFFER: EXCSQLIMM (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 005DD05100010057 200A004E21130016 .].Q...W ..N!... .)}........+....
0010 6D656D6F72793A64 62313B6372656174 memory:db1;creat _._?.`......../.
0020 653D747275650012 4E554C4C49442020 e=true..NULLID ........+.<<....
0030 2020202020202020 202000125359534C ..SYSL ...............<
0040 4830303020202020 2020202020205359 H000 SY ................
0050 534C564C30310001 00052105F10036D0 SLVL01....!...6. .<.<........1..}
0060 4300010030241400 00000026696E7365 C...0$.....&inse .............>..
0070 727420696E746F20 7428206120292076 rt into t( a ) v ....>.?..../....
0080 616C756573202820 3120292C20282032 alues ( 1 ), ( 2 /%..............
0090 2029FF000AD00100 020004200E )......... . .....}.......
(2014.9.23 5:19:5) Reply flush DRDAConnThread_2 5
SEND BUFFER: RDBUPDRM (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 002AD05200010024 2218000611490000 .*.R...$"....I.. ..}.............
0010 001A21106D656D6F 72793A6462313B63 ..!.memory:db1;c ...._._?.`......
0020 72656174653D7472 75650047D0430001 reate=true.G.C.. ../.........}...
0030 0041240800000000 0020202020204353 .A$...... CS ................
0040 5331303132300000 0000000000000000 S10120.......... ................
0050 0000020000000000 0000000000000020 ............... ................
0060 2020202020202020 2020000000000000 ...... ................
0070 FF0015D052000200 0F220C0006114900 ....R...."....I. ...}............
0080 0400052115010047 D003000200412408 ...!...G.....A$. ........}.......
0090 0000000000202020 2020435353313031 ..... CSS101 ................
00A0 3230000000000000 0000000000000000 20.............. ................
00B0 0000000000000000 0000002020202020 ........... ................
00C0 2020202020200000 00000000FF ....... .............
(2014.9.23 5:19:5) Request fill DRDAConnThread_2 5
RECEIVE BUFFER: RDBCMM (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 000AD00100010004 200E ........ . ..}.......
(2014.9.23 5:19:5) Reply flush DRDAConnThread_2 5
SEND BUFFER: ENDUOWRM (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 0015D0520001000F 220C000611490004 ...R...."....I.. ..}.............
0010 00052115010047D0 0300010041240800 ..!...G.....A$.. .......}........
0020 0000000020202020 2043535331303132 .... CSS1012 ................
0030 3000000000000000 0000000000000000 0............... ................
0040 0000000000000000 0000202020202020 .......... ................
0050 2020202020000000 000000FF ....... ............
(2014.9.23 5:19:5) Request fill DRDAConnThread_2 5
RECEIVE BUFFER: (ASCII) (EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF
0000 00 . .
