DB2 - Problem description
Problem IC77108 | Status: Closed |
DB2 .NET DATA PROVIDERS ARE NOT CONFIGURED CORRECTLY WHEN DB2NMPSETUP.EXE IS EXECUTED | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
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 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. | |
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 * **************************************************************** | |
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 | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Solution | |
This problem will be fixed in V97FP5 release. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.06.2011 08.12.2011 08.12.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.5 |