Hello,

I'm developing a java program to access IBM DB2 for Z/OS. I want to
detect any of these situations:
- Password expired
- Password soon to expire
But I'm having problems with both of them

In the password expired scenario when I try to connect I receive a SQL
exception  stating that the password is expired (so far so good). My
problem is that I don't know how programatically detect the origin of
the problem as the SQLState and the ErrorCode fields are set to null/0.

In the password soon to expire scenario when I connect to the database
I do not receive any exception (I do not expect one) or warning. As a
result I do not know how I can detect this situation.

Product versions:
- IBM DB2 for Z/OS v.7.1. The EXTENDED_SECURITY parameter is set to YES
in order to use RACF authentication
- DB2 Connect v.8 Enterprise Edition
- Rational Application Developer v.6.0 including the WebSphere v.5.1
Test environment
- DB2 type 4 Jdbc driver

I am getting the connection from my WAS test environment data source.

My questions are:
- Do you know if this situation is related to an error in a
configuration parameter in my connection, WAS, DB2 or DB2 Connect?
- Do you have any suggestion about how to detect any of the described
situations or any hint about where to look for a solution (I've been
surfing the web for an answer to any of these point without any
success)?
- Do you have any easy solution that can make me fell ebarrassed and
think how stupid I am?

Any help is wellcome.

Please let me know if you need any clarification about any of these
topics or if this is not the right forum to ask them.

Thanks in advance

Lluis