CEMEIVP1 job encounters SQLCODE = -117, SQLSTATE=S4401, DB RETURN CODE = 44(1)

Products

• Compliance Event Manager

Issue/Introduction

CEM's IVP job (CEMEIVP1) encountered the failure: SQLCODE = -117, SQLSTATE=S4401, DB RETURN CODE = 44(1)

Environment

Release : 6.0, Datacom/AD 15.1

Cause

The Datacom PC CALL module DBPCCPR had not been loaded via CAIRIM.

Resolution

The SQLCODE = -117, SQLSTATE=S4401, DB RETURN CODE = 44(1) failure running CEM's IVP job was caused by the Datacom MUF not being able to sign on the userID (running the job) to external security.  This is due to the fact that the Datacom PC CALL module DBPCCPR  did not get loaded in the LPAR where the DBSQLPR job was run.  

Check CAS9 job that runs CAIRIM .  It needs to have the Datacom CAIRIM cards that's in Datacom/AD 15.1 INSTJCL member AXRIM01 ( or check CAAXSAMP member AXRIM01) 

Example: 

PRODUCT(CA DATACOM) VERSION(BD15) INIT(DBCR5PR)                       -  
LOADLIB(highlevel.CAAXLOAD)                                            -  
PARM(PC=PROD,PCC=DBPCCPR)                                                
/*  

Running the AXRIM01 job proved corrective.