|
Problem IC65131
|
Status: Closed |
SQL30082N ERROR UPON CONNECTION TO A DATABASE ON HP-UX WITH A PASSWORD LONGER THAN 8 CHARACTERS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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: *
* Users on HP-UX *
****************************************************************
* PROBLEM DESCRIPTION: *
* A SQL30082N error with reason code 24 is encountered *
* whenconnecting to a database on HP-UX using a password that *
* isgreater than 8 characters in length. On HP-UX, without *
* the"Trusted System Security", a password that has more than *
* 8characters is truncated by the OS. Therefore, one can use *
* apassword that is greater than 8 characters, but only *
* thefirst 8 characters are stored by the OS.In DB2 V9.7, an *
* OS routine is called which supports apassword greater than 8 *
* characters, but a mismatch occurssince the stored encrypted *
* password only holds the first 8characters while the password *
* being compared is greater than8 characters. *
****************************************************************
* RECOMMENDATION: *
* None *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fixed in DB2 v9.7 FP2. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC66977
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.12.2009
31.05.2010
31.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
