DB2 FOR LUW / DB2FORLUW / 970 - DB2

Authentication fails with SQL30082N RC=24  when the login 
credentials are redirected from a file or stdin. The following 
script will generate the error when executed from CLP. 
 
read DATABASE?'Database name : ' 
read USER?'User name : ' 
db2 <<qwertyuioppoiuytrewq 
connect to ${DATABASE} user ${USER} 
select * from syscat.tables 
connect reset 
 
(rodeh@hotelaix5) /home/hotelaix5/rodeh 
$ sh -x db2.sh 
. 
. 
. 
+ read DATABASE?Database name : 
Database name : sample 
+ read USER?User name : 
User name : rodeh 
+ db2 
+ 0<< 
connect to sample user rodeh 
select * from syscat.tables 
connect reset 
 
(c) Copyright IBM Corporation 1993,2007 
Command Line Processor for DB2 Client 9.5.7 
 
You can issue database manager commands and SQL statements from 
the command 
prompt. For example: 
    db2 => connect to sample 
    db2 => bind sample.bnd 
 
For general help, type: ?. 
For command help, type: ? command, where command can be 
the first few keywords of a database manager command. For 
example: 
 ? CATALOG DATABASE for help on the CATALOG DATABASE command 
 ? CATALOG          for help on all of the CATALOG commands. 
 
To exit db2 interactive mode, type QUIT at the command prompt. 
Outside 
interactive mode, all commands must be prefixed with 'db2'. 
To list the current command option settings, type LIST COMMAND 
OPTIONS. 
 
For more detailed help, refer to the Online Reference Manual. 
 
db2 => Enter current password for rodeh: 
SQL30082N  Security processing failed with reason "24" 
("USERNAME AND/OR 
PASSWORD INVALID").  SQLSTATE=08001 
db2 => SQL1024N  A database connection does not exist. 
SQLSTATE=08003 
db2 => SQL1024N  A database connection does not exist. 
SQLSTATE=08003 
db2 => db2 => (rodeh@hotelaix5) /home/hotelaix5/rodeh

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description above.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 fixpack 7                             * 
****************************************************************

Don't use redirection.

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 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Fixed in Version 9.7 Fixpack 7

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

08.06.2012
06.11.2012
06.11.2012

9.7.FP7