DBXMMPR gets DB21089W invalid ISOLEVEL for system plan SYSADM.SQLCOBOL81

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

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                              

 

 

 

Environment:
z/OS CA DATACOM SQL 15.1
Cause:

Cause is unknown.

Resolution:

Run DDUPDATE to delete this system plan.

Use SYSIN cards: 

-USR DATACOM-INSTALL,NEWUSER 

-DEL PLAN,SYSADM-SQLCOBOL81(1)  

-DEL PLAN,SYSADM-SQLCOBOL81(1)

 

 

Additional Information:

This system plan will get recreated from scratch with the next SQL Cobol precompile job.