Db2 (On Premises and Cloud)

Expand all | Collapse all

DMC 3.1.4 Warnings about total activity time for sql, sql too big for DMC

  • 1.  DMC 3.1.4 Warnings about total activity time for sql, sql too big for DMC

    Posted 10 days ago
    Hi DMC Team,

    I have many big sqls, causing long run time warnings via DMC. Problem is, these sqls cannot be captured entirely by DMC because the max size of sql text is 2500 bytes.

    When opening a warning with larger sqls, the following message occurs:

    Statement could not be formatted due to a syntax error. Please, validate your statement first.
    Error code 10, from line 1 col 2487 to line 1 col 2499 (offset 2486 to 2498), msg text: "EOF_TOKEN" reached after this token


    plus it is not possible to show explain etc, because sql text is cut off after 2500 bytes.

    Please make it possible to analyze SQL text larger than 2500 Bytes!

    Greetings from Hamburg

    ------------------------------
    Michael
    ------------------------------


  • 2.  RE: DMC 3.1.4 Warnings about total activity time for sql, sql too big for DMC

    Posted 9 days ago
    Hi Michael,

    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? 



    ------------------------------
    Rui Li
    ------------------------------



  • 3.  RE: DMC 3.1.4 Warnings about total activity time for sql, sql too big for DMC

    Posted 9 days ago
    Yes, the message appears after clicking the Message itself, if the "format SQL statement" Button has been pressed previously.
    The Table IBMCONSOLE.ALERT_PROPERTIES only has 2500 octets varchar for the SQL text. So it is cut off. When trying to format the SQL, the error occurs.


    Michael

    ------------------------------
    Michael Klemmer
    ------------------------------



  • 4.  RE: DMC 3.1.4 Warnings about total activity time for sql, sql too big for DMC

    Posted 9 days ago

    ​I would like to see the captured SQL expanded as well. Max length of a SQL Statement is:2,097,152



    ------------------------------
    Douglas Kostelnik
    Applications Architect
    The Auto Club Group
    Tampa FL
    ------------------------------



  • 5.  RE: DMC 3.1.4 Warnings about total activity time for sql, sql too big for DMC

    Posted 5 days ago
    This is a limitation. We need a better design to enhance this, for example, we may change the table to be CLOB, this will cause problem when upgrading.
    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.  Again we need a better design for this. Can you please open a RFE for this?

    ------------------------------
    XU QIN ZHAO
    ------------------------------