Trying to run CA-ENF AW1IMPRT job to update the Datacom/AD MUF. Receiving a SQL -117 error.

book

Article ID: 17399

calendar_today

Updated On:

Products

CA Compress Data Compression for MVS CA Compress Data Compression for Fujitsu CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware CA Datacom/AD

Issue/Introduction

Problem:

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 submiited 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.

 

Resolution:

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.

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.

Environment

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