|
Problem IC66977
|
Status: Closed |
SQL30082N ERROR UPON CONNECTION TO A DATABASE ON HP-UX WITH A PASSWORD LONGER THAN 8 CHARACTERS |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
A SQL30082N error with reason code 24 is encountered when
connecting to a database on HP-UX using a password that is
greater than 8 characters in length. On HP-UX, without the
"Trusted System Security", a password that has more than 8
characters is truncated by the OS. Therefore, one can use a
password that is greater than 8 characters, but only the first 8
characters are stored by the OS.
In DB2 V9.7, an OS routine is called which supports a password
greater than 8 characters, but a mismatch occurs since the
stored encrypted password only holds the first 8 characters
while the password being compared is greater than 8 characters. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All HP-UX users *
****************************************************************
* PROBLEM DESCRIPTION: *
* A SQL30082N error with reason code 24 is encountered when *
* connecting to a database on HP-UX using a password that is *
* greater than 8 characters in length. On HP-UX, without the *
* "Trusted System Security", a password that has more than 8 *
* characters is truncated by the OS. Therefore, one can use a *
* password that is greater than 8 characters, but only the *
* first 8 characters are stored by the OS. *
* *
* *
* *
* In DB2 V9.7, an OS routine is called which supports a *
* password greater than 8 characters, but a mismatch occurs *
* since the stored encrypted password only holds the first 8 *
* characters while the password being compared is greater than *
* 8 characters. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.8 FP3. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
User password with less than 8 characters. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.03.2010
12.01.2011
12.01.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.3
|
 |
