db2setup on Windows – Repair Option

Posted by

Sometimes with DB2 on Windows installs just don’t go right. There is a repair mode on db2setup that can help.

The Problems

There are a number of problems that can manifest. One is a completely successful install on Windows, but the menu items just don’t show up under “all programs” on the start menu.

Today, I received this error message when installing DB2 11.1 on my Windows 10 laptop:
Install_error_win
Then, once I ignored it and tried to actually work with DB2, I got these errors:
Install_error_win_2
I had run commands that should have set DB2INSTANCE already, so it wasn’t just a profile problem. While db2val completed successfully, I still chose to do a repair option.

Invoking a Repair

To invoke a repair, run db2setup.exe again, choose install a product, and work with existing:
db2setup_repair_1

Select your DB2 Copy, and then click “Launch DB2 Setup wizard”
db2setup_repair_2

Select “Repair”, and then click next:
db2setup_repair_3

On the final screen, click “Install”:
db2setup_repair_4

Generally I’ve noticed that a repair operation will often require a reboot, even if the original install did not. Also, note that this kind of action would require the instance to be down if you performed on a system where DB2 actually worked.

Lead Db2 Database Engineer and Service Delivery Manager , XTIVIA
Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 17 years developing a top-level expertise on Db2 for mid-range servers and more than 7 years blogging about it, Ember is hungry for new challenges and looks to expand her skill set to the Data Engineering role for Data Science. With in-depth SQL and RDBMS knowledge, Ember shares both posts about her core skill set and her journey into Data Science. Ember lives in Denver and work from home for XTIVIA, leading a team of Db2 DBAs.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.