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.
Release : 6.0
Component : COMPLIANCE EVENT MANAGER
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.