Db2 (On Premises and Cloud)

Expand all | Collapse all

DMC 3.1.4 (Docker, May 2021) has issues with long statements

  • 1.  DMC 3.1.4 (Docker, May 2021) has issues with long statements

    Posted Thu May 20, 2021 01:56 PM
    Hi,

    in a DWH like environment I'm monitoring a DWH database. Some warnings about long running statements pop up and when I try to open these warnings, I get following error message:

    Statement could not be formatted due to a syntax error. Please, validate your statement first.
    Error code 9, from line 1 col 1047 to line 1 col 2498 (offset 1046 to 2497), msg text: ")" inserted to complete scope Error code 9, from line 1 col 823 to line 1 col 2498 (offset 822 to 2497), msg text: ")" inserted to complete scope Error code 9, from line 1 col 807 to line 1 col 2498 (offset 806 to 2497), msg text: ")" inserted to complete scope Error code 9, from line 1 col 807 to line 1 col 2498 (offset 806 to 2497), msg text: "JOIN <joined_table>" inserted to complete scope Error code 10, from line 1 col 2480 to line 1 col 2498 (offset 2479 to 2497), msg text: "EOF_TOKEN" reached after this token

    Sometimes DMC shows the statement, sometimes it doesn't.

    Kind regards
    Roland

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


  • 2.  RE: DMC 3.1.4 (Docker, May 2021) has issues with long statements

    Posted Thu May 20, 2021 02:13 PM
    I decided to share this information here, if others have the same issue.
    For IBM I have opened a case: TS005703301

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



  • 3.  RE: DMC 3.1.4 (Docker, May 2021) has issues with long statements

    Posted Fri May 21, 2021 01:14 AM
    Hi Roland,

    Thanks for reporting the issue.  We will work on the case.

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



  • 4.  RE: DMC 3.1.4 (Docker, May 2021) has issues with long statements

    Posted Fri May 21, 2021 02:38 AM
    Look here:

    https://community.ibm.com/community/user/hybriddatamanagement/communities/community-home/digestviewer/viewthread?GroupId=2983&MessageKey=ab211fea-8f7a-4bd0-bc4d-0b4920d14db6&CommunityKey=ea909850-39ea-4ac4-9512-8e2eb37ea09a&tab=digestviewer&ReturnUrl=%2fcommunity%2fuser%2fhybriddatamanagement%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3dea909850-39ea-4ac4-9512-8e2eb37ea09a%26tab%3ddigestviewer

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



  • 5.  RE: DMC 3.1.4 (Docker, May 2021) has issues with long statements

    Posted Fri May 21, 2021 04:42 AM
    @Michael Klemmer Thanks for the hint! As I also see above, L3 is working on it and hopefully we'll have a solution in the next release.


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



  • 6.  RE: DMC 3.1.4 (Docker, May 2021) has issues with long statements

    Posted Mon May 24, 2021 06:12 PM
    Hi Roland,

    The issue with showing long SQL text in alerts will be fixed in the upcoming release, together with steps to collection trace in docker version of DMC.  

    Thanks.

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