IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
1 Post

Pinned topic Installing DB2 on WINDOWS 8 64 BIT - FIX FOR testconn20

‏2012-11-19T16:50:15Z |
Hi All,

This information may be helpful for anyone installing DB2 on Windows 8 64 Bit or those of you get installation error on DB2 with the following errors:

sql1159 initialization error with db2 .net data provider reason code 7

sql1159 initialization error with db2 .net data provider reason code 10

Run as Administrator for all these tasks

*Step 1*Go to Start -> Programs -> Visual Studio -> Developer Command Prompt

Step 2 - on the command prompt windows type the following

gacutil /if "C:\Program Files\IBM\SQLLIB\BIN\netf40\IBM.Data.DB2.dll"
gacutil /if "C:\Program Files\IBM\SQLLIB\BIN\netf40\IBM.Data.DB2.entity.dll"
gacutil /if "C:\Program Files\IBM\SQLLIB\BIN\netf40\IBM.Data.Informix.dll"
gacutil /if "C:\Program Files\IBM\SQLLIB\BIN\netf20\IBM.Data.DB2.dll"
gacutil /if "C:\Program Files\IBM\SQLLIB\BIN\netf20\IBM.Data.Informix.dll"
gacutil /if "C:\Program Files\IBM\SQLLIB\BIN\netf20\IBM.Data.DB2.entity.dll"

Step 3 - Go to windows start -> search and type REGEDIT

Go to HKEY_LOCAL_MACHINE -> SOFTWARE -> IBM -> DB2 -> InstalledCopies
Click on the folder InstalledCopies
Right Click -> New -> String Value
edit to 10.1.0.DEF.2 -> Right Click and Modify -> on Value Data: enter DB2COPY1 (your instance name may be different- this is the default)

Repeat the task for the registry entry

for 10.1.0.DEF.4 ( same as above)

Thank You