DBXMMPR gets DB21089W invalid ISOLEVEL for system plan SYSADM.SQLCOBOL81
search cancel

DBXMMPR gets DB21089W invalid ISOLEVEL for system plan SYSADM.SQLCOBOL81

book

Article ID: 7652

calendar_today

Updated On:

Products

Datacom DATACOM - AD

Issue/Introduction

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.