Getting 'SQLCODE = -124 SQLCA-ERR-MSG = PLAN authid.planname DOES NOT EXIST' in Production environment.

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

Products

  • CA Datacom SQL

Releases

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

Components

  • CA DATACOM SQL:SQL
Issue:

My SQL Cobol program was successfully precompiled/compiled/linked and executed in my TEST environment.

In Production environment however,it fails with PLAN NOT FOUND.  

SQLCODE = -124

SQLCA-ERR-MSG = PLAN SYSADM.APCB8005 DOES NOT EXIST 

 

Environment:
z/OS and z/VSE CA Datacom SQL - all versions
Cause:

In TEST environment you ran the SQL Cobol precompiler DBXMMPR and that process created the SQL PLAN in Datadictionary.

If you do not promote the COBOL program source to the PROD environment and run the SQL Cobol Precompiler/Cobol compiler/link-editor there but you just transfer the program loadmodule then you need to transfer the corresponding PLAN from your TEST datadictionary into the PROD datadictionary.

 

The PLAN needs to be in sync with the program loadmodule. 

Resolution:

1.In your TEST environment,run DDTRSLM using SYSIN cards:  

SET USER DATACOM-INSTALL NEWUSER ;

EXPORT PLAN SYSADM.APCB8005 ONLY ALL PLAN;   

 

2.In your PROD environment,run DDTRSLM using the DDTRSLM generated TRANSF data set from TEST as input and use SYSIN cards :

SET USER DATACOM-INSTALL NEWUSER ;

SET IMPORT COLLISION REPLACE;

IMPORT PLAN SYSADM.APCB8005;

 

Note that the layout of the tables in TEST and PROD needs to be the same.

 

Additional Information:

See the online documentation here.

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 >