DB2 - Problembeschreibung
Problem IC95200 | Status: Geschlossen |
EXEC SQL SET CONNECTION FAILED WITH SQL0843N | |
Produkt: | |
DB2 DATA SRVR D / DB2DSDRVR / A10 - DB2 | |
Problembeschreibung: | |
The SET CONNECTION, sql statement may fail with SQL0843N when the connection is made from IBM DS Driver Client and the following conditions are met. The database alias specified to SET CONNECTION statement is defined in db2dsdriver.cfg. And the values to database alias (dsn alias) and the data base name (name) are different. In the following example of db2dsdriver.cfg, two data source names, PSAMPLE and SAMPLE1 are defined. For the data source, PSAMPLE, this issue may occur because the character strings, "PSAMPLE" and "SAMPLE" are different. But this issue does not occur for the data source, SAMPLE1 because the same value, "SAMPLE1" is used for both the database alias and the database name. An example of db2dsdriver.cfg: <configuration> <dsncollection> <dsn alias="PSAMPLE" name="SAMPLE" host="host.domain.com" port="57531"/> <dsn alias="SAMPLE1" name="SAMPLE1" host="host.domain.com" port="57531"/> </dsn> </dsncollection> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Use using Data Server Driver * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.5 Fix Pack 4. * **************************************************************** | |
Local-Fix: | |
Use same value to the dsn alias and the name parameters. | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 10.5 Fix Pack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95839 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.08.2013 30.06.2014 30.06.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |