CA Log Analyzer summary report execution encounters DSNT408I SQL-199 error.

book

Article ID: 7229

calendar_today

Updated On:

Products

CA-24X7 High-Availability Manager for DB2 for z/OS CA-Batch Processor Compile QQF CA Data Compressor for DB2 for z/OS Data Navigator for DB2 UDB for z/OS CA-DB Delivery for DB2 CA Unicenter NSM CA Log Compress DBA for DB2 Guide Online CA InfoRefiner Advantage InfoRefiner Advantage InfoRefiner Maint Upgrade CA InfoTransport Advantage InfoTransport Maint Upgrade Online Reorg for DB2 for z/OS CA RC/Update for DB2 for z/OS Query Analyzer RI Editor for DB2 for z/OS DB2 TOOLS- DATABASE MISC

Issue/Introduction

Executing CA Log Analyzer for DB2 for z/OS (PLA) summary report and receiving the following messages:

NEW CATALOG UNIT(SYSDA)
.CALL LOG
.DATA
SSID = (xxxx)
START = (DATE(2017-06-27),TIME(00:00:00.000000))
END = (DATE(2017-06-27),TIME(13:21:00.000000))
LOGSRC = (BSDS)
OBJSRC = (CATALOG)
COPYSRC = (CATALOG)
DYNSORT = (DSNUM(2),SPACE(10,10),MAINSIZE(1000),MSG(N))
GENUNIT = (SYSDA)
RPTLINES = (60)
S99WAIT = (YES)
RESOLVUR = (END)
WORKLOAD = (LARGE)
DMLREPT = (LEVEL (SUMMARY)
,ROLLBACK (INCLUDE)
,CATALOG (EXCLUDE)
,DSNDB01 (EXCLUDE)
,UNDEFTB (INCLUDE)
,LOBDATA (EXCLUDE)
,XMLDATA (EXCLUDE)
,ORDERBY (URID)
,DISCARDS (0)
)
EXTRACT = (FILTER)
.ENDDATA
.FREE FI(LADXTRCT)
.FREE FI(LADXCNTL)
.FREE FI(LADREPT)

DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD NEW. TOKEN
<ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE ASSOCIATE
WAS EXPECTED
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 2 0 0 -1 1 506 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000002' X'00000000' X'00000000'
X'FFFFFFFF' X'00000001' X'000001FA' SQL DIAGNOSTIC
INFORMATION
BPA0012E: DB2 SQL/DDL ERROR HAS OCCURRED - ROLLBACK ISSUED.
RETCODE = 8

 

Environment

Release:
Component: PLA

Resolution

Check the control statement prior to the PLA .CALL LOG control card for missing continuation.  For example the proceeding .ALLOC statement may be missing a + continuation character in column 72.