SQL ERROR -104 WHEN "!!" IS USED TO CONCATENATE STRINGS

2117IDB2

Problem Details

Release

19.0

Distribution Code

AVAILABLE

Status

CLOSED PROBLEM

Opened On

Feb 13, 2017

Closed On

Mar 09, 2017

Updated On

Mar 08, 2021

Problem Description

PROBLEM DESCRIPTION:
The CA SYSVIEW Performance Management Option for DB2 for z/OS (IDB2)
explain feature ends with SQL error -104 when the explained statement
contains "!!" as the string concatenation operator.


SYMPTOMS:
The following message is displayed on the terminal:
DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "!". SOME SYMBOLS THAT MIGHT
         BE LEGAL ARE: AT MICROSECONDS MICROSECOND SECONDS SECOND MINUTES
         MINUTE HOURS
DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD    = 3  0  0  -1  52  502 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD    = X'00000003'  X'00000000'  X'00000000'  X'FFFFFFFF'
         X'00000034'  X'000001F6' SQL DIAGNOSTIC INFORMATION.


IMPACT:
The statement cannot be explained.


CIRCUMVENTION:
None.


PRODUCT(S) AFFECTED:
CA SYSVIEW Performance Management Option for DB2 for z/OS    Version 19.0
CA SYSVIEW Performance Management Option for DB2 for z/OS    Version 18.0

Related Solutions

APAR No

Title

Release

OS

RO94743 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94749 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94739 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94744 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94731 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94727 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94747 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94734 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94745 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94740 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94748 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94738 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94736 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94737 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94746 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94735 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94732DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94728 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94741 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94733 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94742 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94729 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS
RO94730 DB2 TOOLS CONSOLIDATED UPDATE #719.0z/OS

Related Products