Topic
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.
2 replies Latest Post - ‏2012-11-29T21:20:57Z by bpgross
gemchacko
gemchacko
12 Posts
ACCEPTED ANSWER

Pinned topic Installing DB2 ON WINDOWS 8 PROFESSIONAL - Answer

‏2012-11-18T18:00:49Z |
Hi All,

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

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

or

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.Informix.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\netf40\IBM.Data.DB2.entity.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 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: Field 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
Geminis
Updated on 2012-11-29T21:20:57Z at 2012-11-29T21:20:57Z by bpgross
  • gemchacko
    gemchacko
    12 Posts
    ACCEPTED ANSWER

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

    ‏2012-11-18T18:27:16Z  in response to gemchacko
    Please use the same task as above.

    Thank You
    Geminis
    • bpgross
      bpgross
      627 Posts
      ACCEPTED ANSWER

      Re: Sql1159 initialization error with db2 .net data provider reason code 7

      ‏2012-11-29T21:20:57Z  in response to gemchacko
      In addition to the information in this append, please see the technote we just published:

      http://www-01.ibm.com/support/docview.wss?uid=swg21618434

      Thanks,

      Brent.