Db2

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
------------------------------

#Db2

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
------------------------------

Original Message:
Sent: Thu May 20, 2021 01:56 PM
From: Roland Schock
Subject: DMC 3.1.4 (Docker, May 2021) has issues with long statements

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
------------------------------

#Db2

Hi Roland,

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

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

Original Message:
Sent: Thu May 20, 2021 02:12 PM
From: Roland Schock
Subject: DMC 3.1.4 (Docker, May 2021) has issues with long statements

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

Original Message:
Sent: Thu May 20, 2021 01:56 PM
From: Roland Schock
Subject: DMC 3.1.4 (Docker, May 2021) has issues with long statements

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
------------------------------

#Db2

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
------------------------------

Original Message:
Sent: Thu May 20, 2021 01:56 PM
From: Roland Schock
Subject: DMC 3.1.4 (Docker, May 2021) has issues with long statements

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
------------------------------

#Db2

@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
------------------------------

Original Message:
Sent: Fri May 21, 2021 02:38 AM
From: Michael Klemmer
Subject: DMC 3.1.4 (Docker, May 2021) has issues with long statements

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

Original Message:
Sent: Thu May 20, 2021 01:56 PM
From: Roland Schock
Subject: DMC 3.1.4 (Docker, May 2021) has issues with long statements

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
------------------------------

#Db2

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
------------------------------

Original Message:
Sent: Fri May 21, 2021 04:41 AM
From: Roland Schock
Subject: DMC 3.1.4 (Docker, May 2021) has issues with long statements

@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

Original Message:
Sent: Fri May 21, 2021 02:38 AM
From: Michael Klemmer
Subject: DMC 3.1.4 (Docker, May 2021) has issues with long statements

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

Original Message:
Sent: Thu May 20, 2021 01:56 PM
From: Roland Schock
Subject: DMC 3.1.4 (Docker, May 2021) has issues with long statements

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
------------------------------

#Db2