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.

Ember is always curious and thrives on change. She has built internationally recognized expertise in IBM Db2, and is now pivoting to focus on learning MySQL. Ember shares both posts about her core skill set and her journey learning MySQL. 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.