Syntax Error on SQLTRACE

book

Article ID: 76455

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector 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