-922 Reason 00D31024 With Compliance Event Manager Job CEMMDBCU

Products

• Compliance Event Manager

Issue/Introduction

The CEMMDBCU job is ending with a RC 01 with the following in the job output:

CEM DB CONNECT
 ODBC DEBUG message: Unable to connect to the server
 Õ42505þ {DB2 FOR OS/390}{ODBC DRIVER}
  DSNT408I SQLCODE = -922, ERROR:  AUTHORIZATION FAILURE: CONNECT ERROR. REASON
           00D31024
  DSNT418I SQLSTATE   = 42505 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = xxxxxxxx SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 9  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD    = X'00000009'  X'00000000'  X'00000000'  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
   ERRLOC=5:10:2 (-922)
 Cannot allocate a statement handle.

Environment

Release : 6.0

Component : COMPLIANCE EVENT MANAGER

Resolution

Make sure that the following line is in your member for the CEEVARS DD.

DBSSID=dblocation 

where 'dblocation' is the DB2 Location value for the DB2 subsystem used for CEM. This is used to connect to the DB2 database and the SSID does not work in all cases. The SSID is often the same as the LOCATION, but not always.