RE: JDBC & Passwords

["Murphy, Guy" <murphy@xxxxxxxxxxxxxxxxx>]

        I suspect that the iSeries was sending a "Your password will expire
in 5 days.  Do you want to change it?" message to the JDBC connection.  Of
course the JDBC connection had no way of responding so it hung.


Guy Murphy
murphyfa@xxxxxxxx
UADIS at the University of Illinois
217-333-8670
http://www.heisercoaching.com


-----Original Message-----
From: David Gibbs [mailto:david@xxxxxxxxxxxx]
Sent: Monday, March 17, 2003 9:16 AM
To: java400-l@xxxxxxxxxxxx
Subject: JDBC & Passwords


I just ran into an odd situation ... had a user trying to connect to a V5R1
DB2 via JDBC.  When the program tried to connect, the program just hung.  I
used opsnav to see if there was any connection at all, and found none.  I
saw in QHST that there was a "Signon" attempt, but nothing further.

I looked at the user profile and saw that it's password was scheduled to
expire in 5 days.  I set the PWDEXPITV value on the profile to *NOMAX and
had the user try to reconnect and it worked fine.

So obviously the password expiration had something to do with it ... anyone
know why a pending expiration would cause the database connection to hang?
It's as if the signon server was waiting for the user to decide if they
wanted to change their password or not.

Anyone know if there is a PTF out for this?  I searched the KB and found
nothing.

Thanks!

david


--
David Gibbs
david@xxxxxxxxxxxx