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

(c) IBM Corporation 2008. All rights reserved.

About this fix

Problem 1: The Adabas wizard generates arrays with an invalid level of zero. The generated DDL is incorrect.

Symptom: The DDL generated has ENDLEVEL 0 for these arrays and BEGINLEVEL statements are missing.

Fix: The wizard now correctly indicates an array level of 1 or 2.

Repair: You do not need to remove and remap Adabas tables that contain invalid array levels of zero. The generate DDL process will repair the array definitions in the model.

Feature 1: This new feature allows the user to override the default behavior and generate indexes for NU fields. Use this feature only if you know that the NU field always contains data.

Default Behavior: The Adabas wizard does not automatically generate indexes for nullable fields (fields with NU attribute). Queries that search for an empty value by using a WHERE clause against a nullable field (such as WHERE COLUMN_AA='') can yield incorrect results. Classic Federation will use the index, pass it to Adabas to resolve, and retrieve no rows. If no index exists on the column, a table scan is triggered and the result set consists only of rows where the column has no value.

Implementation: The Adabas wizard option page has an additional checkbox where you can override the default behavior and generate indexes for NU fields. The default is to generate no index (unchecked).

Installing the Classic Data Architect interim fix

This fix pack 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_0005.zip and follow the instructions in the file http://download.boulder.ibm.com/ibmdl/pub/software/websphere/cda/91/html/if0005/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 5 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.