db2setup on Windows – Repair Option

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.

Ember Crooks
Ember Crooks

Ember is always curious and thrives on change. She has built internationally recognized expertise in IBM Db2, spent a year working with high-volume MySQL, and is now learning Snowflake. Ember shares both posts about her core skill sets and her journey learning Snowflake.

Ember lives in Denver and work from home

Articles: 557

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.