Wednesday, April 1, 2009

Problems installing DB2 on Windows Vista

Installed DB2 Express on Windows Vista (Business 64-bit) yesterday, and hit a bunch of errors at the end of the install.

Specifically:

  • An error occurred while initializing the Profile Registry.

    The return value is "-2079391743". Contact your technical service
    representative.

  • An error occurred while setting the registry key "SOFTWARE\Microsoft
    \MSDTC\XADLL\C:\Program Files\IBM\SQLLIB\BIN\DB2APP.DLL" to "C:
    \Program Files\IBM\SQLLIB\BIN\DB2APP.DLL".

  • One or more errors occurred while committing the changes to the
    user "DB2". Create or make any changes to this user manually.

  • An error occurred while creating the instance "DB2". The return
    code is "-1918". Create the instance manually using the command
    "db2icrt".



So after some research, here is how to fix it:


  • Create DAS user (for example db2admin) via Windows as an Administrator

  • Execute "db2admin CREATE /USER:db2admin /PASSWORD:*password*"

  • Execute "db2admin SETID db2admin"

  • Execute "db2icrt -u db2admin DB2" (where DB2 is the instance name)

  • Set System Environment Variable "DB2INSTANCE" to your instance name

  • Set System Environment Variable "DB2PATH" to "C:\Program Files\IBM\SQLLIB"

  • Reboot your machine

  • Follow http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.qb.server.doc/doc/t0011930.html to add yourself to DB2ADMNS

  • Execute "db2set db2comm=tcpip"

  • Start your DB2 instance