Hi, Off late we started seeing detailed logging/buffer dumps like the below in the derby logs. Any idea how to disable this level of logging or how this logging could have got enabled?
--------- [derby][Time:1614982562801][Thread:pool-10-thread-1][Connection@100f5a06] createStatement () called [derby][Time:1614982562801][Thread:pool-10-thread-1][Connection@100f5a06] createStatement () returned Statement@f4937dd3 [derby][Time:1614982562801][Thread:pool-10-thread-1][Statement@f4937dd3] executeQuery (select 1 from sysibm.sysdummy1) called [derby][Time:1614982562801][Thread:pool-10-thread-1][Connection@100f5a06] isClosed () returned false [derby] [net][time:1614982562801][thread:pool-10-thread-1][tracepoint:1][Request.flush] [derby] SEND BUFFER: PRPSQLSTT (ASCII) (EBCDIC) [derby] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF [derby] 0000 0079D05100010073 200D00652113002D .y.Q...s ..e!..- .`}............. [derby] 0010 2F7573722F69726F 6E686964652F7661 /usr/ironhide/va .......?>....../ [derby] 0020 722F64622F6F7263 6D6F6E2F64657262 r/db/orcmon/derb .....?.._?>..... [derby] 0030 793B637265617465 3D7472756500124E y;create=true..N `..../.........+ [derby] 0040 554C4C4944202020 2020202020202020 ULLID .<<............. [derby] 0050 2000125359534C48 3030302020202020 ..SYSLH000 ......<......... [derby] 0060 2020202020535953 4C564C3031000B00 SYSLVL01... ........<.<..... [derby] 0070 052116F100052146 04 .!....!F. ...1..... [derby] [derby] SEND BUFFER: (ASCII) (EBCDIC) [derby] 0000 001AD05300010014 2450000000000A57 ...S....$P.....W ..}......&...... [derby] 0010 49544820484F4C44 20FF002ED0430001 ITH HOLD ....C.. .....|<.....}... [derby] 0020 0028241400000000 1E73656C65637420 .($......select ...........%.... [derby] 0030 312066726F6D2073 797369626D2E7379 1 from sysibm.sy ....?_..`..._..` [derby] 0040 7364756D6D7931FF 007CD00100020076 sdummy1..|.....v ...__`...@}..... [derby] 0050 200C00652113002D 2F7573722F69726F ..e!..-/usr/iro ...............? [derby] 0060 6E686964652F7661 722F64622F6F7263 nhide/var/db/orc >....../.....?.. [derby] 0070 6D6F6E2F64657262 793B637265617465 mon/derby;create _?>.....`..../.. [derby] 0080 3D7472756500124E 554C4C4944202020 =true..NULLID .......+.<<..... [derby] 0090 2020202020202020 2000125359534C48 ..SYSLH ..............<. [derby] 00A0 3030302020202020 2020202020535953 000 SYS ................ [derby] 00B0 4C564C3031000B00 08211400007FFF00 LVL01....!...... <.<..........".. [derby] 00C0 05215D01 .!]. ..). [derby] [derby] [net][time:1614982562801][thread:pool-10-thread-1][tracepoint:2][Reply.fill] [derby] RECEIVE BUFFER: SQLDARD (ASCII) (EBCDIC) [derby] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF 0123456789ABCDEF [derby] 0000 0099D04300010093 2411000000000020 ...C....$...... .r}....l........ [derby] 0010 2020202043535331 3030383100000000 CSS10081.... ................ [derby] 0020 0000000000000000 0000000000000000 ................ ................ [derby] 0030 0000000000202020 2020202020202020 ..... ................ [derby] 0040 000000000000FF00 0001000000000000 ................ ................ [derby] 0050 0000000000000000 00000001000A0000 ................ ................ [derby] 0060 0000000000000004 01F0000000000000 ................ .........0...... [derby] 0070 0131000000000000 00000000FF000000 .1.............. ................ [derby] 0080 0000000000000000 0000000000000000 ................ ................ [derby] 0090 0000000000013100 00 ......1.. ......... [derby] [derby] RECEIVE BUFFER: OPNQRYRM (ASCII) (EBCDIC) [derby] 0000 002CD05200020026 2205000611490000 .,.R...&"....I.. ..}............. [derby] 0010 0006210224170005 211FF1000C215B00 ..!.$...!....![. ..........1...$. [derby] 0020 000000000000E600 05215001 .........!P. ......W...&. [derby] [derby] RECEIVE BUFFER: QRYDSC (ASCII) (EBCDIC) [derby] 0000 001FD05300020019 241A0676D0020004 ...S....$..v.... ..}.........}... [derby] 0010 0971E0540001D000 010671F0E00000 .q.T......q.... ..\...}....0\.. [derby] [derby] RECEIVE BUFFER: QRYDTA (ASCII) (EBCDIC) [derby] 0000 004ED00300020048 241BFF0000000001 .N.....H$....... .+}............. [derby] 0010 0000000064303230 3030435353313030 ....d02000CSS100 ................ [derby] 0020 3831000000000000 0000010000000000 81.............. ................ [derby] 0030 0000000000000000 0000002020202020 ........... ................ [derby] 0040 2020202020200000 00000000FFFF ........ .............. [derby] [derby][ResultSetMetaData@1abd872d] BEGIN TRACE_RESULT_SET_META_DATA [derby][ResultSetMetaData@1abd872d] Result set meta data for statement Statement@f4937dd3 [derby][ResultSetMetaData@1abd872d] Number of result set columns: 1 [derby][ResultSetMetaData@1abd872d] Column 1: { label=1, name=1, type name=INTEGER, type=4, nullable=0, precision=10, scale=0, schema name=, table name=, writable=false, sqlPrecision=10, sqlScale=0, sqlLength=4, sqlType=496, sqlCcsid=0, sqlName=1, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxCorname=null, sqlxName=1, sqlxBasename=null, sqlxUpdatable=0, sqlxSchema=null, sqlxRdbnam=, internal type=4, } [derby][ResultSetMetaData@1abd872d] { sqldHold=1, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=, sqldSchema=null } [derby][ResultSetMetaData@1abd872d] END TRACE_RESULT_SET_META_DATA [derby][Time:1614982562801][Thread:pool-10-thread-1][Statement@f4937dd3] executeQuery () returned ResultSet@2908d4ea [derby][Time:1614982562801][Thread:pool-10-thread-1][ResultSet@2908d4ea] close () called ---- Thanks,