DB2 FOR LUW / DB2FORLUW / 980 - DB2

SQLConnect sets dbname into data source name even if user 
specifies dbalias, this causes SQL0842N or SQL1024N in 
subsequent API calls. 
 
The following scenario would fail if a database has more than 
one alias. 
NOTE: where dbAlias is an alias for dbName. 
 
Case 1: Subsequesnt connection request fails with SQL0842N 
(Already connected) 
 
SQLConnect(hDbc, dbName..); 
SQLConnect(hDbc, dbAlias..); 
 
Case 2: DB2 API (db2CfgGet in this case) reports SQL1024N (No 
connection) 
 
SQLConnect(hDbc, dbAlias..); 
cfgStruct.dbname = dbAlias; 
db2CfgGet(db2Version970, (void *)&cfgStruct, &sqlca);

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use CLI application against a database which has   * 
* more than one database alias(es).                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SQLConnect sets dbname into data source name even if user    * 
* specifies dbalias, this causes SQL0842N or SQL1024N in       * 
* subsequent API calls.                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V9.8 FixPack 5 or later.               * 
****************************************************************

please remove dbalias.

This problem was first fixed in DB2 V9.8 FixPack 5.

keiner bekannt / siehe Local-Fix

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

03.10.2011
19.06.2012
19.06.2012

9.8.FP5