|
Problem IC97827
|
Status: Closed |
APPLICATIONS USING THE IBM DATA SERVER DRIVER RECEIVE SQL0902C ERROR IF DATABASE NAME IS NOT IN THE DB2DSDRIVER.CFG FILE. |
| product: |
DB2 CONNECT / DB2CONNCT / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL DB2 CLI USERS *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 10.1.4 or later *
**************************************************************** |
| Local Fix: |
Ensure the DB2DSDRIVER.CFG file contains that database name or
alias that the application connects to. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Upgrade to 10.1.4 or later |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.11.2013
26.06.2014
26.06.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.4
|
 |
