Common Problem Analysis and method of DB2 database detachment

DB2 database uninstallationSome problems often occur. The following problems are analyzed and corresponding solutions are provided. If you have encountered similar problems when detaching A DB2 database, you may have learned a lot from it.

(1) run the SETUP program from the original installation disk
If you cannot detach a DB2 database from the Add/delete program on the Windows Control Panel. First, we should try to run the "setup" Program (CD or network drive) from the original installation media ). Make sure that the DB2 products on the installation media (such as ESE, ADMCL, and WSE) and the service level (such as GA, FP2, V82, etc.) are the same as the DB2 products we have installed before running. Windows Installer detects that the product has been installed and provides three options: repair, change, and delete. Select "delete" to uninstall the product.

Another possibility is that Windows Installer will ask the original. msi file location. In this case, locate the original installation location and go to [original installation location] \ db2 \ Windows \ [DB2 product]. msi selects the original. msi file.

(2) Use force uninstall (FORCE_UNINSTALL)
The failure to uninstall DB2 may result from several factors, such as the user modifying the system registry, DB2 UDB file or directory structure. In this case, we must use the force uninstall method.

This method requires the msiexec program to uninstall the DB2 database, and you also need to manually clear some content. You canProcedureTo uninstall the product:

1. Stop the DB2 service. This step can be achieved through the "service" management tool in the Windows Control Panel.

2. Go to the installation directory of Windows Installer (for example, c: \ Windows \ Installer or c: \ WinNT \ Installer) from the command line ).

3. Run the command msiexec/x FORCE_UNINSTALL = Y. If the command cannot be completed successfully, you are not allowed to manually uninstall it. If the operation is successful, proceed with the following steps.

4. Clean up environment variables. Go to the control panel, click "system", click the "advanced" tab, and click the "environment variable" button. Clear all DB2 environment variables.

5. Clean up the registry. Find the Windows Registry Key of "SQLLIB" and clear all the following key values.

6. Clear service files. Delete DB2 entries under [Windows] \ system32 \ drivers \ etc.

7. Clear SQLLIB. Delete the SQLLIB directory.

8. Clear shortcuts. Find the "IBM DB2" shortcut Directory, which is under the "Start" menu/Program "directory under the" All Users "User attribute directory. Delete this directory, delete all DB2 links under the "Start" directory.

It is easy for you to understand these things in depth. I hope this article will help you.