How to troubleshoot database exception? Connection authorization failure occurred. Reason: Password expired. ERRORCODE=-4214, SQLSTATE=28000.

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

The CA Workload Automation DE (dSeries) server could not be started due to the 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

Release: DSWAHA01300-12-Workload Automation DE-High Availability
Component:

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 database connection issue. To resolve the issue, please 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. a) Change the password in the DB2 database configuration.
   
   b) 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.

Additional Information:

Configuring the Database Connection