The invocation of DCD's DCDCONTL task encounters the 'User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000)'

Products

• Data Content Discovery

Issue/Introduction

Upon DCD's DCDCONTL stc startup, the error: 'User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000)' is encountered.

 

Environment

Release : 3.0

Component : CA DATA CONTENT DISCOVERY

Cause

This type of error condition is normally caused by a mismatch in the DB2 admin UID/PW defined on the LPAR the DB2 subsystem is running on, and the values stated in the highlevel.runtime.CFEYJCL(FEYDCEKP) member

Resolution

This type of error condition is normally caused by a mismatch in the DB2 admin UID/PW defined on the LPAR the DB2 subsystem is running on, and the values stated in the highlevel.runtime.CFEYJCL(FEYDCEKP) member
---
Additional notes:
In the CFEYJCL(FEYACF) job, the commands used to create the lid for DB2 connections, using DCDADM and DCDADMXX for the example:


SET LID
INSERT DCDADM NAME('CADCD DB USER') -
PASSWORD(DCDADMXX) NOPSWD-EXP

In CFEYJCL(FEYDCEKP) here is the input using the exact same lid and password used in the ACF commands. And this example uses the default DCDCONTL donor id. Uncomment the FORCE or REPLACE as it applies to the situation:

DCEKEY_DONOR_USERID=DCDCONTL
DB_CONNECT_USERID=DCDADM
DB_CONNECT_PASSWORD=DCDADMXX
*FORCE /* Uncomment when setting values for first time */
*REPLACE /* Uncomment when replacing an existing CA-DCD dcekey */

Finally, in CFEYOPTN(FEYSQLIG), using the same exact lid DCDADM, all GRANT statements should specify a userid of DCDADM.