Syntax Error on SQLTRACE
Article ID: 76455
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.
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
e.g
DB2VER=12.1
corrects the problem
Feedback
Powered by
