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

(c) IBM Corporation 2007. All rights reserved.

About this fix

Problem 1: The JDBC driver incorrectly returns SQL code -303 when invoking stored procedures that do not contain output parameters. This problem typically manifests itself when creating a table using the IDMS or Adabas discovery wizards.

Fix: The driver has been modified to correctly handle stored procedure parameters. The fix also requires a corresponding Classic server fix. Apply APAR PK56091 to the Classic server, and apply this interim fix to Classic Data Architect in order to completely resolve the problem.

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.4.CDAV91_FP\driver\cacjdbc21.jar
Problem 2: The IDMS wizard incorrectly transforms schema fields defined with an initial VALUE containing a decimal which results in errors from the COBOL compiler.

Example:

    *+ 05 FACTOR-XYZ
    *+ PICTURE IS 9V9
    *+ USAGE IS DISPLAY
    *+ ELEMENT LENGTH IS 2
    *+ POSITION IS 10
    *+ VALUE IS ( .5 )

Fix: The IDMS parser was modified to recognize the VALUE clause at the field level and to handle it correctly prior to processing the record definition thru the COBOL compiler. Reference Classic Data Archtect APAR PK56174.

Problem 3: The IDMS wizard incorrectly uses a subschema name from the specified schema file instead of the specified subschema file. If the user does not notice and correct the subschema, the resulting DDL may fail if the record and set information in the table definition don't match that of the erroneous subschema.

Fix: The IDMS wizard was modified to use the subschema name specified in the subschema file. Reference Classic Data Architect APAR PK56175.

 

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:

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_0002.zip and follow the instructions in the file http://download.boulder.ibm.com/ibmdl/pub/software/websphere/cda/91/html/if0002/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. Click Find Updates.
  5. Select the update to apply. By default, all available updates are selected. Ensure that you select the checkbox next to Interim Fix 2 under IBM WebSphere Classic Data Architect. To see a description of the update, highlight it.
  6. Click Install Updates.
  7. 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.

  8. Close the Classic Data Architect product updater.
  9. Start Classic Data Architect with the -clean option so that the changes are picked up. For example: eclipse -clean.