DB2 CONNECT / DB2CONNCT / A10 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL DB2 CLI USERS                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 10.1.4 or later                                   * 
****************************************************************

Ensure the DB2DSDRIVER.CFG file contains that database name or 
alias that the application connects to.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Upgrade to 10.1.4 or later

keiner bekannt / siehe Local-Fix

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

21.11.2013
26.06.2014
26.06.2014