         IBM* DB2 Universal Database* (DB2*) Extenders Version 7.1

  ------------------------------------------------------------------------

About the DB2 Extender CD-ROMS

Welcome to the IBM DB2 Universal Database (DB2) Extenders Version 7.1!

The DB2 Extenders extends the capability of DB2 UDB so you can create
applications that import, export, and manage audio, video, image and text
objects in a DB2 database. The DB2 Extenders define distinct data types and
special functions for image, audio, video, and text objects.

The DB2 Extenders are packaged on 2 CD-ROMs. The CD-ROMs contain:

   - The DB2 Image, Audio, Video, and Text Extenders for the following
     platforms:
        o OS/2 (client and server)
        o Windows NT and later (client and server), Windows 95 (client),
          and Windows 98 (client)
        o AIX (client and server)
        o HP-UX (client and server).
        o Solaris Operating Environment (client and server)
   - Files that present installation instructions for each platform. These
     files are named install.txt.
   - DB2 Extenders manuals

The manuals for the DB2 Extenders are available in .html format for online
viewing as well as in Portable Document Format (PDF) format for printing.
Refer to the docread.txt file in the doc/language directory, where language
is a two-character abbreviation for the language (for example, en for
English), for instructions on viewing and printing the manuals.

The install.txt files, docread.txt files, and manuals are available in
several languages.

Getting Started
---------------
The DB2 Extenders are stored in a separate directory for each platform.

   - CD-ROM 1 contains the DB2 Extenders for OS/2 and Windows platforms.
   - CD-ROM 2 contains the DB2 Extenders for UNIX platforms.

The following directories on CD-ROM 1 contain the DB2 Extenders for OS/2
and Windows platforms:

Platform                      Directory Name
  OS/2                          os2
  Windows 95, 98, NT(and
    later)                      winnt95


The following directories in CD-ROM 2 contain the DB2 Extenders for UNIX
platforms:

Platform                      Directory Name
  AIX                           aix
  HP-UX                         hpux
  Solaris Operating
    Environment                 solaris

The following directories in CD-ROM 2 contain the DB2 Extenders support for
DB2 Extended Enterprise Edition on UNIX platforms:

Platform                      Directory Name
  AIX                           aixeee
  Solaris Operating
    Environment                 soleee

Each platform directory is divided into language-specific subdirectories,
where the language-specific version of the install.txt file is stored. The
names of the subdirectories for each language are:
 Directory
 name         Language
   br        Brazilian
   dk        Danish (OS/2 only)
   en        English
   fi        Finnish (OS/2 only)
   fr        French
   de        German
   it        Italian
   jp        Japanese
   kr        Korean
   no        Norwegian (OS/2 only)
   cn        Simplified Chinese
   es        Spanish
   se        Swedish (OS/2 only)
   tw        Traditional Chinese



Installation Instructions
-------------------------
When you are ready to install the DB2 Extenders, first read the
installation instructions.

Installation instructions in different languages are also available in the
install.txt file in the directory for the pertinent platform and language.
For example, if you were installing the extenders on AIX and needed the
instructions in German, you would read the install.txt file in the
db2ext/aix/de directory.

The install.txt file is in ASCII format, and can be displayed or printed
from your workstation.

Mounting CD-ROMs for UNIX-based Systems

Before you can access the CD-ROM on a UNIX-based system to view the
installation instructions, you must first mount the CD-ROM.

   - Mounting CD-ROMs for AIX
     For AIX, mount the CD-ROM as follows:
       1. Insert the CD-ROM into the CD-ROM drive.
       2. Log in as root user.
       3. Type the following on the AIX command line:

                    mkdir /cdrom


          You can use a name other than /cdrom for your directory.
       4. Allocate a CD-ROM file system by typing:

                    smit storage


       5. Select 'File Systems'.
       6. Select 'Add/Change/Show/Delete File Systems'.
       7. Select 'CDROM File Systems'.
       8. Select 'Add a CDROM File Systems'.
       9. Select the device name.
          Note: Device names for CD-ROM file systems must be unique. You
          may need to delete a previously defined CD-ROM file system or
          choose another name for the file system if there is a conflict.
      10. Respond to the prompt for MOUNT POINT by typing:

                    /cdrom


      11. Exit smit.
      12. Mount the CD-ROM file system by typing the following on the AIX
          command line:

                    smit mountfs


      13. Select (or enter) the FILE SYSTEM name.
      14. Select (or enter) the DIRECTORY name: /cdrom
      15. Select (or enter) the TYPE of file system: crdfs.
      16. Set MOUNT as READ-ONLY system to yes.
      17. Logout as root user.

   - Mounting CD-ROMs for HP-UX
     For HP-UX, mount the CD-ROM as follows:
       1. Log in as root user.
       2. Insert the CD-ROM into the CD-ROM drive.
       3. Type the following on the HP-UX command line:

                    mkdir /cdrom
                    /usr/sbin/mount /dev/dsk/c0t2d0 /cdrom


          where /cdrom is the CD-ROM mount directory.

   - Mounting CD-ROMs for the Solaris Operating Environment
     For the Solaris Operating Environment, mount the CD-ROM as follows:
       1. Insert the CD-ROM into the CD-ROM drive.
          If the Volume Manager (vold) is installed, the CD-ROM is
          automatically mounted as:

                    /cdrom/db2_clients


          If Volume Manager is not installed, mount the CD-ROM by typing:

                    mkdir -p /cdrom/db2_clients
                    mount -f ufs -r /dev/dsk/c0t60s2 /cdrom/db2_clients


