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

Document ID : KB000007229
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

 

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.