Syntax Error on SQLTRACE

Article Id: 76455

Status: Published

Updated On: 05-04-2018 02:42

Products:

CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction:

DBG04003E DST1 08:29:17 REQUEST SPECIFIES AN IFCID UNSUPPORTED BY DB2 - 366 DBG04002E DST1 08:29:17 FAILURE IN ADDING REQUEST TO ACTIVE LIST DBG04001E DST1 08:29:17 SYNTAX ERROR IN REQUEST; NOT STARTED

We have recently upgraded to R20.0 of CA Sysview for DB2. When attempting to start an SQLTRACE(3 - Traditional Application Probe), am receiving the following error: Check Check Syntax - Request SQLTRACE Row 1585-1593/1593 ------------------------------------------------------------------------------ 1583 NEVENTS = 1500 1584 * PRINT (DA('GSW.JBG.REQUESTS.PRINTFL2')SHR) 1585 * NOWRAP=YES /* UNCOMMENT TO PREVENT WRAPPING OVER 1ST 1500 EVENTS */ 1586 TERMINAL (help=DBGRSQT,nodata=DBGNTRF) 1587 ;

DBG04003E DST1 08:29:17 REQUEST SPECIFIES AN IFCID UNSUPPORTED BY DB2 - 366 DBG04002E DST1 08:29:17 FAILURE IN ADDING REQUEST TO ACTIVE LIST DBG04001E DST1 08:29:17 SYNTAX ERROR IN REQUEST; NOT STARTED

Have validated that the correct CDBATREQ was copied into our runtime dataset and have validated other things directly related to the install of the new version.

Environment:

z/os DB2

Resolution:

Update Datacollector DB2 Version parm to 12.1
e.g
DB2VER=12.1

corrects the problem