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:
Then, once I ignored it and tried to actually work with DB2, I got these errors:
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:

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

Select “Repair”, and then click next:

On the final screen, click “Install”:

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 Database Administrator
Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 18 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

Leave a Reply

Your email address will not be published.

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