SQL -117 error DDTRS0016E trying to run ENF AW1IMPRT job

Products

• COMMON SERVICES FOR Z/OS
• DATACOM - AD

Issue/Introduction

Installing a new release of 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.

Customized and submitted job AW1IMPRT from the CAW0JCL library but the job fails.

The JESMSGLG shows the following messages…

 +DB00121I - UNAVAILABLE - CAENFMUF
 +DB00122I - ACCESS TYPE - LOCAL    TASKS=1
 +DB00123I - WAITING FOR MUF AVAILABILITY
 +DB00124W - REMAINING DELAY68 TIME -    2 MINUTES
 +DB00124W - REMAINING DELAY68 TIME -    1 MINUTES
 +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#14@1;
 
 DDTRS0016E DBSCALL FAILED SQL COMMAND OPEN , RC: -117.
          SQL ERROR MESSAGE:
 
 END OF PROGRAM - RETURN CODE: 16.
 DDTRS0002E PROGRAM FINISHED WITH ERRORS.

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.