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

book

Article ID: 195862

calendar_today

Updated On:

Products

CA Data Content Discovery

Issue/Introduction

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

 

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

Environment

Release : 3.0

Component : CA DATA CONTENT DISCOVERY

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.