DB2 - Problembeschreibung
Problem IC95509 | Status: Geschlossen |
APPLICATIONS USING THE IBM DATA SERVER DRIVER RECEIVE SQL0902C ERROR IF DATABASE NAME IS NOT IN THE DB2DSDRIVER.CFG FILE. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
If the IBM Data Server Driver is the only DB2 image installed on a Windows server,applications may receive a -902 (SQL0902C) if the database the application is connecting to is not in the db2dsdriver.cfg. Normally the application would receive an SQL1013N. This can easily be recreated using the testconn40 sample program. Note in this test the db2dsdriver.cfg can either not exist or simply not contain the database or alias for the database sample for the error to occur. E:\Program Files\IBM\dustin\IBM DATA SERVER DRIVER\bin>testconn40 "database=sample;userid=newton;password=xxxxxxxx" Step 1: Printing version info .NET Framework version: 4.0.30319.269 64-bit DB2 .NET provider version: 9.7.4.4 DB2 .NET file version: 9.7.5.4 Capability bits: ALLDEFINED Build: 20111018 Factory for invariant name IBM.Data.DB2 verified Factory for invariant name IBM.Data.Informix verified IBM.Data.Informix from DbFactory is the Common Informix .NET provider Elapsed: 8.4014805 Step 2: Validating db2dsdriver.cfg against db2dsdriver.xsd schema file C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg against E:\Program F iles\IBM\DB2\IBM DATA SERVER DRIVER\cfg\db2dsdriver.xsd Elapsed: 0.2850163 Step 3: Connecting using "database=sample;userid=newton;password=xxxxxxxx" ERROR [58005] [IBM] SQL0902C A system error (reason code = "") occurred . Subsequent SQL statements cannot be processed. SQLSTATE=58005 If this same program is run, when another DB2 image is installed on the server, then the SQL1013N is reported as expected. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All DB2 CLI Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to v10.5.3 and later * **************************************************************** | |
Local-Fix: | |
Ensure the DB2DSDRIVER.CFG file contains that database name or alias that the application connects to. | |
verfügbare FixPacks: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Lösung | |
Fixed in v10.5.3 and later | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.08.2013 09.09.2014 09.09.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.4 |