IBM Support

IC77108: DB2 .NET DATA PROVIDERS ARE NOT CONFIGURED CORRECTLY WHEN DB2NMPSETUP.EXE IS EXECUTED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • On a windows system where .Net framework (v2 and/or higher) and
    DB2 products are installed, the DB2 .Net Data Providers were not
    configured correctly when the db2nmpsetup.exe tool is executed,
    either by
      1). execute the tool directly, which is under ~\sqllib\bin,
    or
      2), launch it from its shortcut:  Start->Program Files->IBM
    DB2->DB2COPY1->Setup Tools->Configure DB2 .NET Data Provider
    
    What this tool should do is to
     1). Register the DB2 .NET Data Providers with machine.config of
    the .Net Framework, and
     2). Register the DB2 .NET Data Providers with Global Assembly
    Cache (GAC), if it is the default DB2 Client interface copy on
    the system.
    

Local fix

  • The following are options to work-around this problem:
    -  To register DB2 .Net Data Provider with machine.config,
    execute the db2nmpcfg.exe tool;
    -  To register DB2 .Net Data Provider of the default copy with
    GAC, set/reset the default DB2 Client Interface copy, by
    executing the db2swtch.exe command line or via its shortcut:
    Start->Program Files->IBM DB2->DB2COPY1->Setup Tools->Default
    DB2 and Database Client Interface
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 on Windows                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * On a windows system where .Net framework (v2 and/or higher)  *
    * and DB2 products are installed, the DB2 .Net Data Providers  *
    * were not configured correctly when the db2nmpsetup.exe tool  *
    * is executed, either by                                       *
    *   1). execute the tool directly, which is under              *
    * ~\sqllib\bin,   or                                           *
    *   2), launch it from its shortcut:  Start->Program           *
    * Files->IBM DB2->DB2COPY1->Setup Tools->Configure DB2 .NET    *
    * Data Provider                                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * The work-around for this problem:                            *
    * -  To register DB2 .Net Data Provider with machine.config,   *
    * execute the db2nmpcfg.exe tool;                              *
    * -  To register DB2 .Net Data Provider of the default copy    *
    * with GAC, set/reset the default DB2 Client Interface copy,   *
    * by executing the db2swtch.exe command line or via its        *
    * shortcut:                                                    *
    * Start->Program Files->IBM DB2->DB2COPY1->Setup               *
    * Tools->Default DB2 and Database Client Interface             *
    ****************************************************************
    

Problem conclusion

  • This problem will be fixed in V97FP5 release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77108

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-22

  • Closed date

    2011-12-08

  • Last modified date

    2011-12-08

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77108

Modified date: 08 December 2011