IBM Intelligent Decision Server 1.0.2 Sample Database Updates
 
Overview
 
This fixpack contains the following documentation and code updates for the
Sample Databases supplied with IDS Version 1.0.2:
 
   Abstract: 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
   back-up was done on a DBMS using the codepage setting '850,437'.
   The sample databases can't be re-created in DBMS's that use a
   different codepage setting.
 
   This fix 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.
   Copy the file to a local directory on OS/2, and execute the command
   'samples' to unpack the file.  After you have unpacked the file, you should
   see a new subdirectory, 'samples'.  Change directory to samples, and you
   should see a file 'import.cmd' and three subdirectories - coffee, finance
   and mcdemo.  The subdirectories contain the IXF files.
 
   Follow these steps to install the fixpack:
 
     1. Create databases in DB2 called COFFEE, FINANCE and MCDEMO
     2. From the directory containing import.cmd, type 'import' and press the
         enter key to run the command file
     3. Wait for the system to finish running the import commands
     4. Go to the subdirectory EXE of your root IDS installation directory, and
         run the following commands at command prompt:
         disbind coffee cs
         disbind finance cs
         disbind mcdemo cs
     5. 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.
 
   You can delete the fixpack files once you have finished the installation.