Thanks for reporting this issue. We support about 32kb of sql in dmc 3.1.4 and we are working at balancing SQL integrity with performance. Dose the message appear after clicking sql to view the whole statement?
I would like to see the captured SQL expanded as well. Max length of a SQL Statement is:2,097,152
@Douglas Kostelnik, sorry to jump in your trhead...
@XU OIN ZHAO...
"Also to support huge statement text, CLOB is not enough, we may cut the statement text into chunks and put it into CLOB columns, and merge back when pulling data."
Why do you believe CLOB wouldn't be enough.. CLOB columns can hold up to 2GB. All Db2 STMT_TEXT columns in monitor table functions (MON_GET_...) are 2GB CLOB columns..
DMC should use the same.. AS the main IBM product to manage and monitor Db2 databases, it should be capable of to monitor all Statements.. not only statements bellow a certain size.