IBM Support

IC94508: APPLICATIONS USING THE IBM DATA SERVER DRIVER RECEIVE SQL0902C ERROR IF DATABASE NAME IS NOT IN THE DB2DSDRIVER.CFG FILE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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.
    

Local fix

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

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                    *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 UDB Version V9.7 Fix Pack 9
    

Temporary fix

  • Update the db2dsdriver.cfg to contain correct connection
    information for all databases
    

Comments

APAR Information

  • APAR number

    IC94508

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-31

  • Closed date

    2013-12-18

  • Last modified date

    2013-12-18

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC95509 IC97827

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC94508

Modified date: 18 December 2013