Start a new topic

How to understand slowness of a SQL statement

[This topic is migrated from our old forums. The original author name has been removed]

-- DbVisualizer 9.1.10 Hi all, I'd like to have your feedback on how to improve the SQL statement execution and/or how to pinpoint the 'bottleneck' in the execution time? I'm using this tool to connect to a Sybase ASE server using 'Sybase ASE (jTDS)' driver. The driver I'm using is the one coming with the application. I noticed that most of my queries are slower using DBVis compared to other tool like sqsh/ select colA from tableA where colB= with sqsh the execution timing is Clock Time (sec.): Total = 0.011 Avg = 0.011 (94.66 xacts per sec.) while with DBVis, it took about 5s. Before moving to another tool, I'd like to find out where the differences come from and potentially how to fix it. Thanks all for your help and merry christmas Simon

[This reply is migrated from our old forums.]

Re: How to understand slowness of a SQL statement
Simon, Can you please run the query again with Debug DbVisualizer enabled in Tools->Debug Window? Post the debug output here or email to support@dbvis.com. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: How to understand slowness of a SQL statement
Hi Roger, Thanks for your answer. Below is the output of the debug window. The execution time was about 3 seconds. the select statement executed was select COL_A from TABLE where COL_B=; from the debug I can see the name of other columns of my table that weren't requested. ------------------------- Connected Databases ------------------------ Database Type: Sybase ASE Major Version: 15 Minor Version: 70 Profile: sybase-ase Connection Message: ASE 15.70 jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.7 Database Type: Sybase ASE Major Version: 15 Minor Version: 70 Profile: sybase-ase Connection Message: ASE 15.70 jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.7 Database Type: Sybase ASE Major Version: 15 Minor Version: 70 Profile: sybase-ase Connection Message: ASE 15.70 jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.7 --------------------------- Debug Printouts -------------------------- [cleared] 00 00 0B | | 16: 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 | NO xxx| 32: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 48: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F |B xxx M_| 64: 50 4C 5F 49 4E 53 43 55 52 02 01 00 04 63 68 61 |PL_INSCUR cha| 80: 72 04 03 00 00 00 04 03 00 00 00 00 00 00 00 00 |r | 96: 2F 0C 00 00 02 01 00 00 04 03 00 00 00 0C 00 02 |/ | 112: 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 |NO xxx_1| 128: 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B |5417066 xxxDB | 144: 54 52 4E 5F 48 44 52 5F 44 42 46 09 4D 5F 50 4C |xxx M_PL| 160: 5F 4B 45 59 31 02 01 00 04 63 68 61 72 04 1E 00 |_KEY1 char | 176: 00 00 04 1E 00 00 00 00 00 00 00 00 2F 0D 00 00 | / | 192: 02 01 00 00 04 1E 00 00 00 0D 00 02 4E 4F D1 13 | NO | 208: 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 |xxx_15417| 224: 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F |066 xxxDB TRN_| 240: 48 44 52 5F 44 42 46 0B 4D 5F 4D 4B 54 5F 4C 41 |xxx M_MKT_LA| 256: 42 45 4C 02 01 00 04 63 68 61 72 04 0A 00 00 00 |BEL char | 272: 04 0A 00 00 00 00 00 00 00 00 2F 0E 00 00 02 01 | / | 288: 00 00 04 0A 00 00 00 0E 00 02 4E 4F D1 13 54 50 | NO TP| 304: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| 320: 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 |6 xxxDB TRN_HD| 336: 52 5F 44 42 46 0B 4D 5F 4D 4B 54 5F 49 4E 44 45 |R_DBF M_MKT_INDE| 352: 58 02 01 00 04 63 68 61 72 04 28 00 00 00 04 28 |X char ( (| 368: 00 00 00 00 00 00 00 00 2F 0F 00 00 02 01 00 00 | / | 384: 04 28 00 00 00 0F 00 02 4E 4F D1 13 54 50 4B 30 | ( NO TPK0| 400: 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 |002287_15417066 | 416: 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F |xxxDB TRN_HDR_| 432: 44 42 46 0C 4D 5F 43 4E 53 5F 41 43 54 49 56 45 |DBF M_CNS_ACTIVE| 448: 02 02 00 07 6E 75 6D 65 72 69 63 04 01 00 00 00 | numeric | 464: 04 02 00 00 00 02 00 00 02 0A 00 00 00 00 3F 10 | ? | 480: 00 00 02 02 00 00 04 00 00 00 00 10 00 02 4E 4F | NO| 496: D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 | xxx_154| 512: 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 |17066 xxxDB TR| 528: 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F 43 4F 4D 4D |N_xxx M_COMM| 544: 45 4E 54 5F 42 53 02 01 00 04 63 68 61 72 04 01 |ENT_BS char | 560: 00 00 00 04 01 00 00 00 00 00 00 00 00 2F 11 00 | / | 576: 00 02 01 00 00 04 01 00 00 00 11 00 02 4E 4F D1 | NO | 592: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 608: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 624: 5F 48 44 52 5F 44 42 46 08 4D 5F 43 4C 49 45 4E |_xxx M_CLIEN| 640: 54 02 01 00 04 63 68 61 72 04 0F 00 00 00 04 0F |T char | 656: 00 00 00 00 00 00 00 00 2F 12 00 00 02 01 00 00 | / | 672: 04 0F 00 00 00 12 00 02 4E 4F D1 13 54 50 4B 30 | NO TPK0| 688: 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 |002287_15417066 | 704: 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F |xxxDB xxx_| 720: 44 42 46 0B 4D 5F 42 49 4E 54 45 52 4E 41 4C 02 |DBF M_BINTERNAL | 736: 01 00 04 63 68 61 72 04 01 00 00 00 04 01 00 00 | char | 752: 00 00 00 00 00 00 2F 13 00 00 02 01 00 00 04 01 | / | 768: 00 00 00 13 00 02 4E 4F D1 13 54 50 4B 30 30 30 | NO TPK000| 784: 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 |2287_15417066 MU| 800: 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 |REXDB xxx_DB| 816: 46 09 4D 5F 42 54 52 41 44 45 52 02 01 00 04 63 |F M_BTRADER c| 832: 68 61 72 04 0A 00 00 00 04 0A 00 00 00 00 00 00 |har | 848: 00 00 2F 14 00 00 02 01 00 00 04 0A 00 00 00 14 | / | 864: 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 | NO xxx| 880: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 896: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 09 4D 5F |B xxx M_| 912: 42 50 46 4F 4C 49 4F 02 01 00 04 63 68 61 72 04 |BPFOLIO char | 928: 0F 00 00 00 04 0F 00 00 00 00 00 00 00 00 2F 15 | / | 944: 00 00 02 01 00 00 04 0F 00 00 00 15 00 02 4E 4F | NO| 960: D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 | xxx_154| 976: 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 |17066 xxxDB TR| 992: 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F 42 43 4F 4D |N_xxx M_BCOM| 1008: 4D 45 4E 54 30 02 01 00 04 63 68 61 72 04 1E 00 |MENT0 char | 1024: 00 00 04 1E 00 00 00 00 00 00 00 00 2F 16 00 00 | / | 1040: 02 01 00 00 04 1E 00 00 00 16 00 02 4E 4F D1 13 | NO | 1056: 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 |xxx_15417| 1072: 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F |066 xxxDB TRN_| 1088: 48 44 52 5F 44 42 46 0B 4D 5F 42 43 4F 4D 4D 45 |xxx M_BCOMME| 1104: 4E 54 31 02 01 00 04 63 68 61 72 04 1E 00 00 00 |NT1 char | 1120: 04 1E 00 00 00 00 00 00 00 00 2F 17 00 00 02 01 | / | 1136: 00 00 04 1E 00 00 00 17 00 02 4E 4F D1 13 54 50 | NO TP| 1152: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| 1168: 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 |6 xxxDB TRN_HD| 1184: 52 5F 44 42 46 0B 4D 5F 42 43 4F 4D 4D 45 4E 54 |R_DBF M_BCOMMENT| 1200: 32 02 01 00 04 63 68 61 72 04 1E 00 00 00 04 1E |2 char | 1216: 00 00 00 00 00 00 00 00 2F 18 00 00 02 01 00 00 | / | 1232: 04 1E 00 00 00 18 00 02 4E 4F D1 13 54 50 4B 30 | NO TPK0| 1248: 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 |002287_15417066 | 1264: 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F |xxxDB xxx_| 1280: 44 42 46 0B 4D 5F 42 53 54 52 41 54 45 47 59 02 |DBF M_BSTRATEGY | 1296: 01 00 04 63 68 61 72 04 0F 00 00 00 04 0F 00 00 | char | 1312: 00 00 00 00 00 00 2F 19 00 00 02 01 00 00 04 0F | / | 1328: 00 00 00 19 00 02 4E 4F D1 13 54 50 4B 30 30 30 | NO TPK000| 1344: 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 |2287_15417066 MU| 1360: 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 |REXDB xxx_DB| 1376: 46 0A 4D 5F 42 53 45 43 54 49 4F 4E 02 01 00 04 |F M_BSECTION | 1392: 63 68 61 72 04 0F 00 00 00 04 0F 00 00 00 00 00 |char | 1408: 00 00 00 2F 1A 00 00 02 01 00 00 04 0F 00 00 00 | / | 1424: 1A 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 | NO TPK000228| 1440: 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 |7_15417066 xxx| 1456: 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 09 4D |DB xxx M| 1472: 5F 42 45 4E 54 49 54 59 02 01 00 04 63 68 61 72 |_BENTITY char| 1488: 04 0A 00 00 00 04 0A 00 00 00 00 00 00 00 00 2F | /| 1504: 1B 00 00 02 01 00 00 04 0A 00 00 00 1B 00 02 4E | N| 1520: 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 |O xxx_15| 1536: 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 |417066 xxxDB T| 1552: 52 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F 53 49 4E |RN_xxx M_SIN| 1568: 54 45 52 4E 41 4C 02 01 00 04 63 68 61 72 04 01 |TERNAL char | 1584: 00 00 00 04 01 00 00 00 00 00 00 00 00 2F 1C 00 | / | 1600: 00 02 01 00 00 04 01 00 00 00 1C 00 02 4E 4F D1 | NO | 1616: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 1632: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 1648: 5F 48 44 52 5F 44 42 46 09 4D 5F 53 54 52 41 44 |_xxx M_STRAD| 1664: 45 52 02 01 00 04 63 68 61 72 04 0A 00 00 00 04 |ER char | 1680: 0A 00 00 00 00 00 00 00 00 2F 1D 00 00 02 01 00 | / | 1696: 00 04 0A 00 00 00 1D 00 02 4E 4F D1 13 54 50 4B | NO TPK| 1712: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 1728: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 1744: 5F 44 42 46 09 4D 5F 53 50 46 4F 4C 49 4F 02 01 |_DBF M_SPFOLIO | 1760: 00 04 63 68 61 72 04 0F 00 00 00 04 0F 00 00 00 | char | 1776: 00 00 00 00 00 2F 1E 00 00 02 01 00 00 04 0F 00 | / | 1792: 00 00 1E 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | NO TPK0002| 1808: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 1824: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 1840: 0B 4D 5F 53 43 4F 4D 4D 45 4E 54 30 02 01 00 04 | M_SCOMMENT0 | 1856: 63 68 61 72 04 1E 00 00 00 04 1E 00 00 00 00 00 |char | 1872: 00 00 00 2F 1F 00 00 02 01 00 00 04 1E 00 00 00 | / | 1888: 1F 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 | NO TPK000228| 1904: 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 |7_15417066 xxx| 1920: 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0B 4D |DB xxx M| 1936: 5F 53 43 4F 4D 4D 45 4E 54 31 02 01 00 04 63 68 |_SCOMMENT1 ch| 1952: 61 72 04 1E 00 00 00 04 1E 00 00 00 00 00 00 00 |ar | 1968: 00 2F 20 00 00 02 01 00 00 04 1E 00 00 00 20 00 | / | 1984: 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F | NO xxx_| 2000: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 2016: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F 53 | xxx M_S| 2032: 43 4F 4D 4D 45 4E 54 32 02 01 00 04 63 68 61 72 |COMMENT2 char| ----- Stream #2 read Reply packet 0: 04 00 08 00 00 00 00 00 04 1E 00 00 00 04 1E 00 | | 16: 00 00 00 00 00 00 00 2F 21 00 00 02 01 00 00 04 | /! | 32: 1E 00 00 00 21 00 02 4E 4F D1 13 54 50 4B 30 30 | ! NO TPK00| 48: 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D |02287_15417066 M| 64: 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 |UREXDB xxx_D| 80: 42 46 0B 4D 5F 53 53 54 52 41 54 45 47 59 02 01 |BF M_SSTRATEGY | 96: 00 04 63 68 61 72 04 0F 00 00 00 04 0F 00 00 00 | char | 112: 00 00 00 00 00 2F 22 00 00 02 01 00 00 04 0F 00 | /" | 128: 00 00 22 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | " NO TPK0002| 144: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 160: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 176: 0A 4D 5F 53 53 45 43 54 49 4F 4E 02 01 00 04 63 | M_SSECTION c| 192: 68 61 72 04 0F 00 00 00 04 0F 00 00 00 00 00 00 |har | 208: 00 00 2F 23 00 00 02 01 00 00 04 0F 00 00 00 23 | /# #| 224: 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 | NO xxx| 240: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 256: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 09 4D 5F |B xxx M_| 272: 53 45 4E 54 49 54 59 02 01 00 04 63 68 61 72 04 |SENTITY char | 288: 0A 00 00 00 04 0A 00 00 00 00 00 00 00 00 2F 24 | /$| 304: 00 00 02 01 00 00 04 0A 00 00 00 24 00 02 4E 4F | $ NO| 320: D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 | xxx_154| 336: 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 |17066 xxxDB TR| 352: 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F 54 52 4E 5F |N_xxx M_TRN_| 368: 53 54 41 54 55 53 02 01 00 04 63 68 61 72 04 0A |STATUS char | 384: 00 00 00 04 0A 00 00 00 00 00 00 00 00 2F 25 00 | /% | 400: 00 02 01 00 00 04 0A 00 00 00 25 00 02 4E 4F D1 | % NO | 416: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 432: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 448: 5F 48 44 52 5F 44 42 46 0A 4D 5F 54 52 4E 5F 44 |_xxx M_TRN_D| 464: 41 54 45 02 0B 00 08 64 61 74 65 74 69 6D 65 04 |ATE datetime | 480: 17 00 00 00 04 08 00 00 00 02 03 00 02 0A 00 01 | | 496: 00 00 6F 26 00 00 02 5D 00 00 04 00 00 00 00 26 | o& ] &| 512: 00 03 59 45 53 D1 13 54 50 4B 30 30 30 32 32 38 | YES TPK000228| 528: 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 |7_15417066 xxx| 544: 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0A 4D |DB xxx M| 560: 5F 54 52 4E 5F 54 49 4D 45 02 02 00 07 6E 75 6D |_TRN_TIME num| 576: 65 72 69 63 04 08 00 00 00 04 05 00 00 00 02 00 |eric | 592: 00 02 0A 00 00 00 00 3F 27 00 00 02 02 00 00 04 | ?' | 608: 00 00 00 00 27 00 02 4E 4F D1 13 54 50 4B 30 30 | ' NO TPK00| 624: 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D |02287_15417066 M| 640: 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 |UREXDB xxx_D| 656: 42 46 09 4D 5F 54 52 4E 5F 45 58 50 02 0B 00 08 |BF M_TRN_EXP | 672: 64 61 74 65 74 69 6D 65 04 17 00 00 00 04 08 00 |datetime | 688: 00 00 02 03 00 02 0A 00 01 00 00 6F 28 00 00 02 | o( | 704: 5D 00 00 04 00 00 00 00 28 00 03 59 45 53 D1 13 |] ( YES | 720: 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 |xxx_15417| 736: 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F |066 xxxDB TRN_| 752: 48 44 52 5F 44 42 46 0A 4D 5F 53 59 53 5F 44 41 |xxx M_SYS_DA| 768: 54 45 02 0B 00 08 64 61 74 65 74 69 6D 65 04 17 |TE datetime | 784: 00 00 00 04 08 00 00 00 02 03 00 02 0A 00 01 00 | | 800: 00 6F 29 00 00 02 5D 00 00 04 00 00 00 00 29 00 | o) ] ) | 816: 03 59 45 53 D1 13 54 50 4B 30 30 30 32 32 38 37 | YES xxx| 832: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 848: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 09 4D 5F |B xxx M_| 864: 43 52 45 41 54 4F 52 02 02 00 07 6E 75 6D 65 72 |CREATOR numer| 880: 69 63 04 0A 00 00 00 04 06 00 00 00 02 00 00 02 |ic | 896: 0A 00 00 00 00 3F 2A 00 00 02 02 00 00 04 00 00 | ?* | 912: 00 00 2A 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | * NO TPK0002| 928: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 944: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 960: 0C 4D 5F 43 52 45 5F 43 4D 4D 4F 55 54 02 02 00 | M_CRE_CMMOUT | 976: 07 6E 75 6D 65 72 69 63 04 01 00 00 00 04 02 00 | numeric | 992: 00 00 02 00 00 02 0A 00 00 00 00 3F 2B 00 00 02 | ?+ | 1008: 02 00 00 04 00 00 00 00 2B 00 02 4E 4F D1 13 54 | + NO T| 1024: 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 |PK0002287_154170| 1040: 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 |66 xxxDB TRN_H| 1056: 44 52 5F 44 42 46 08 4D 5F 4E 42 5F 45 58 54 02 |DR_DBF M_NB_EXT | 1072: 02 00 07 6E 75 6D 65 72 69 63 04 0A 00 00 00 04 | numeric | 1088: 06 00 00 00 02 00 00 02 0A 00 00 00 00 3F 2C 00 | ?, | 1104: 00 02 02 00 00 04 00 00 00 00 2C 00 02 4E 4F D1 | , NO | 1120: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 1136: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 1152: 5F 48 44 52 5F 44 42 46 0A 4D 5F 41 43 43 5F 50 |_xxx M_ACC_P| 1168: 52 4F 52 02 02 00 07 6E 75 6D 65 72 69 63 04 0A |ROR numeric | 1184: 00 00 00 04 06 00 00 00 02 06 00 02 0A 00 00 00 | | 1200: 00 3F 2D 00 00 02 02 00 00 04 00 00 00 00 2D 00 | ?- - | 1216: 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F | NO xxx_| 1232: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 1248: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 09 4D 5F 52 | xxx M_R| 1264: 50 4C 5F 41 4D 4F 02 01 00 04 63 68 61 72 04 01 |PL_AMO char | 1280: 00 00 00 04 01 00 00 00 00 00 00 00 00 2F 2E 00 | /. | 1296: 00 02 01 00 00 04 01 00 00 00 2E 00 02 4E 4F D1 | . NO | 1312: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 1328: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 1344: 5F 48 44 52 5F 44 42 46 0C 4D 5F 52 50 4C 5F 41 |_xxx M_RPL_A| 1360: 4D 54 54 59 50 02 01 00 04 63 68 61 72 04 05 00 |MTTYP char | 1376: 00 00 04 05 00 00 00 00 00 00 00 00 2F 2F 00 00 | // | 1392: 02 01 00 00 04 05 00 00 00 2F 00 02 4E 4F D1 13 | / NO | 1408: 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 |xxx_15417| 1424: 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F |066 xxxDB TRN_| 1440: 48 44 52 5F 44 42 46 09 4D 5F 52 50 4C 5F 41 4D |xxx M_RPL_AM| 1456: 54 02 02 00 07 6E 75 6D 65 72 69 63 04 10 00 00 |T numeric | 1472: 00 04 08 00 00 00 02 02 00 02 0A 00 00 00 00 3F | ?| 1488: 30 00 00 02 02 00 00 04 00 00 00 00 30 00 02 4E |0 0 N| 1504: 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 |O xxx_15| 1520: 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 |417066 xxxDB T| 1536: 52 4E 5F 48 44 52 5F 44 42 46 09 4D 5F 52 50 4C |RN_xxx M_RPL| 1552: 5F 43 55 52 02 01 00 04 63 68 61 72 04 03 00 00 |_CUR char | 1568: 00 04 03 00 00 00 00 00 00 00 00 2F 31 00 00 02 | /1 | 1584: 01 00 00 04 03 00 00 00 31 00 02 4E 4F D1 13 54 | 1 NO T| 1600: 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 |PK0002287_154170| 1616: 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 |66 xxxDB TRN_H| 1632: 44 52 5F 44 42 46 0C 4D 5F 52 50 4C 5F 55 53 52 |DR_DBF M_RPL_USR| 1648: 44 41 54 02 01 00 04 63 68 61 72 04 01 00 00 00 |DAT char | 1664: 04 01 00 00 00 00 00 00 00 00 2F 32 00 00 02 01 | /2 | 1680: 00 00 04 01 00 00 00 32 00 02 4E 4F D1 13 54 50 | 2 NO TP| 1696: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| 1712: 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 |6 xxxDB TRN_HD| 1728: 52 5F 44 42 46 0B 4D 5F 52 50 4C 5F 44 41 54 45 |R_DBF M_RPL_DATE| 1744: 31 02 0B 00 08 64 61 74 65 74 69 6D 65 04 17 00 |1 datetime | 1760: 00 00 04 08 00 00 00 02 03 00 02 0A 00 01 00 00 | | 1776: 6F 33 00 00 02 5D 00 00 04 00 00 00 00 33 00 03 |o3 ] 3 | 1792: 59 45 53 D1 13 54 50 4B 30 30 30 32 32 38 37 5F |YES xxx_| 1808: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 1824: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F 52 | xxx M_R| 1840: 50 4C 5F 44 41 54 45 32 02 0B 00 08 64 61 74 65 |PL_DATE2 date| 1856: 74 69 6D 65 04 17 00 00 00 04 08 00 00 00 02 03 |time | 1872: 00 02 0A 00 01 00 00 6F 34 00 00 02 5D 00 00 04 | o4 ] | 1888: 00 00 00 00 34 00 03 59 45 53 D1 13 54 50 4B 30 | 4 YES TPK0| 1904: 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 |002287_15417066 | 1920: 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F |xxxDB xxx_| 1936: 44 42 46 0A 4D 5F 55 50 4C 5F 46 4C 41 47 02 01 |DBF M_UPL_FLAG | 1952: 00 04 63 68 61 72 04 01 00 00 00 04 01 00 00 00 | char | 1968: 00 00 00 00 00 2F 35 00 00 02 01 00 00 04 01 00 | /5 | 1984: 00 00 35 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | 5 NO TPK0002| 2000: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 2016: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 2032: 0A 4D 5F 55 50 4C 5F 4D 4F 44 45 02 01 00 04 63 | M_UPL_MODE c| ----- Stream #2 read Reply packet 0: 04 00 08 00 00 00 00 00 68 61 72 04 03 00 00 00 | har | 16: 04 03 00 00 00 00 00 00 00 00 2F 36 00 00 02 01 | /6 | 32: 00 00 04 03 00 00 00 36 00 02 4E 4F D1 13 54 50 | 6 NO TP| 48: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| 64: 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 |6 xxxDB xxx| 80: 52 5F 44 42 46 0C 4D 5F 55 50 4C 5F 41 4D 54 45 |R_DBF M_UPL_AMTE| 96: 56 43 02 01 00 04 63 68 61 72 04 05 00 00 00 04 |VC char | 112: 05 00 00 00 00 00 00 00 00 2F 37 00 00 02 01 00 | /7 | 128: 00 04 05 00 00 00 37 00 02 4E 4F D1 13 54 50 4B | 7 NO TPK| 144: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 160: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 176: 5F 44 42 46 09 4D 5F 55 50 4C 5F 41 4D 54 02 02 |_DBF M_UPL_AMT | 192: 00 07 6E 75 6D 65 72 69 63 04 10 00 00 00 04 08 | numeric | 208: 00 00 00 02 02 00 02 0A 00 00 00 00 3F 38 00 00 | ?8 | 224: 02 02 00 00 04 00 00 00 00 38 00 02 4E 4F D1 13 | 8 NO | 240: 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 |xxx_15417| 256: 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F |066 xxxDB TRN_| 272: 48 44 52 5F 44 42 46 0C 4D 5F 55 50 4C 5F 41 4D |xxx M_UPL_AM| 288: 54 44 49 53 02 02 00 07 6E 75 6D 65 72 69 63 04 |TDIS numeric | 304: 10 00 00 00 04 08 00 00 00 02 02 00 02 0A 00 00 | | 320: 00 00 3F 39 00 00 02 02 00 00 04 00 00 00 00 39 | ?9 9| 336: 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 | NO xxx| 352: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 368: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0A 4D 5F |B xxx M_| 384: 49 52 56 5F 54 59 50 45 02 01 00 04 63 68 61 72 |IRV_TYPE char| 400: 04 05 00 00 00 04 05 00 00 00 00 00 00 00 00 2F | /| 416: 3A 00 00 02 01 00 00 04 05 00 00 00 3A 00 02 4E |: : N| 432: 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 |O xxx_15| 448: 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 |417066 xxxDB T| 464: 52 4E 5F 48 44 52 5F 44 42 46 09 4D 5F 49 52 56 |RN_xxx M_IRV| 480: 5F 41 4D 54 02 02 00 07 6E 75 6D 65 72 69 63 04 |_AMT numeric | 496: 12 00 00 00 04 09 00 00 00 02 02 00 02 0A 00 00 | | 512: 00 00 3F 3B 00 00 02 02 00 00 04 00 00 00 00 3B | ?; ;| 528: 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 | NO xxx| 544: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 560: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F |B xxx M_| 576: 46 43 50 5F 52 45 56 41 4C 02 0B 00 08 64 61 74 |FCP_REVAL dat| 592: 65 74 69 6D 65 04 17 00 00 00 04 08 00 00 00 02 |etime | 608: 03 00 02 0A 00 01 00 00 6F 3C 00 00 02 5D 00 00 | o | 816: 00 00 00 3E 00 02 4E 4F D1 13 54 50 4B 30 30 30 | > NO TPK000| 832: 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 |2287_15417066 MU| 848: 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 |REXDB xxx_DB| 864: 46 0C 4D 5F 48 45 44 47 45 44 5F 4D 41 54 02 0B |F M_HEDGED_MAT | 880: 00 08 64 61 74 65 74 69 6D 65 04 17 00 00 00 04 | datetime | 896: 08 00 00 00 02 03 00 02 0A 00 01 00 00 6F 3F 00 | o? | 912: 00 02 5D 00 00 04 00 00 00 00 3F 00 03 59 45 53 | ] ? YES| 928: D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 | xxx_154| 944: 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 |17066 xxxDB TR| 960: 4E 5F 48 44 52 5F 44 42 46 09 4D 5F 50 41 59 5F |N_xxx M_PAY_| 976: 4E 45 54 02 02 00 07 6E 75 6D 65 72 69 63 04 01 |NET numeric | 992: 00 00 00 04 02 00 00 00 02 00 00 02 0A 00 00 00 | | 1008: 00 3F 40 00 00 02 02 00 00 04 00 00 00 00 40 00 | ?@ @ | 1024: 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F | NO xxx_| 1040: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 1056: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F 56 | xxx M_V| 1072: 41 4C 5F 53 54 41 54 55 53 02 01 00 04 63 68 61 |AL_STATUS cha| 1088: 72 04 04 00 00 00 04 04 00 00 00 00 00 00 00 00 |r | 1104: 2F 41 00 00 02 01 00 00 04 04 00 00 00 41 00 02 |/A A | 1120: 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 |NO xxx_1| 1136: 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B |5417066 xxxDB | 1152: 54 52 4E 5F 48 44 52 5F 44 42 46 06 4D 5F 4D 41 |xxx M_MA| 1168: 49 4E 02 02 00 07 6E 75 6D 65 72 69 63 04 01 00 |IN numeric | 1184: 00 00 04 02 00 00 00 02 00 00 02 0A 00 00 00 00 | | 1200: 3F 42 00 00 02 02 00 00 04 00 00 00 00 42 00 02 |?B B | 1216: 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 |NO xxx_1| 1232: 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B |5417066 xxxDB | 1248: 54 52 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F 46 4C |xxx M_FL| 1264: 4F 57 5F 46 4C 41 47 02 02 00 07 6E 75 6D 65 72 |OW_FLAG numer| 1280: 69 63 04 02 00 00 00 04 02 00 00 00 02 00 00 02 |ic | 1296: 0A 00 00 00 00 3F 43 00 00 02 02 00 00 04 00 00 | ?C | 1312: 00 00 43 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | C NO TPK0002| 1328: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 1344: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 1360: 0B 4D 5F 41 52 45 41 5F 43 4F 44 45 02 02 00 07 | M_AREA_CODE | 1376: 6E 75 6D 65 72 69 63 04 02 00 00 00 04 02 00 00 |numeric | 1392: 00 02 00 00 02 0A 00 00 00 00 3F 44 00 00 02 02 | ?D | 1408: 00 00 04 00 00 00 00 44 00 02 4E 4F D1 13 54 50 | D NO TP| 1424: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| 1440: 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 |6 xxxDB xxx| 1456: 52 5F 44 42 46 0B 4D 5F 4D 52 50 4C 5F 44 41 54 |R_DBF M_MRPL_DAT| 1472: 45 02 0B 00 08 64 61 74 65 74 69 6D 65 04 17 00 |E datetime | 1488: 00 00 04 08 00 00 00 02 03 00 02 0A 00 01 00 00 | | 1504: 6F 45 00 00 02 5D 00 00 04 00 00 00 00 45 00 03 |oE ] E | 1520: 59 45 53 D1 13 54 50 4B 30 30 30 32 32 38 37 5F |YES xxx_| 1536: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 1552: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0A 4D 5F 4D | xxx M_M| 1568: 52 50 4C 5F 4F 4E 42 02 02 00 07 6E 75 6D 65 72 |RPL_ONB numer| 1584: 69 63 04 0A 00 00 00 04 06 00 00 00 02 00 00 02 |ic | 1600: 0A 00 00 00 00 3F 46 00 00 02 02 00 00 04 00 00 | ?F | 1616: 00 00 46 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | F NO TPK0002| 1632: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 1648: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 1664: 0A 4D 5F 43 41 4E 5F 47 58 49 54 02 02 00 07 6E | M_CAN_GXIT n| 1680: 75 6D 65 72 69 63 04 02 00 00 00 04 02 00 00 00 |umeric | 1696: 02 00 00 02 0A 00 00 00 00 3F 47 00 00 02 02 00 | ?G | 1712: 00 04 00 00 00 00 47 00 02 4E 4F D1 13 54 50 4B | G NO TPK| 1728: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 1744: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 1760: 5F 44 42 46 0B 4D 5F 47 58 49 54 5F 44 41 54 45 |_DBF M_GXIT_DATE| 1776: 02 0B 00 08 64 61 74 65 74 69 6D 65 04 17 00 00 | datetime | 1792: 00 04 08 00 00 00 02 03 00 02 0A 00 01 00 00 6F | o| 1808: 48 00 00 02 5D 00 00 04 00 00 00 00 48 00 03 59 |H ] H Y| 1824: 45 53 D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 |ES xxx_1| 1840: 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B |5417066 xxxDB | 1856: 54 52 4E 5F 48 44 52 5F 44 42 46 0A 4D 5F 4D 4F |xxx M_MO| 1872: 50 5F 4C 41 53 54 02 02 00 07 6E 75 6D 65 72 69 |P_LAST numeri| 1888: 63 04 03 00 00 00 04 03 00 00 00 02 00 00 02 0A |c | 1904: 00 00 00 00 3F 49 00 00 02 02 00 00 04 00 00 00 | ?I | 1920: 00 49 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 | I NO TPK00022| 1936: 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 |87_15417066 MURE| 1952: 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C |XDB xxx | 1968: 4D 5F 42 52 4B 5F 54 48 49 52 44 50 02 02 00 07 |M_BRK_THIRDP | 1984: 6E 75 6D 65 72 69 63 04 01 00 00 00 04 02 00 00 |numeric | 2000: 00 02 00 00 02 0A 00 00 00 00 3F 4A 00 00 02 02 | ?J | 2016: 00 00 04 00 00 00 00 4A 00 02 4E 4F D1 13 54 50 | J NO TP| 2032: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| ----- Stream #2 read Reply packet 0: 04 00 08 00 00 00 00 00 36 07 4D 55 52 45 58 44 | 6 xxxD| 16: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F |B xxx M_| 32: 4F 50 54 5F 46 4C 57 46 53 54 02 0B 00 08 64 61 |OPT_FLWFST da| 48: 74 65 74 69 6D 65 04 17 00 00 00 04 08 00 00 00 |tetime | 64: 02 03 00 02 0A 00 01 00 00 6F 4B 00 00 02 5D 00 | oK ] | 80: 00 04 00 00 00 00 4B 00 03 59 45 53 D1 13 54 50 | K YES TP| 96: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| 112: 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 |6 xxxDB xxx| 128: 52 5F 44 42 46 0C 4D 5F 4F 50 54 5F 46 4C 57 4C |R_DBF M_OPT_FLWL| 144: 53 54 02 0B 00 08 64 61 74 65 74 69 6D 65 04 17 |ST datetime | 160: 00 00 00 04 08 00 00 00 02 03 00 02 0A 00 01 00 | | 176: 00 6F 4C 00 00 02 5D 00 00 04 00 00 00 00 4C 00 | oL ] L | 192: 03 59 45 53 D1 13 54 50 4B 30 30 30 32 32 38 37 | YES xxx| 208: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 224: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F |B xxx M_| 240: 4F 50 54 5F 41 43 43 4C 53 54 02 0B 00 08 64 61 |OPT_ACCLST da| 256: 74 65 74 69 6D 65 04 17 00 00 00 04 08 00 00 00 |tetime | 272: 02 03 00 02 0A 00 01 00 00 6F 4D 00 00 02 5D 00 | oM ] | 288: 00 04 00 00 00 00 4D 00 03 59 45 53 D1 13 54 50 | M YES TP| 304: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| 320: 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 |6 xxxDB xxx| 336: 52 5F 44 42 46 0C 4D 5F 4F 50 54 5F 4D 4F 50 46 |R_DBF M_OPT_MOPF| 352: 53 54 02 0B 00 08 64 61 74 65 74 69 6D 65 04 17 |ST datetime | 368: 00 00 00 04 08 00 00 00 02 03 00 02 0A 00 01 00 | | 384: 00 6F 4E 00 00 02 5D 00 00 04 00 00 00 00 4E 00 | oN ] N | 400: 03 59 45 53 D1 13 54 50 4B 30 30 30 32 32 38 37 | YES xxx| 416: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 432: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F |B xxx M_| 448: 4F 50 54 5F 4D 4F 50 4C 53 54 02 0B 00 08 64 61 |OPT_MOPLST da| 464: 74 65 74 69 6D 65 04 17 00 00 00 04 08 00 00 00 |tetime | 480: 02 03 00 02 0A 00 01 00 00 6F 4F 00 00 02 5D 00 | oO ] | 496: 00 04 00 00 00 00 4F 00 03 59 45 53 D1 13 54 50 | O YES TP| 512: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| 528: 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 |6 xxxDB xxx| 544: 52 5F 44 42 46 0C 4D 5F 4F 50 54 5F 4D 4F 50 43 |R_DBF M_OPT_MOPC| 560: 4E 54 02 02 00 07 6E 75 6D 65 72 69 63 04 06 00 |NT numeric | 576: 00 00 04 04 00 00 00 02 00 00 02 0A 00 00 00 00 | | 592: 3F 50 00 00 02 02 00 00 04 00 00 00 00 50 00 02 |?P P | 608: 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 |NO xxx_1| 624: 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B |5417066 xxxDB | 640: 54 52 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F 4F 50 |xxx M_OP| 656: 54 5F 4D 4F 50 4E 42 02 02 00 07 6E 75 6D 65 72 |T_MOPNB numer| 672: 69 63 04 0A 00 00 00 04 06 00 00 00 02 00 00 02 |ic | 688: 0A 00 00 00 00 3F 51 00 00 02 02 00 00 04 00 00 | ?Q | 704: 00 00 51 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | Q NO TPK0002| 720: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 736: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 752: 0A 4D 5F 42 52 57 5F 4E 4F 4D 31 02 02 00 07 6E | M_BRW_NOM1 n| 768: 75 6D 65 72 69 63 04 18 00 00 00 04 0B 00 00 00 |umeric | 784: 02 08 00 02 0A 00 00 00 00 3F 52 00 00 02 02 00 | ?R | 800: 00 04 00 00 00 00 52 00 02 4E 4F D1 13 54 50 4B | R NO TPK| 816: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 832: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 848: 5F 44 42 46 0B 4D 5F 42 52 57 5F 4E 4F 4D 55 31 |_DBF M_BRW_NOMU1| 864: 02 01 00 04 63 68 61 72 04 03 00 00 00 04 03 00 | char | 880: 00 00 00 00 00 00 00 2F 53 00 00 02 01 00 00 04 | /S | 896: 03 00 00 00 53 00 02 4E 4F D1 13 54 50 4B 30 30 | S NO TPK00| 912: 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D |02287_15417066 M| 928: 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 |UREXDB xxx_D| 944: 42 46 0A 4D 5F 42 52 57 5F 4E 4F 4D 32 02 02 00 |BF M_BRW_NOM2 | 960: 07 6E 75 6D 65 72 69 63 04 18 00 00 00 04 0B 00 | numeric | 976: 00 00 02 08 00 02 0A 00 00 00 00 3F 54 00 00 02 | ?T | 992: 02 00 00 04 00 00 00 00 54 00 02 4E 4F D1 13 54 | T NO T| 1008: 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 |PK0002287_154170| 1024: 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 |66 xxxDB TRN_H| 1040: 44 52 5F 44 42 46 0B 4D 5F 42 52 57 5F 4E 4F 4D |DR_DBF M_BRW_NOM| 1056: 55 32 02 01 00 04 63 68 61 72 04 03 00 00 00 04 |U2 char | 1072: 03 00 00 00 00 00 00 00 00 2F 55 00 00 02 01 00 | /U | 1088: 00 04 03 00 00 00 55 00 02 4E 4F D1 13 54 50 4B | U NO TPK| 1104: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 1120: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 1136: 5F 44 42 46 0A 4D 5F 42 52 57 5F 52 54 45 31 02 |_DBF M_BRW_RTE1 | 1152: 02 00 07 6E 75 6D 65 72 69 63 04 15 00 00 00 04 | numeric | 1168: 0A 00 00 00 02 08 00 02 0A 00 00 00 00 3F 56 00 | ?V | 1184: 00 02 02 00 00 04 00 00 00 00 56 00 02 4E 4F D1 | V NO | 1200: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 1216: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 1232: 5F 48 44 52 5F 44 42 46 0A 4D 5F 42 52 57 5F 52 |_xxx M_BRW_R| 1248: 54 45 32 02 02 00 07 6E 75 6D 65 72 69 63 04 15 |TE2 numeric | 1264: 00 00 00 04 0A 00 00 00 02 08 00 02 0A 00 00 00 | | 1280: 00 3F 57 00 00 02 02 00 00 04 00 00 00 00 57 00 | ?W W | 1296: 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F | NO xxx_| 1312: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 1328: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0A 4D 5F 42 | xxx M_B| 1344: 52 57 5F 4D 52 47 31 02 02 00 07 6E 75 6D 65 72 |RW_MRG1 numer| 1360: 69 63 04 15 00 00 00 04 0A 00 00 00 02 08 00 02 |ic | 1376: 0A 00 00 00 00 3F 58 00 00 02 02 00 00 04 00 00 | ?X | 1392: 00 00 58 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | X NO TPK0002| 1408: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 1424: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 1440: 0A 4D 5F 42 52 57 5F 4D 52 47 32 02 02 00 07 6E | M_BRW_MRG2 n| 1456: 75 6D 65 72 69 63 04 15 00 00 00 04 0A 00 00 00 |umeric | 1472: 02 08 00 02 0A 00 00 00 00 3F 59 00 00 02 02 00 | ?Y | 1488: 00 04 00 00 00 00 59 00 02 4E 4F D1 13 54 50 4B | Y NO TPK| 1504: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 1520: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 1536: 5F 44 42 46 0A 4D 5F 42 52 57 5F 53 54 52 4B 02 |_DBF M_BRW_STRK | 1552: 02 00 07 6E 75 6D 65 72 69 63 04 15 00 00 00 04 | numeric | 1568: 0A 00 00 00 02 08 00 02 0A 00 00 00 00 3F 5A 00 | ?Z | 1584: 00 02 02 00 00 04 00 00 00 00 5A 00 02 4E 4F D1 | Z NO | 1600: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 1616: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 1632: 5F 48 44 52 5F 44 42 46 08 4D 5F 42 52 57 5F 43 |_xxx M_BRW_C| 1648: 50 02 01 00 04 63 68 61 72 04 01 00 00 00 04 01 |P char | 1664: 00 00 00 00 00 00 00 00 2F 5B 00 00 02 01 00 00 | /[ | 1680: 04 01 00 00 00 5B 00 02 4E 4F D1 13 54 50 4B 30 | [ NO TPK0| 1696: 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 |002287_15417066 | 1712: 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F |xxxDB xxx_| 1728: 44 42 46 08 4D 5F 42 52 57 5F 41 45 02 01 00 04 |DBF M_BRW_AE | 1744: 63 68 61 72 04 01 00 00 00 04 01 00 00 00 00 00 |char | 1760: 00 00 00 2F 5C 00 00 02 01 00 00 04 01 00 00 00 | /\ | 1776: 5C 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 |\ NO TPK000228| 1792: 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 |7_15417066 xxx| 1808: 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 09 4D |DB xxx M| 1824: 5F 42 52 57 5F 50 52 31 02 01 00 04 63 68 61 72 |_BRW_PR1 char| 1840: 04 01 00 00 00 04 01 00 00 00 00 00 00 00 00 2F | /| 1856: 5D 00 00 02 01 00 00 04 01 00 00 00 5D 00 02 4E |] ] N| 1872: 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 |O xxx_15| 1888: 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 |417066 xxxDB T| 1904: 52 4E 5F 48 44 52 5F 44 42 46 09 4D 5F 42 52 57 |RN_xxx M_BRW| 1920: 5F 50 52 32 02 01 00 04 63 68 61 72 04 01 00 00 |_PR2 char | 1936: 00 04 01 00 00 00 00 00 00 00 00 2F 5E 00 00 02 | /^ | 1952: 01 00 00 04 01 00 00 00 5E 00 02 4E 4F D1 13 54 | ^ NO T| 1968: 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 |PK0002287_154170| 1984: 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 |66 xxxDB TRN_H| 2000: 44 52 5F 44 42 46 09 4D 5F 42 52 57 5F 46 56 31 |DR_DBF M_BRW_FV1| 2016: 02 01 00 04 63 68 61 72 04 01 00 00 00 04 01 00 | char | 2032: 00 00 00 00 00 00 00 2F 5F 00 00 02 01 00 00 04 | /_ | ----- Stream #2 read Reply packet 0: 04 00 08 00 00 00 00 00 01 00 00 00 5F 00 02 4E | _ N| 16: 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 |O xxx_15| 32: 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 |417066 xxxDB T| 48: 52 4E 5F 48 44 52 5F 44 42 46 09 4D 5F 42 52 57 |RN_xxx M_BRW| 64: 5F 46 56 32 02 01 00 04 63 68 61 72 04 01 00 00 |_FV2 char | 80: 00 04 01 00 00 00 00 00 00 00 00 2F 60 00 00 02 | /` | 96: 01 00 00 04 01 00 00 00 60 00 02 4E 4F D1 13 54 | ` NO T| 112: 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 |PK0002287_154170| 128: 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 |66 xxxDB TRN_H| 144: 44 52 5F 44 42 46 0A 4D 5F 42 52 57 5F 53 44 54 |DR_DBF M_BRW_SDT| 160: 45 02 0B 00 08 64 61 74 65 74 69 6D 65 04 17 00 |E datetime | 176: 00 00 04 08 00 00 00 02 03 00 02 0A 00 01 00 00 | | 192: 6F 61 00 00 02 5D 00 00 04 00 00 00 00 61 00 03 |oa ] a | 208: 59 45 53 D1 13 54 50 4B 30 30 30 32 32 38 37 5F |YES xxx_| 224: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 240: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0A 4D 5F 42 | xxx M_B| 256: 52 57 5F 4F 44 50 4C 02 01 00 04 63 68 61 72 04 |RW_ODPL char | 272: 14 00 00 00 04 14 00 00 00 00 00 00 00 00 2F 62 | /b| 288: 00 00 02 01 00 00 04 14 00 00 00 62 00 02 4E 4F | b NO| 304: D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 | xxx_154| 320: 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 |17066 xxxDB TR| 336: 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F 42 52 57 5F |N_xxx M_BRW_| 352: 4F 44 4E 43 30 02 01 00 04 63 68 61 72 04 03 00 |ODNC0 char | 368: 00 00 04 03 00 00 00 00 00 00 00 00 2F 63 00 00 | /c | 384: 02 01 00 00 04 03 00 00 00 63 00 02 4E 4F D1 13 | c NO | 400: 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 |xxx_15417| 416: 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F |066 xxxDB TRN_| 432: 48 44 52 5F 44 42 46 0B 4D 5F 42 52 57 5F 4F 44 |xxx M_BRW_OD| 448: 4E 43 31 02 01 00 04 63 68 61 72 04 03 00 00 00 |NC1 char | 464: 04 03 00 00 00 00 00 00 00 00 2F 64 00 00 02 01 | /d | 480: 00 00 04 03 00 00 00 64 00 02 4E 4F D1 13 54 50 | d NO TP| 496: 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 |K0002287_1541706| 512: 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 |6 xxxDB xxx| 528: 52 5F 44 42 46 0B 4D 5F 42 52 57 5F 4F 44 46 43 |R_DBF M_BRW_ODFC| 544: 30 02 01 00 04 63 68 61 72 04 03 00 00 00 04 03 |0 char | 560: 00 00 00 00 00 00 00 00 2F 65 00 00 02 01 00 00 | /e | 576: 04 03 00 00 00 65 00 02 4E 4F D1 13 54 50 4B 30 | e NO TPK0| 592: 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 |002287_15417066 | 608: 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F |xxxDB xxx_| 624: 44 42 46 0B 4D 5F 42 52 57 5F 4F 44 46 43 31 02 |DBF M_BRW_ODFC1 | 640: 01 00 04 63 68 61 72 04 03 00 00 00 04 03 00 00 | char | 656: 00 00 00 00 00 00 2F 66 00 00 02 01 00 00 04 03 | /f | 672: 00 00 00 66 00 02 4E 4F D1 13 54 50 4B 30 30 30 | f NO TPK000| 688: 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 |2287_15417066 MU| 704: 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 |REXDB xxx_DB| 720: 46 0C 4D 5F 4F 50 54 5F 43 4D 4D 4E 41 54 02 02 |F M_OPT_CMMNAT | 736: 00 07 6E 75 6D 65 72 69 63 04 01 00 00 00 04 02 | numeric | 752: 00 00 00 02 00 00 02 0A 00 00 00 00 3F 67 00 00 | ?g | 768: 02 02 00 00 04 00 00 00 00 67 00 02 4E 4F D1 13 | g NO | 784: 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 |xxx_15417| 800: 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F |066 xxxDB TRN_| 816: 48 44 52 5F 44 42 46 0C 4D 5F 4F 50 54 5F 43 4D |xxx M_OPT_CM| 832: 4D 44 54 45 02 0B 00 08 64 61 74 65 74 69 6D 65 |MDTE datetime| 848: 04 17 00 00 00 04 08 00 00 00 02 03 00 02 0A 00 | | 864: 01 00 00 6F 68 00 00 02 5D 00 00 04 00 00 00 00 | oh ] | 880: 68 00 03 59 45 53 D1 13 54 50 4B 30 30 30 32 32 |h YES TPK00022| 896: 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 |87_15417066 MURE| 912: 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C |XDB xxx | 928: 4D 5F 4F 50 54 5F 43 4D 4D 43 55 52 02 01 00 04 |M_OPT_CMMCUR | 944: 63 68 61 72 04 03 00 00 00 04 03 00 00 00 00 00 |char | 960: 00 00 00 2F 69 00 00 02 01 00 00 04 03 00 00 00 | /i | 976: 69 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 |i NO TPK000228| 992: 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 |7_15417066 xxx| 1008: 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D |DB xxx M| 1024: 5F 4F 50 54 5F 43 4D 4D 53 54 4C 02 02 00 07 6E |_OPT_CMMSTL n| 1040: 75 6D 65 72 69 63 04 01 00 00 00 04 02 00 00 00 |umeric | 1056: 02 00 00 02 0A 00 00 00 00 3F 6A 00 00 02 02 00 | ?j | 1072: 00 04 00 00 00 00 6A 00 02 4E 4F D1 13 54 50 4B | j NO TPK| 1088: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 1104: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 1120: 5F 44 42 46 0C 4D 5F 4F 50 54 5F 43 4D 4D 53 50 |_DBF M_OPT_CMMSP| 1136: 44 02 0B 00 08 64 61 74 65 74 69 6D 65 04 17 00 |D datetime | 1152: 00 00 04 08 00 00 00 02 03 00 02 0A 00 01 00 00 | | 1168: 6F 6B 00 00 02 5D 00 00 04 00 00 00 00 6B 00 03 |ok ] k | 1184: 59 45 53 D1 13 54 50 4B 30 30 30 32 32 38 37 5F |YES xxx_| 1200: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 1216: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F 4F | xxx M_O| 1232: 50 54 5F 43 4D 4D 53 50 53 02 02 00 07 6E 75 6D |PT_CMMSPS num| 1248: 65 72 69 63 04 01 00 00 00 04 02 00 00 00 02 00 |eric | 1264: 00 02 0A 00 00 00 00 3F 6C 00 00 02 02 00 00 04 | ?l | 1280: 00 00 00 00 6C 00 02 4E 4F D1 13 54 50 4B 30 30 | l NO TPK00| 1296: 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D |02287_15417066 M| 1312: 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 |UREXDB xxx_D| 1328: 42 46 0C 4D 5F 50 55 52 47 45 5F 44 41 54 45 02 |BF M_PURGE_DATE | 1344: 0B 00 08 64 61 74 65 74 69 6D 65 04 17 00 00 00 | datetime | 1360: 04 08 00 00 00 02 03 00 02 0A 00 01 00 00 6F 6D | om| 1376: 00 00 02 5D 00 00 04 00 00 00 00 6D 00 03 59 45 | ] m YE| 1392: 53 D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 |S xxx_15| 1408: 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 |417066 xxxDB T| 1424: 52 4E 5F 48 44 52 5F 44 42 46 07 4D 5F 53 41 4C |RN_xxx M_SAL| 1440: 45 53 02 01 00 04 63 68 61 72 04 0A 00 00 00 04 |ES char | 1456: 0A 00 00 00 00 00 00 00 00 2F 6E 00 00 02 01 00 | /n | 1472: 00 04 0A 00 00 00 6E 00 02 4E 4F D1 13 54 50 4B | n NO TPK| 1488: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 1504: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 1520: 5F 44 42 46 05 4D 5F 4C 41 54 02 01 00 04 63 68 |_DBF M_LAT ch| 1536: 61 72 04 01 00 00 00 04 01 00 00 00 00 00 00 00 |ar | 1552: 00 2F 6F 00 00 02 01 00 00 04 01 00 00 00 6F 00 | /o o | 1568: 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F | NO xxx_| 1584: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 1600: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0A 4D 5F 48 | xxx M_H| 1616: 4F 53 54 5F 53 59 53 02 02 00 07 6E 75 6D 65 72 |OST_SYS numer| 1632: 69 63 04 0A 00 00 00 04 06 00 00 00 02 00 00 02 |ic | 1648: 0A 00 00 00 00 3F 70 00 00 02 02 00 00 04 00 00 | ?p | 1664: 00 00 70 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | p NO TPK0002| 1680: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 1696: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 1712: 0B 4D 5F 43 4E 54 5F 49 4E 54 49 44 02 01 00 04 | M_CNT_INTID | 1728: 63 68 61 72 04 0A 00 00 00 04 0A 00 00 00 00 00 |char | 1744: 00 00 00 2F 71 00 00 02 01 00 00 04 0A 00 00 00 | /q | 1760: 71 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 |q NO TPK000228| 1776: 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 |7_15417066 xxx| 1792: 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0A 4D |DB xxx M| 1808: 5F 43 4F 4E 54 52 41 43 54 02 02 00 07 6E 75 6D |_CONTRACT num| 1824: 65 72 69 63 04 0A 00 00 00 04 06 00 00 00 02 00 |eric | 1840: 00 02 0A 00 00 00 00 3F 72 00 00 02 02 00 00 04 | ?r | 1856: 00 00 00 00 72 00 02 4E 4F D1 13 54 50 4B 30 30 | r NO TPK00| 1872: 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D |02287_15417066 M| 1888: 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 |UREXDB xxx_D| 1904: 42 46 0C 4D 5F 4F 50 54 5F 4E 41 54 55 52 45 02 |BF M_OPT_NATURE | 1920: 02 00 07 6E 75 6D 65 72 69 63 04 03 00 00 00 04 | numeric | 1936: 03 00 00 00 02 00 00 02 0A 00 00 00 00 3F 73 00 | ?s | 1952: 00 02 02 00 00 04 00 00 00 00 73 00 02 4E 4F D1 | s NO | 1968: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 1984: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 2000: 5F 48 44 52 5F 44 42 46 0C 4D 5F 4F 52 49 47 5F |_xxx M_ORIG_| 2016: 50 53 5F 49 44 02 01 00 04 63 68 61 72 04 14 00 |PS_ID char | 2032: 00 00 04 14 00 00 00 00 00 00 00 00 2F 74 00 00 | /t | ----- Stream #2 read Reply packet 0: 04 00 08 00 00 00 00 00 02 01 00 00 04 14 00 00 | | 16: 00 74 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 | t NO TPK00022| 32: 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 |87_15417066 MURE| 48: 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 07 |XDB xxx | 64: 4D 5F 50 53 5F 49 44 02 01 00 04 63 68 61 72 04 |M_PS_ID char | 80: 14 00 00 00 04 14 00 00 00 00 00 00 00 00 2F 75 | /u| 96: 00 00 02 01 00 00 04 14 00 00 00 75 00 02 4E 4F | u NO| 112: D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 | xxx_154| 128: 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 |17066 xxxDB TR| 144: 4E 5F 48 44 52 5F 44 42 46 0A 4D 5F 53 54 41 54 |N_xxx M_STAT| 160: 5F 43 41 54 02 02 00 07 6E 75 6D 65 72 69 63 04 |_CAT numeric | 176: 0A 00 00 00 04 06 00 00 00 02 00 00 02 0A 00 00 | | 192: 00 00 3F 76 00 00 02 02 00 00 04 00 00 00 00 76 | ?v v| 208: 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 | NO xxx| 224: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 240: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 08 4D 5F |B xxx M_| 256: 43 55 53 54 4F 4D 02 02 00 07 6E 75 6D 65 72 69 |CUSTOM numeri| 272: 63 04 0A 00 00 00 04 06 00 00 00 02 00 00 02 0A |c | 288: 00 00 00 00 3F 77 00 00 02 02 00 00 04 00 00 00 | ?w | 304: 00 77 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 | w NO TPK00022| 320: 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 |87_15417066 MURE| 336: 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0B |XDB xxx | 352: 4D 5F 43 4F 4D 50 5F 54 59 50 4F 02 02 00 07 6E |M_COMP_TYPO n| 368: 75 6D 65 72 69 63 04 04 00 00 00 04 03 00 00 00 |umeric | 384: 02 00 00 02 0A 00 00 00 00 3F 78 00 00 02 02 00 | ?x | 400: 00 04 00 00 00 00 78 00 02 4E 4F D1 13 54 50 4B | x NO TPK| 416: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 432: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 448: 5F 44 42 46 0A 4D 5F 54 59 50 4F 4C 4F 47 59 02 |_DBF M_TYPOLOGY | 464: 02 00 07 6E 75 6D 65 72 69 63 04 0A 00 00 00 04 | numeric | 480: 06 00 00 00 02 00 00 02 0A 00 00 00 00 3F 79 00 | ?y | 496: 00 02 02 00 00 04 00 00 00 00 79 00 02 4E 4F D1 | y NO | 512: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 528: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 544: 5F 48 44 52 5F 44 42 46 07 4D 5F 55 53 41 47 45 |_xxx M_USAGE| 560: 02 02 00 07 6E 75 6D 65 72 69 63 04 0A 00 00 00 | numeric | 576: 04 06 00 00 00 02 00 00 02 0A 00 00 00 00 3F 7A | ?z| 592: 00 00 02 02 00 00 04 00 00 00 00 7A 00 02 4E 4F | z NO| 608: D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 | xxx_154| 624: 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 |17066 xxxDB TR| 640: 4E 5F 48 44 52 5F 44 42 46 0A 4D 5F 4F 4E 53 5F |N_xxx M_ONS_| 656: 4F 46 46 53 02 02 00 07 6E 75 6D 65 72 69 63 04 |OFFS numeric | 672: 04 00 00 00 04 03 00 00 00 02 00 00 02 0A 00 00 | | 688: 00 00 3F 7B 00 00 02 02 00 00 04 00 00 00 00 7B | ?{ {| 704: 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 | NO xxx| 720: 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 |_15417066 xxxD| 736: 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F |B xxx M_| 752: 53 45 54 54 4C 5F 4D 45 54 48 02 02 00 07 6E 75 |SETTL_METH nu| 768: 6D 65 72 69 63 04 0A 00 00 00 04 06 00 00 00 02 |meric | 784: 00 00 02 0A 00 00 00 00 3F 7C 00 00 02 02 00 00 | ?| | 800: 04 00 00 00 00 7C 00 02 4E 4F D1 13 54 50 4B 30 | | NO TPK0| 816: 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 |002287_15417066 | 832: 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F |xxxDB xxx_| 848: 44 42 46 0A 4D 5F 50 5F 45 4E 54 49 54 59 02 02 |DBF M_P_ENTITY | 864: 00 07 6E 75 6D 65 72 69 63 04 0A 00 00 00 04 06 | numeric | 880: 00 00 00 02 00 00 02 0A 00 00 00 00 3F 7D 00 00 | ?} | 896: 02 02 00 00 04 00 00 00 00 7D 00 02 4E 4F D1 13 | } NO | 912: 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 |xxx_15417| 928: 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F |066 xxxDB TRN_| 944: 48 44 52 5F 44 42 46 08 4D 5F 5F 44 54 5F 54 53 |xxx M__DT_TS| 960: 02 0B 00 08 64 61 74 65 74 69 6D 65 04 17 00 00 | datetime | 976: 00 04 08 00 00 00 02 03 00 02 0A 00 01 00 00 6F | o| 992: 7E 00 00 02 5D 00 00 04 00 00 00 00 7E 00 03 59 |~ ] ~ Y| 1008: 45 53 D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 |ES xxx_1| 1024: 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B |5417066 xxxDB | 1040: 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F 4F 50 |xxx M_OP| 1056: 54 5F 53 54 53 56 45 52 02 02 00 07 6E 75 6D 65 |T_STSVER nume| 1072: 72 69 63 04 06 00 00 00 04 04 00 00 00 02 00 00 |ric | 1088: 02 0A 00 00 00 00 3F 7F 00 00 02 02 00 00 04 00 | ? | 1104: 00 00 00 7F 00 02 4E 4F D1 13 54 50 4B 30 30 30 | NO TPK000| 1120: 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 |2287_15417066 MU| 1136: 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 |REXDB xxx_DB| 1152: 46 0B 4D 5F 50 55 52 47 45 5F 52 45 46 02 02 00 |F M_PURGE_REF | 1168: 07 6E 75 6D 65 72 69 63 04 0A 00 00 00 04 06 00 | numeric | 1184: 00 00 02 00 00 02 0A 00 00 00 00 3F 80 00 00 02 | ? | 1200: 02 00 00 04 00 00 00 00 80 00 02 4E 4F D1 13 54 | NO T| 1216: 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 |PK0002287_154170| 1232: 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 |66 xxxDB TRN_H| 1248: 44 52 5F 44 42 46 0C 4D 5F 53 52 43 5F 50 46 4F |DR_DBF M_SRC_PFO| 1264: 4C 49 4F 02 02 00 07 6E 75 6D 65 72 69 63 04 0A |LIO numeric | 1280: 00 00 00 04 06 00 00 00 02 00 00 02 0A 00 00 00 | | 1296: 00 3F 81 00 00 02 02 00 00 04 00 00 00 00 81 00 | ? | 1312: 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F | NO xxx_| 1328: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 1344: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F 44 | xxx M_D| 1360: 53 54 5F 50 46 4F 4C 49 4F 02 02 00 07 6E 75 6D |ST_PFOLIO num| 1376: 65 72 69 63 04 0A 00 00 00 04 06 00 00 00 02 00 |eric | 1392: 00 02 0A 00 00 00 00 3F 82 00 00 02 02 00 00 04 | ? | 1408: 00 00 00 00 82 00 02 4E 4F D1 13 54 50 4B 30 30 | NO TPK00| 1424: 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D |02287_15417066 M| 1440: 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 |UREXDB xxx_D| 1456: 42 46 0C 4D 5F 43 4F 55 4E 54 52 50 41 52 54 02 |BF M_COUNTRPART | 1472: 02 00 07 6E 75 6D 65 72 69 63 04 0A 00 00 00 04 | numeric | 1488: 06 00 00 00 02 00 00 02 0A 00 00 00 00 3F 83 00 | ? | 1504: 00 02 02 00 00 04 00 00 00 00 83 00 02 4E 4F D1 | NO | 1520: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 1536: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 1552: 5F 48 44 52 5F 44 42 46 09 4D 5F 50 55 52 50 4F |_xxx M_PURPO| 1568: 53 45 02 01 00 04 63 68 61 72 04 0A 00 00 00 04 |SE char | 1584: 0A 00 00 00 00 00 00 00 00 2F 84 00 00 02 01 00 | / | 1600: 00 04 0A 00 00 00 84 00 02 4E 4F D1 13 54 50 4B | NO TPK| 1616: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 1632: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 1648: 5F 44 42 46 0A 4D 5F 42 4C 45 4E 54 49 54 59 02 |_DBF M_BLENTITY | 1664: 02 00 07 6E 75 6D 65 72 69 63 04 0A 00 00 00 04 | numeric | 1680: 06 00 00 00 02 00 00 02 0A 00 00 00 00 3F 85 00 | ? | 1696: 00 02 02 00 00 04 00 00 00 00 85 00 02 4E 4F D1 | NO | 1712: 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 | xxx_1541| 1728: 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E |7066 xxxDB TRN| 1744: 5F 48 44 52 5F 44 42 46 0A 4D 5F 53 4C 45 4E 54 |_xxx M_SLENT| 1760: 49 54 59 02 02 00 07 6E 75 6D 65 72 69 63 04 0A |ITY numeric | 1776: 00 00 00 04 06 00 00 00 02 00 00 02 0A 00 00 00 | | 1792: 00 3F 86 00 00 02 02 00 00 04 00 00 00 00 86 00 | ? | 1808: 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F | NO xxx_| 1824: 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 |15417066 xxxDB| 1840: 0B 54 52 4E 5F 48 44 52 5F 44 42 46 08 4D 5F 53 | xxx M_S| 1856: 49 5F 54 43 49 02 02 00 07 6E 75 6D 65 72 69 63 |I_TCI numeric| 1872: 04 0A 00 00 00 04 06 00 00 00 02 00 00 02 0A 00 | | 1888: 00 00 00 3F 87 00 00 02 02 00 00 04 00 00 00 00 | ? | 1904: 87 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 | NO TPK000228| 1920: 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 |7_15417066 xxx| 1936: 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0B 4D |DB xxx M| 1952: 5F 43 4F 4C 4C 41 47 43 41 54 02 02 00 07 6E 75 |_COLLAGCAT nu| 1968: 6D 65 72 69 63 04 0A 00 00 00 04 06 00 00 00 02 |meric | 1984: 00 00 02 0A 00 00 00 00 3F 88 00 00 02 02 00 00 | ? | 2000: 04 00 00 00 00 88 00 02 4E 4F D1 13 54 50 4B 30 | NO TPK0| 2016: 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 07 |002287_15417066 | 2032: 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F |xxxDB xxx_| ----- Stream #2 read last Reply packet 0: 04 01 02 C5 00 00 00 00 44 42 46 09 4D 5F 4C 45 | DBF M_LE| 16: 58 54 52 45 46 02 02 00 07 6E 75 6D 65 72 69 63 |XTREF numeric| 32: 04 0A 00 00 00 04 06 00 00 00 02 00 00 02 0A 00 | | 48: 00 00 00 3F 89 00 00 02 02 00 00 04 00 00 00 00 | ? | 64: 89 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 32 38 | NO TPK000228| 80: 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 45 58 |7_15417066 xxx| 96: 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 0C 4D |DB xxx M| 112: 5F 4C 45 56 54 45 58 54 52 45 46 02 02 00 07 6E |_LEVTEXTREF n| 128: 75 6D 65 72 69 63 04 0A 00 00 00 04 06 00 00 00 |umeric | 144: 02 00 00 02 0A 00 00 00 00 3F 8A 00 00 02 02 00 | ? | 160: 00 04 00 00 00 00 8A 00 02 4E 4F D1 13 54 50 4B | NO TPK| 176: 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 36 36 |0002287_15417066| 192: 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 44 52 | xxxDB xxx| 208: 5F 44 42 46 0C 4D 5F 4C 49 4D 50 45 58 54 52 45 |_DBF M_LIMPEXTRE| 224: 46 02 02 00 07 6E 75 6D 65 72 69 63 04 0A 00 00 |F numeric | 240: 00 04 06 00 00 00 02 00 00 02 0A 00 00 00 00 3F | ?| 256: 8B 00 00 02 02 00 00 04 00 00 00 00 8B 00 02 4E | N| 272: 4F D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 |O xxx_15| 288: 34 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 |417066 xxxDB T| 304: 52 4E 5F 48 44 52 5F 44 42 46 0C 4D 5F 42 5F 53 |RN_xxx M_B_S| 320: 54 47 5F 4E 4F 44 45 02 02 00 07 6E 75 6D 65 72 |TG_NODE numer| 336: 69 63 04 0A 00 00 00 04 06 00 00 00 02 00 00 02 |ic | 352: 0A 00 00 00 00 3F 8C 00 00 02 02 00 00 04 00 00 | ? | 368: 00 00 8C 00 02 4E 4F D1 13 54 50 4B 30 30 30 32 | NO TPK0002| 384: 32 38 37 5F 31 35 34 31 37 30 36 36 07 4D 55 52 |287_15417066 MUR| 400: 45 58 44 42 0B 54 52 4E 5F 48 44 52 5F 44 42 46 |EXDB xxx| 416: 0C 4D 5F 53 5F 53 54 47 5F 4E 4F 44 45 02 02 00 | M_S_STG_NODE | 432: 07 6E 75 6D 65 72 69 63 04 0A 00 00 00 04 06 00 | numeric | 448: 00 00 02 00 00 02 0A 00 00 00 00 3F 8D 00 00 02 | ? | 464: 02 00 00 04 00 00 00 00 8D 00 02 4E 4F D1 13 54 | NO T| 480: 50 4B 30 30 30 32 32 38 37 5F 31 35 34 31 37 30 |PK0002287_154170| 496: 36 36 07 4D 55 52 45 58 44 42 0B 54 52 4E 5F 48 |66 xxxDB TRN_H| 512: 44 52 5F 44 42 46 09 4D 5F 50 52 43 5F 43 54 50 |DR_DBF M_PRC_CTP| 528: 02 02 00 07 6E 75 6D 65 72 69 63 04 0A 00 00 00 | numeric | 544: 04 06 00 00 00 02 00 00 02 0A 00 00 00 00 3F 8E | ? | 560: 00 00 02 02 00 00 04 00 00 00 00 8E 00 02 4E 4F | NO| 576: D1 13 54 50 4B 30 30 30 32 32 38 37 5F 31 35 34 | xxx_154| 592: 31 37 30 36 36 07 4D 55 52 45 58 44 42 0B 54 52 |17066 xxxDB TR| 608: 4E 5F 48 44 52 5F 44 42 46 0B 4D 5F 55 50 4C 5F |N_xxx M_UPL_| 624: 49 4E 53 54 52 02 02 00 07 6E 75 6D 65 72 69 63 |INSTR numeric| 640: 04 0A 00 00 00 04 06 00 00 00 02 00 00 02 0A 00 | | 656: 00 00 00 3F 8F 00 00 02 02 00 00 04 00 00 00 00 | ? | 672: 8F 00 02 4E 4F FF 51 00 02 00 8F 00 00 00 FF 51 | NO Q Q| 688: 00 02 00 01 00 00 00 79 00 00 00 00 FD 00 00 02 | y | 704: 00 01 00 00 00 | | 14:11:39 [DEBUG ExecutorRunner-pool-3-thread-23 AbstractFacade.getColumn] executing "select user_name()" 14:11:39 [DEBUG pool-4-thread-39 C.?] DefaultEditor24: ConnectionJDBC3.createStatement() 14:11:39 [DEBUG pool-4-thread-39 B.?] DefaultEditor24: JtdsStatement.executeQuery("select user_name()") ----- Stream #1 send last TDS5 Request packet 0: 0F 01 00 20 00 00 00 00 21 13 00 00 00 00 73 65 | ! se| 16: 6C 65 63 74 20 75 73 65 72 5F 6E 61 6D 65 28 29 |lect user_name()| ----- Stream #1 read last Reply packet 0: 04 01 00 35 00 00 00 00 61 12 00 00 00 01 00 00 | 5 a | 16: 00 00 00 00 30 00 00 00 02 00 00 00 27 1E 00 AE | 0 ' | 32: 01 00 00 D1 07 4D 55 52 45 58 44 42 FD 10 00 02 | xxxDB | 48: 00 01 00 00 00 | | 14:11:39 [DEBUG ExecutorRunner-pool-3-thread-23 AbstractFacade.getColumn] executing "select user_name()" 14:11:39 [DEBUG pool-4-thread-39 C.?] DefaultEditor24: ConnectionJDBC3.createStatement() 14:11:39 [DEBUG pool-4-thread-39 B.?] DefaultEditor24: JtdsStatement.executeQuery("select user_name()") ----- Stream #1 send last TDS5 Request packet 0: 0F 01 00 20 00 00 00 00 21 13 00 00 00 00 73 65 | ! se| 16: 6C 65 63 74 20 75 73 65 72 5F 6E 61 6D 65 28 29 |lect user_name()| ----- Stream #1 read last Reply packet 0: 04 01 00 35 00 00 00 00 61 12 00 00 00 01 00 00 | 5 a | 16: 00 00 00 00 30 00 00 00 02 00 00 00 27 1E 00 AE | 0 ' | 32: 01 00 00 D1 07 4D 55 52 45 58 44 42 FD 10 00 02 | xxxDB | 48: 00 01 00 00 00 | |
[This reply is migrated from our old forums.]

