IBM Intelligent Decision Server 1.0.2 Sample Database Updates README

This fixpack contains the following documentation and code updates for the Sample Databases supplied with IDS Version 1.0.2.

Should you have any problems applying a fixpack or if you have questions, please contact IBM Software Support at 1-800-992-4777.

Overview

This fixpack corrects Defect 42769: Make IDS Sample DBs available for use in non-English DBMSs.

Three IDS sample databases (coffee, finance and mcdemo) are provided with the IDS version 1.0.2. The IDS samples on the 1.0.2 CD-ROM were created by doing a back-up of the sample databases from a DB2 Database Management System (DBMS). The installation instructions provided with the IDS sample databases direct the user to do a restore using the provided files to re-create the databases. The problem is that both the DBMS where the back-up is done and the DBMS where the restore is done must have the same codepage (national language) setting. The backup was done on a DBMS using the codepage setting 850, 437. The sample databases can't be re-created in DBMSs that use a different codepage setting.

This fixpack provides the tables for each sample database as IXF (Integration eXchange Format, PC version) format files. The IXF files can be imported into a DB2 DBMS that is using any codepage setting.

Applying the fixpack

This fixpack is provided as a self extracting zip file named samples.exe.

To install the fixpack:

  1. Copy the file to a local directory on OS/2.

  2. At the command prompt type samples. The files will unpack into a new subdirectory named samples.

  3. Change to the samples directory. This directory contains an IMPORT.CMD file and three subdirectories: coffee, finance and mcdemo. The subdirectories contain the IXF files.

  4. Create databases in DB2 named COFFEE, FINANCE and MCDEMO.

  5. From the directory containing IMPORT.CMD file, type import. Wait for the system to finish running the import commands.

  6. Go to the subdirectory EXE of your root IDS installation directory, and run the following commands at command prompt:
    7. disbind coffee cs
    disbind finance cs
    disbind mcdemo cs
  7. Test that the files were installed correctly by doing steps 2 to 8 of the instructions for installing each sample database in the original samples READ.ME file on the IDS CD-ROM.

  8. Delete the fixpack files once you have finished the installation.