Troubleshooting
Problem
If you install or upgrade the .NET Framework after installing DB2, how do you register the DB2 .NET provider?
Symptom
DB2 .NET Provider does not appear in the .NET Assembly
Cause
The DB2 installation process will register the DB2 .NET provider, but only if a .NET Framework is already installed.
Resolving The Problem
Use the 'db2nmpsetup' command to register the .NET Provider. Open a DB2 Command Window
and execute
db2nmpsetup -l c:\db2nmpsetup.log
Review c:\db2nmpsetup.log. The end of the log will look similar to this:
- The db2 install path is: "C:\Program Files\IBM\SQLLIB"
To register Data Provider into machine.config. The command line is:
"C:\Program Files\IBM\SQLLIB\BIN\db2nmpcfg.exe" -register -level 9.5.3 -db2path "C:\Program Files\IBM\SQLLIB" -migratev8 -migrateids
Return code from db2nmpcfg.exe is: 0
Data Provider is registered to machine.config successfully.
To register Data Provider into SSRS. The command line is:
"C:\Program Files\IBM\SQLLIB\BIN\db2nmpcfg.exe" -reportserver_register
Return code from db2nmpcfg.exe is: 0
Data Provider is registered to SSRS successfully.
You can check the Assembly (C:\Windows\Assembly) and verify that both of the following exist:
IBM.Data.DB2 9.0.0.1 (for .NET Framework 1.0)
IBM.Data.DB2 9.0.0.2 (for .NET Framework 2.0 and higher)
'db2nmpsetup' is also executed by 'Configure DB2 .NET Data Provider' from Start -> Programs -> IBM DB2 -> DB2COPY1 -> Set-up Tools. This does not generate a log file, however.
In db2 v9.5 and 9.7, the db2nmpsetup command is deprecated. The db2lswtch command should be used instead. Open a DB2 Command Window and execute
db2lswtch -client -promote
and check the Assembly to verify that the IBM DB2 .NET Providers are now registered.
Related Information
Historical Number
44307;370;000
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21429586