Db2

  • 1.  DMC 3.1.2 is shortening statements

    IBM Champion
    Posted Thu August 20, 2020 03:49 AM
    Hi,

    I just updated a customers installation of DMC 3.1.1 to 3.1.2 and noticed, that the statements displayed in the notification center get shortened to 2500 bytes.
    However statements in this SIEBEL environment easily gets longer than 8000 bytes and especially the interesting parts come near the end.
    So the show more option should show the full statement.

    Also the "View access plan" is sending this short copy of the statement into explain. Hence it is impossible to do an immediate explain of such a shortened statement.

    Cheers

    ------------------------------
    Roland Schock
    Distinguished Engineer
    ARS Computer und Consulting GmbH
    Muenchen
    ------------------------------

    #Db2


  • 2.  RE: DMC 3.1.2 is shortening statements

    Posted Thu August 20, 2020 07:02 PM
    Hello Roland,

    Thank you for the observation.  And it is an important use case to capture the query text for future analysis and EXPLAIN.  We have opened an internal defect to track this issue in Notification center.  Thank you.

    Best Regards,

    ------------------------------
    Jason Sizto
    ------------------------------