SQL -117 error (DDTRS0016E) trying to run CA-ENF AW1IMPRT job

Products

• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware
• Datacom/AD
• Datacom

Issue/Introduction

You are installing a new release of CA Common Services or applying maintenance that requires you to import a new ENF plan into an existing Datacom/AD MUF that has been setup and customized for ENF's usage.

You customized and submitted job AW1IMPRT from the CAW0JCL library but the job fails.

The JESMSGLG shows the following messages…

 15.55.13 JOB08287  +DB00121I - UNAVAILABLE - CAENFMUF
 15.55.13 JOB08287  +DB00122I - ACCESS TYPE - LOCAL    TASKS=1
 15.55.13 JOB08287  +DB00123I - WAITING FOR MUF AVAILABILITY
 15.55.13 JOB08287  +DB00124W - REMAINING DELAY68 TIME -    2 MINUTES
 15.56.13 JOB08287  +DB00124W - REMAINING DELAY68 TIME -    1 MINUTES
 15.57.18 JOB08287  +DB00501E - OPEN ERROR - RETURN CODE 68 (001) CXX=

 

The SYSPRINT reports the following messages...

SET USER DATACOM-INSTALL NEWUSER;
 SET IMPORT COLLISION REPLACE;
 IMPORT PLAN CAS9ENFS.TRAN$ENF#[email protected];
 
 DDTRS0016E DBSCALL FAILED SQL COMMAND OPEN , RC: -117.
          SQL ERROR MESSAGE:
 
 END OF PROGRAM - RETURN CODE: 16.
 DDTRS0002E PROGRAM FINISHED WITH ERRORS.

Environment

Release: CA90SV00200-12-Common Services-for z/OS
Component:

Cause

The basic problem here is that the Datacom/AD MUF needs to be active in order for the import job to run. This is evidenced by the OPEN errors.

Resolution

If the plan being imported has a new name, then the AW1IMPRT job can be run while ENF is active. This is generally the case.

Tip: You can determine what plan name ENF is using by browsing load module CAS9DBC for string "TRAN$". Be sure to browse the correct load module that ENF is picking up from STEPLIB or LNKLST.

If the plan being imported is the same name as currently being used, then you will need to shutdown ENF and start the MUF in its own address space.

If you are running ENFXMUF than you will already be running the MUF separately and you only need to stop ENF. Once ENF is shutdown, AW1IMPRT can be run.

If you are running ENFIMUF then this is done by first stopping ENF. You will then use the AD12STRT or AD14STRT job that Datacom/AD provides. [This same process would had been done when Datacom and ENF was initially installed in order to customize the MUF prior to ENF being able to use it] The important thing is that the AD12STRT or AD14STRT job be customized to use all the same Datacom/AD related data sets that your ENFIMUF task uses. This also goes for the parms that the Datacom MUF uses. Once the MUF is active AW1IMPRT can be run. The import job will have the same Datacom CUSLIB and CAAXLOAD data sets that the MUF runs with.