DB2 FOR LUW / DB2FORLUW / 950 - 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                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 FP10                              * 
****************************************************************

Don't use redirection.

First fixed in DB2 Version 9.5 FP10

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC84035 IC87287 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

28.11.2011
02.01.2013
02.01.2013

9.5.FP10