Viewing the Installation Readme File
------------------------------------
To view the install.txt file, first ensure that the CD-ROM is inserted into
the CD-ROM drive, then:

  1. Change your drive to the CD-ROM drive and change your directory to the
     db2ext directory, and the platform/language directory, where platform
     refers to the operating system and language refers the two-character
     language identifier for the language of your choice.
  2. View or print the install.txt file and follow the installation
     instructions.

DB2 Extenders Documentation

This CD-ROMs contain the following publications:

   - DB2 Universal Database Image, Audio, and Video Extenders
     Administration and Programming
   - DB2 Universal Database Text Extender Administration and Programming

The documents are provided in PDF format for you to print.

DB2 Extenders Notes

The following notes supplement the information in the publication DB2
Universal Database Image, Audio, and Video Extenders Administration and
Programming, and in the publication DB2 Universal Database Text Extender
Administration and Programming. For additional notes, see the install.txt
file.

DB2 Text Extender Notes
-----------------------

Migration
     To migrate a Text Extender Version 6 instance and Text Extender
     Version 6 enabled databases to Version 7 you must follow
     these steps:
       1. Stop Text Extender and DB2 by typing:

                 txstop
                 db2stop

       2. Migrate the instance: 
       
          o UNIX
            with root access type in:
            txiupdt <txinstance> <db2instance>
                    <txinstance>  is the name of the Text Extender V6.1 instance
                    <db2instance> is the name of the DB2 instance
           
            Example: txiupdt db2inst1 db2inst1
            
          o Windows 
            Before you install the Extenders Version 7.1 you must rename the  
            file desmastr.dat in your Text Extender V6.1 instance directory
            to desmastr.sav.   
            After installation of Text Extender V7.1 you must copy file 
            desmastr.sav back to the Text Extender V7.1 instance directory 
            and rename it to desmastr.dat.
          
       3. Start DB2 and Text Extender by typing:

                 db2start
                 txstart

       4. Migrate every Text Extender V6 enabled database by typing:

                 txdbupdt  <database_name>
                    where  <database_name> is the name of your Text Extender
                             Version 6 enabled database

Sample Wizard
     For additional documentation for the Sample Wizard for Indexing and
     Search, please refer to the txwizard.txt readme file. To view the
     readme file for AIX change your directory to "/cdrom/db2ext/aix/en".
     To view the readme file for Windows NT change your directory to
     "<cdrom-drive>:\db2ext\winnt95\en".

Hints
        o Section support
          An attribute section can be specified in the model ini file like
          in the following sample :
          [yourmodel]
          CHANGED = changed , date
          NUMBER  = number , integer
 
        o For databases with CCSID's other than 850 (Windows NT, OS/2) or
          819 (UNIX) the sample command file 'txsample' has to be adapted.
          Change the CCSID value of the enable step for the Ngram indextype
          to your database CCSID
        o If the desdiag.log file shows an error

                 ...Shared Memory Access Failed
  
          - UNIX
            Try to remove pending shared resources using the new command 
            txipclean
            Refer to the Administration and Programming Guide 
            for more information.
          - Windows 
            Stop and start Text Extender. 
           

Current restrictions
        o To run Text Extender in a Windows NT environment requires that the  
          setting for the DB2 service in the Services window of the Control
          Panel is set to a valid administrator userid.
        o For Windows NT, the environment variable DB2INSTANCE must be set
          as system environment variable. If it is not set, the utilities
          txstart, txstatus and txstop cannot be called.
        o STEMMED FORM OF for indextype normalized is only supported for
          US_ENGLISH.
        o The REFINE UDF does not support IS ABOUT or THESAURUS queries as
          a query refinement.
        o CCSID 1208 (UTF8) is not supported for format XML and HTML
        o Masking is not allowed for SOUNDS LIKE.
        o The maximum number of model names in the model definition file is
          50.
        o Stemming is not supported for thesaurus searches on a
          linguistic indextype.
        o Search on a UTF8 database is currently not supported
        o The backslash cannot be used as escape character for CCSID 954 
        o The following formats are not supported:
          AMI, FFT, MSWORD, RFT, RTF, WP5
        o Values for attribute sections for search must be SBCS characters.
        o Sections search is currently limited to SBCS douments. The 
          restriction will be removed with the first fixpack.
        o Running multiple enabling commands on the same table in
          parallel may result in RC 507 shown with db2tx get index status.
          Workaround: Run the enable commands sequentially.
        o For  Windows 2000 the system and user locale must match. 
        o Documentation 
          Chapter Administration commands for the server, TXTHESN command
          For a list of supported CCSID's see chapter Thesaurus concepts, 
          Creating an Ngram thesaurus.     
     

Known problems
        o HP-UX: The C-language API cannot be used.
             
DB2 Image, Audio, and Video Extenders Notes

none

  ------------------------------------------------------------------------

(C) Copyright International Business Machines Corporation, 2000. All rights
reserved.
Note to U.S. Government Users -- Documentation related to restricted rights
-- Use, duplication or disclosure is subject to restrictions set forth in
   GSA ADP Schedule Contract with IBM Corp.
* are trademarks or registered trademarks of IBM Corporation.
** are trademarks or registered trademarks of their respective owners.
