DB2 - Problembeschreibung
Problem IC80030 | Status: Geschlossen |
AUTHENTICATION FAILS WITH SQL30082N RC=24 WHEN THE LOGIN CREDENTIALS ARE REDIRECTED FROM A FILE OR STDIN | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 FP10 * **************************************************************** | |
Local-Fix: | |
Don't use redirection. | |
Lösung | |
First fixed in DB2 Version 9.5 FP10 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84035 IC87287 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 28.11.2011 02.01.2013 02.01.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP10 | |
Problem behoben lt. FixList in der Version | |
9.5.0.10 |