Release Notes for IBM Classic Data Architect version 9.1 Interim Fix 0007

(c) IBM Corporation 2008. All rights reserved.

About this fix

Problem 1: Executing a query failed with a NumberFormatException in the Error Log and a Successful message in Dataoutput view. The error was captured by JVM and not by JDBC driver. If the user does not check the Error Log, they are unaware that a problem occurred and may not realize the result set is incomplete.

Fix: The NumberFormatException is captured at the JDBC driver level, further data processing is stopped and a NumberFormatException is reported in the Dataoutput view so it is immediately apparent to the user that a problem was encountered processing the data.

To be sure you are using the updated driver provided in this fix pack, edit all your existing JDBC connections to point to the new driver.
  1. In the Database Explorer view, right-click the connection and select Edit Connection....
  2. Click Browse, next to the Class location.
  3. Find and select the updated JDBC driver jar file from the following location. The install_dir is the location where you installed Classic Data Architect, such as C:\Program Files\IBM\WSClassic91\CDA\eclipse.
    install_dir\CDA\eclipse\plugins\
com.ibm.datatools.dbdefinition.db2.cac.classic_1.0.5.CDAV91_FP\driver\cacjdbc21.jar
Problem 2: The Adabas wizard failed to map MU and PE fields that were redefined with Predict

Fix: The Adabas wizard was modified to recognize and process redefined MU and PE fields.

Installing the Classic Data Architect interim fix

This fix can be installed with the product updater directly from the update site. However, if the system where the Classic Data Architect is installed does not have Internet access, you can download this interim fix as a zip file and use the product updater to access the update locally.

Prerequisite

Before applying this interim fix, you must apply:

Important Reminder

After installing this interim fix, start Classic Data Architect with the -clean option so that the changes are picked up.

  • Open a DOS window, navigate to install_dir\CDA\eclipse and type eclipse -clean. The install_dir is the location where you installed Classic Data Architect, such as C:\Program Files\IBM\WSClassic91.

Procedure

If you are using the product updater to install directly from the update site, continue with the instructions below. Otherwise, if you want to obtain the update to install from a local drive, download and extract the file from http://download.boulder.ibm.com/ibmdl/pub/software/websphere/cda/91/zips/cdaifix_0007.zip and follow the instructions in the file http://download.boulder.ibm.com/ibmdl/pub/software/websphere/cda/91/html/if0007/install_local_910.html.

  1. Exit Classic Data Architect if it's running.
  2. Log on to your system with the same user account used to install WebSphere® Classic Data Architect.
    Restriction: On Windows operating systems, this account requires Administrator privileges. On Linux® operating systems, you must use the root user account.
    Tip: On Windows Vista operating systems, if you have previously installed the Classic Data Architect and its product updater in the Program Files directory, uninstall Classic Data Architect and the product updater and reinstall them into a folder other than Program Files, such as C:\Program Files\IBM\WSClassic91\CDA\eclipse. If you install the applications in the Program Files directory, you must always select Run as administrator. To install these programs, right-click cdasetup.exe and select Run as administrator.
  3. Start the Classic Data Architect product updater:
    • On Windows Vista operating systems, navigate to Start > All programs > IBM WebSphere Classic V9.1, right-click WebSphere Classic Data Architect Product Updater, and select Run as administrator.
    • On other Windows operating systems, click Start > Programs > IBM WebSphere Classic V9.1 > WebSphere Classic Data Architect Product Updater.
    • On Red Hat Enterprise Linux 3.0 and SuSE Linux Enterprise Server 9.0 (GNOME desktop environment), open the main menu and click Programming > IBM WebSphere Classic Data Architect Product Updater.
    • On SuSE Linux Enterprise Server 9.0 (K Desktop Environment), open the main menu and click Applications > IBM WebSphere Classic Data Architect Product Updater.

    On Linux, if you use a desktop environment other than the default, the product shortcuts might not appear in the default location.

  4. If you have previously installed locally, select Preferences menu and then select Update Sites. Click the Restore Default button before proceeding.
  5. Click Find Updates.
  6. Select the update to apply. By default, all available updates are selected. Ensure that you select the checkbox next to Interim Fix 7 under IBM WebSphere Classic Data Architect. To see a description of the update, highlight it.
  7. Click Install Updates.
  8. Click OK to accept the license agreement.

    Depending on the speed of your computer processor, the amount of RAM, and the speed of your Internet connection, the update might take an extended period of time to download and install.

    After the installation is complete, the Classic Data Architect product updater lists the installed updates on the Installed Products page.

  9. Close the Classic Data Architect Product Updater.
  10. Start Classic Data Architect with the -clean option so that the changes are picked up.
    • Open a DOS window, navigate to install_dir\CDA\eclipse and type eclipse -clean. The install_dir is the location where you installed Classic Data Architect, such as C:\Program Files\IBM\WSClassic91.