|
Problem IC94508
|
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 / 970 - 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: *
* Windows Users *
****************************************************************
* 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. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 9.7 Fix Pack 9 *
**************************************************************** |
| Local Fix: |
Ensure the DB2DSDRIVER.CFG file contains that database name or
alias that the application connects to. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem first fixed in DB2 UDB Version V9.7 Fix Pack 9 |
| Workaround |
Update the db2dsdriver.cfg to contain correct connection
information for all databases |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC95509 IC97827
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.07.2013
18.12.2013
18.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
