Db2 Client Reinstallation

Symptom: When attempting to reinstall Db2 Client, you encounter the error message "Error applying transforms. Verify that the specified transform paths are valid."

Troubleshooting Steps

1. Uninstall Db2 Client:
   1. Navigate to the Db2 Client directory in File Explorer.
   2. Open Command Prompt with administrative privileges.
   3. Run the command db2unins.bat -f to execute the uninstallation script forcibly.
   4. Restart your computer to ensure any lingering processes are terminated.
2. Verify Removal of Db2 Folders:
   1. Navigate to the following directories:
      • C:\Program Files
      • C:\ProgramData
   2. Verify that the folder named "IBM" has been removed from both directories. If it's still present, manually delete it.
3. Remove Registry Entries:
   1. Open the Registry Editor by typing "regedit" in the Start menu search bar and pressing Enter.
   2. Before proceeding, create a backup of the registry by selecting File > Export and saving the backup file in a safe location.
   3. In the Registry Editor, navigate to:
      1. HKEY_CURRENT_USER\SOFTWARE\Microsoft\Installer\Products
      2. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\[SID]\Products
   4. Search for entries related to Db2 Client using the ProductCode (e.g. {E27D4C1E2DC8-4E6E-BD9F-C4EF5E86F07D}) found in the setup.ini file located in "..\CLIENT\image\db2\Windows\CLIENT\setup.ini".
   5. .Delete any registry entries that contain "DB2COPY1".
4. Reinstall Db2 Client:
   1. Navigate to the directory where the Db2 Client setup files are located.
   2. Right-click on the setup.exe file and select "Run as administrator" to launch the installer with elevated privileges.
   3. Follow the on-screen instructions to reinstall Db2 Client.
5. Contact Support:
   1. If you encounter any issues during the reinstallation process, or if the problem persists after following the above steps, please don't hesitate to contact our support team for further assistance.

Oracle Provider configuration

Symptom: Cannot run ssis package or DT can not connect to Oracle DB.

Troubleshooting Steps

1. Download ODAC (Oracle Data Access Components) 12.2 for windows 32 and 64 bit (Do not use Xcopy versions)
   1. ODTwithODAC122011 32 bit
   2. ODAC122011_x64
2. During installation remove checkbox
3. After installation both drivers restart your PC
4. You can check correct installation that
   1. DT able to connect to oracle DB
      
   2. In ssis solution you can use Oracle Provider for OLE DB

How to remove Oracle Provider

Troubleshooting Steps

1. Access Services:
   Press Win + R, type services.msc, and press Enter to open the Services window.
2. Stop Oracle Services:
   Locate the Oracle services (both 32-bit and 64-bit) in the list, and stop them.
3. Delete the Installed Folder:
   Navigate to the installation directory (by default, C:\app\client), and delete the folder.
4. Remove Registry Entries:
   Open the Registry Editor by pressing Win + R, typing regedit, and pressing Enter. Search for OraOLEDB.Oracle throughout the entire registry. Delete all matching entries found under the following paths:
   • HKEY_CLASSES_ROOT
   • HKEY_CLASSES_ROOT\WOW6432Node
5. Remove Oracle ODBC driver:
   Navigate to the following paths in the registry and remove oracle records in the ODBC drivers section
   • Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
   • Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\ODBC Drivers
6. Verify Removal:
   Check that the Oracle database is no longer available for analysis in the discovery tool. This confirms the successful removal of the Oracle provider.

DB2 error with .NET Data Provider

Symptom: Error while trying to connect to DB2 database.

Troubleshooting Steps

1. Refer to section 1 to reinstall DB2 Client and resolve this problem - Db2 Client Reinstallation.