DBXMMPR gets DB21089W invalid ISOLEVEL for system plan SYSADM.SQLCOBOL81

Document ID:  TEC1749876
Last Modified Date:  08/02/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Datacom SQL

Releases

  • CA Datacom SQL:Release:15.0
  • CA Datacom SQL:Release:15.1

Components

  • CA DATACOM SQL:SQL
Symptoms:

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.

Workaround:

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.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >