After upgrade from CA Datacom 14.0 to 15.1,DBXMMPR might not run successfully.
The PXX contains :
-- DATA BASE SQL ERROR SUMMARY date time --
SQLSTATE 53S14 OCCURRED WITH SQL ERROR CODE -145 IN PROG planAllo AT LINE 572 (PLNALLC)
ERROR MESSAGE TEXT: INVALID 'ISOLEVEL' PLAN OPTION:
AUTH-ID.PLAN NAME: SYSADM.SQLCOBOL81
COMMAND(STATEMENT ID): QEXEC(STATEMENT 17)
JOB NAME: xxxxxxxx, RUN UNIT: nnnnn
Plan SYSADM SQLCOBOL81 NX.SQLCOBOL81 NX has invalid isolation level
DBSRPPR: END REQ nnnn JOB nnnnn RWTSA n SQLCODE -145
Cause is unknown.
Run DDUPDATE to delete this system plan.
Use SYSIN cards:
-USR DATACOM-INSTALL,NEWUSER
-DEL PLAN,SYSADM-SQLCOBOL81(1)
-DEL PLAN,SYSADM-SQLCOBOL81(1)
This system plan will get recreated from scratch with the next SQL Cobol precompile job.