|
Problem IC84035
|
Status: Closed |
AUTHENTICATION FAILS WITH SQL30082N RC=24 WHEN THE LOGIN CREDENTIALS ARE REDIRECTED FROM A FILE OR STDIN |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.7 fixpack 7 *
**************************************************************** |
| Local Fix: |
Don't use redirection. |
| available fix packs: |
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
|
| Solution |
Fixed in Version 9.7 Fixpack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.06.2012
06.11.2012
06.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