Re: How to understand slowness of a SQL statement
Hi, Thanks! Can you please re-run and enable only "Debug DbVisualizer" in Tools->Debug Window? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: How to understand slowness of a SQL statement
Hi Roger, Thanks for your prompt feedback. Below is the output 16:09:50 [DEBUG pool-4-thread-50 C.?] RootConnection: ConnectionJDBC3.createStatement() 16:09:50 [DEBUG ExecutorRunner-pool-3-thread-29 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 16:09:50 [DEBUG pool-4-thread-50 B.?] RootConnection: JtdsStatement.executeQuery("SELECT 1") 16:09:50 [DEBUG pool-4-thread-50 C.?] DefaultEditor24: ConnectionJDBC3.createStatement() 16:09:50 [DEBUG ExecutorRunner-pool-3-thread-29 AbstractFacade.isValid] Executing connection validation statement: SELECT 1 16:09:50 [DEBUG pool-4-thread-50 B.?] DefaultEditor24: JtdsStatement.executeQuery("SELECT 1") 16:09:50 [DEBUG ExecutorRunner-pool-3-thread-29 AbstractFacade.getColumn] executing "select user_name()" 16:09:50 [DEBUG pool-4-thread-50 C.?] DefaultEditor24: ConnectionJDBC3.createStatement() 16:09:50 [DEBUG pool-4-thread-50 B.?] DefaultEditor24: JtdsStatement.executeQuery("select user_name()") 16:09:50 [DEBUG ExecutorRunner-pool-3-thread-29 J.execute] Executing... 16:09:50 [DEBUG ExecutorRunner-pool-3-thread-29 J.setCurrentCatalog] DbConnection='ZZ334ZN - conv - syb157' Catalog='AAAAA' Schema='null' NewCatalog='AAAAA' 16:09:50 [DEBUG ExecutorRunner-pool-3-thread-29 AbstractFacade.getColumn] executing "select user_name()" 16:09:50 [DEBUG pool-4-thread-50 C.?] DefaultEditor24: ConnectionJDBC3.createStatement() 16:09:50 [DEBUG pool-4-thread-50 B.?] DefaultEditor24: JtdsStatement.executeQuery("select user_name()") 16:09:50 [DEBUG ExecutorRunner-pool-3-thread-29 J.setCurrentSchema] DbConnection='ZZ334ZN - conv - syb157' Catalog='null' Schema='BBBBB' NewSchema='BBBBB' 16:09:50 [DEBUG pool-4-thread-50 C.?] DefaultEditor24: ConnectionJDBC3.createStatement() 16:09:50 [DEBUG pool-4-thread-50 B.?] DefaultEditor24: JtdsStatement.execute("select COL_A from TABLE_A where COL_B=1276187") 16:09:50 [DEBUG ExecutorRunner-pool-3-thread-29 AbstractFacade.getColumn] executing "select user_name()" 16:09:50 [DEBUG pool-4-thread-50 C.?] DefaultEditor24: ConnectionJDBC3.createStatement() 16:09:50 [DEBUG pool-4-thread-50 B.?] DefaultEditor24: JtdsStatement.executeQuery("select user_name()") 16:09:50 [DEBUG ExecutorRunner-pool-3-thread-29 N.?] DbConnection='ZZ334ZN - conv - syb157' Catalog='AAAAA' Schema='BBBBB' Table='TABLE_A' Column='%' 16:09:50 [DEBUG pool-4-thread-50 E.?] DefaultEditor24: JtdsDatabaseMetaData.getColumns("AAAAA", "BBBBB", "TABLE_A", "%") 16:09:53 [DEBUG ExecutorRunner-pool-3-thread-29 AbstractFacade.getColumn] executing "select user_name()" 16:09:53 [DEBUG pool-4-thread-50 C.?] DefaultEditor24: ConnectionJDBC3.createStatement() 16:09:53 [DEBUG pool-4-thread-50 B.?] DefaultEditor24: JtdsStatement.executeQuery("select user_name()") 16:09:54 [DEBUG ExecutorRunner-pool-3-thread-29 AbstractFacade.getColumn] executing "select user_name()" 16:09:54 [DEBUG pool-4-thread-50 C.?] DefaultEditor24: ConnectionJDBC3.createStatement() 16:09:54 [DEBUG pool-4-thread-50 B.?] DefaultEditor24: JtdsStatement.executeQuery("select user_name()") Best Simon
[This reply is migrated from our old forums.]

Re: How to understand slowness of a SQL statement
Simon, Sorry for the delay. It seems that the database call to fetch the columns for the table is taking much of the time. Testing this with the jConnect driver from Sybase would indicate whether it is a driver issue or on the DB side. Regards Roger