Troubleshoot database exception: "Connection authorization failure occurred. Reason: Password expired. ERRORCODE=-4214, SQLSTATE=28000"

Products

• DSERIES- SERVER
• ESP dSeries Workload Automation - System Agent (dSeries)

Issue/Introduction

The CA Workload Automation DE (dSeries) server is unable to start. You receive the below error message as the server could not connect to the DB2 database

Background:  

This is a DB2 database exception error reported in the CA Workload Automation DE (dSeries) server tracelog file.

20100209 10:25:33.821 [ID:   0] CybEspressoRdbFailOverHandler:  com.ibm.db2.jcc.b.mm: 
   [jcc][t4][2012][11248][3.50.152] Connection authorization failure occurred. 
   Reason: Password expired. ERRORCODE=-4214, SQLSTATE=28000

Environment

IBM DB2 database on supported versions (with the CA Workload Automation DE server installed on AIX and z/Linux only)

Resolution

The error message points to a database connection issue. To resolve the issue, liaise with your Database Administrator (DBA) and check the following;

1. The database is running and connection to the database server is working.
   
   
2. The database user ID and password are valid and functional.

If the database user's password is reported as expired, do either of the following options;

1. Change the password in the DB2 database configuration.
   Change the CA (dSeries) Workload Automation database connection properties using 'setdbparm' utility (the parameter to change is rdbms.password')
   
   
2. Extend the expiration of the database user's password.