IBM(R) DB2 Universal Database(TM) Installation Notes

IBM(R) DB2 Universal Database(TM) Installation Notes

Contents

About this document

Memory Requirements for DB2 Version 8 using the Control Center and other graphical tools

Installation Prerequisites: DB2 Personal Edition

  • Disk requirements for DB2 Personal Edition (Linux)
  • Memory requirements for DB2 Personal Edition (Linux)
  • Installation requirements for DB2 Personal Edition (Linux)
  • Installation Prerequisites: DB2 Workgroup Server Edition and non-partitioned DB2 Enterprise Server Edition

  • Disk requirements for DB2 servers (UNIX)
  • Memory requirements for servers (UNIX)
  • Installation requirements for DB2 servers (AIX)
  • Installation requirements for DB2 servers (HP-UX)
  • Installation requirements for DB2 servers (Linux)
  • Installation requirements for DB2 servers (Solaris)
  • Installation Prerequisites: partitioned DB2 Enterprise Server Edition

  • Disk requirements for a partitioned DB2 server (UNIX)
  • Memory requirements for partitioned DB2 servers (UNIX)
  • Installation requirements for partitioned DB2 servers (AIX)
  • Installation requirements for partitioned DB2 servers (HP-UX)
  • Installation requirements for partitioned DB2 servers (Linux)
  • Installation requirements for partitioned DB2 servers (Solaris Operating Environment)
  • Installation Prerequisites: DB2 Connect Personal Edition

  • Disk requirements for DB2 Connect Personal Edition (Linux)
  • Memory requirements for DB2 Connect Personal Edition (Linux)
  • Installation requirements for DB2 Connect Personal Edition (Linux)
  • Installation Prerequisites: DB2 Connect Enterprise Edition

  • AIX
  • Disk requirements for DB2 Connect Enterprise Edition (AIX)
  • Memory requirements for DB2 Connect Enterprise Edition (AIX)
  • Installation requirements for DB2 Connect Enterprise Edition (AIX)
  • HP-UX
  • Disk requirements for DB2 Connect Enterprise Edition (HP-UX)
  • Memory requirements for DB2 Connect Enterprise Edition (HP-UX)
  • Installation requirements for DB2 Connect Enterprise Edition (HP-UX)
  • Linux
  • Disk requirements for DB2 Connect Enterprise Edition (Linux)
  • Memory requirements for DB2 Connect Enterprise Edition (Linux)
  • Installation requirements for DB2 Connect Enterprise Edition (Linux)
  • Solaris
  • Disk requirements for DB2 Connect Enterprise Edition (Solaris)
  • Memory requirements for DB2 Connect Enterprise Edition (Solaris)
  • Installation requirements for DB2 Connect Enterprise Edition (Solaris)
  • Installation Prerequisites: DB2 Clients

  • Disk requirements for DB2 clients
  • Memory requirements for DB2 clients
  • Installation requirements for DB2 clients (AIX)
  • Installation requirements for DB2 clients (HP-UX)
  • Installation requirements for DB2 clients (Linux)
  • Installation requirements for DB2 clients (Solaris)
  • IBM Distributed Debugger for Java Stored Procedures (v9.2.3) CD

  • DB2 Server Configuration
  • IBM(R) DB2 Universal Database(TM) Installation Notes for UNIX - Version 8

  • Installing DB2 from compressed images on AIX 5L and the Solaris Operating Environment
  • DB2 HTML Documentation CD installation must follow DB2 Product installation
  • DB2 HTML Documentation CD installation must follow DB2 Product installation
  • Availability of Asian fonts for Linux
  • Prerequisites for DB2 Version 8 Clients connecting to DB2 for z/VM and VM/VSE, DB2 for eServer iSeries and AS/400, and DB2 for z/OS and OS/390
  • Migrating the Information Catalog database during Warehouse Manager installation
  • Configuring the Development Center to use JDKs that are not installed or configured by DB2
  • DB2 for UNIX and Windows Version 7.2 federated databases
  • Post Installation step for DB2 Version 8 Spatial Extender on the Solaris Operating Environment
  • DB2 Information Center installation prerequisite
  • Notices

  • Trademarks

  • About this document

    Copyright International Business Machines Corporation 1993-2002. All rights reserved.

    Welcome to the Installation Prerequisites and Installation Notes for IBM DB2 Universal Database for UNIX operating systems.

    This document covers DB2 Universal Database servers and clients and related DB2 products including DB2 Connect.

    DB2* products are available for the following UNIX** platforms: AIX*, HP-UX** Version 11i(11.11) for PA-RISC 2, Linux, Linux on S/390, and the Solaris** Operating Environment.

    DB2 Connect products are available for the following UNIX platforms: AIX, HP-UX** Version 11i(11.11) for PA-RISC 2, Linux, Linux on S/390, and the Solaris Operating Environment.

    For detailed installation instructions and other information, refer to the Quick Beginnings book for your product. The Quick Beginnings books are included in the product box, and are also available in an HTML version on the product CD.

    This file contains information about installing DB2 that became available after the DB2 books were completed. Please read this prior to installing DB2. It is also recommended that you consult the Release Notes for any other late-breaking information that might not appear in the manuals. You should:

    1. Verify that your environment meets the Disk, Memory and Installation requirements for the platform and DB2 product you are installing.
    2. Review the Installation Notes for last minute information about performing the installation.

    Memory Requirements for DB2 Version 8 using the Control Center and other graphical tools

    To run DB2 Version 8 using the graphical tools including the DB2 Control Center, you require a minimum of 192 MB of memory (RAM) on your computer. However, for optimum performance, 256 MB of memory is recommended.

    When determining memory requirements, be aware of the following:


    Installation Prerequisites: DB2 Personal Edition


    Disk requirements for DB2 Personal Edition (Linux)

    The disk space required for DB2 Personal Edition depends on the type of installation you choose and the type of disk drive you are installing on.You may require significantly more space on FAT drives with large cluster sizes.

    When you install DB2 Personal Edition using the DB2 Setup wizard, size estimates are dynamically provided by the installation program based on installation type and component selection.

    The DB2 Setup wizard provides typical, compact, and custom installation types.

    Typical installation
    DB2 Personal Edition is installed with most features and functionality, using a typical configuration. Typical installation includes graphical tools such as the Control Center and Configuration Assistant. You can also choose to install a typical set of data warehousing features.

    Compact installation
    Only the basic DB2 Personal Edition features and functions are installed. Compact installation does not include graphical tools or federated access to IBM data sources.

    Custom installation
    A custom installation allows you to select the features you want to install.

    The DB2 Setup wizard will provide a disk space estimate for the installation options you select.

    Remember to include disk space allowance for required software, communication products, and documentation. In DB2 version 8, HTML and PDF documentation is provided on separate CD-ROMs.

    Handling Insufficient Space

    If the space required to install selected components exceeds the space found in the path you specify for installing the components, the setup program issues a warning about the insufficient space. You can continue with the installation. However, if the space for the files being installed is in fact insufficient, the DB2 installation will stop when there is no more space, and will roll back without manual intervention.


    Memory requirements for DB2 Personal Edition (Linux)

    The following table provides recommended memory requirements for DB2 Personal Edition installed with and without graphical tools. There are a number of graphical tools you can install including the Control Center and the Configuration Assistant.

    Table 1. Memory requirements for DB2 Personal Edition

    Type of installation Recommended memory (RAM)
    DB2 Personal Edition without graphical tools 64 MB
    DB2 Personal Edition with graphical tools 128 MB

    When determining memory requirements, be aware of the following:


    Installation requirements for DB2 Personal Edition (Linux)

    To install a DB2 Personal Edition, the following hardware, operating system, software, and communications requirements must be met:

    Hardware requirements
    Intel 32-bit and 64-bit architecture is supported.

    Distribution requirements

    For the latest information on supported distribution and kernel levels, point your browser to http://www.ibm.com/db2/linux/validate

    The IBM Developer Kit for Java 1.3.1 Service Release 1 is required for DB2 servers, for using the DB2 Control Center, and for creating and running Java applications, including stored procedures and user-defined functions. During the installation process, if the correct level of the JDK is not already installed, it will be installed.

    A browser is required to view online help.

    Communication requirements
    For accessing remote databases, TCP/IP is required.

    Installation Prerequisites: DB2 Workgroup Server Edition and non-partitioned DB2 Enterprise Server Edition


    Disk requirements for DB2 servers (UNIX)

    The disk space required for DB2 Enterprise Server Edition or Workgroup Server Edition depends on the type of installation you choose.When you install DB2 Enterprise Server Edition or Workgroup Server Edition using the DB2 Setup wizard, size estimates are dynamically provided by the installation program based on installation type and component selection.

    The DB2 Setup wizard provides typical, compact, and custom installation types.

    Typical installation
    DB2 is installed with most features and functionality, using a typical configuration. Typical installation includes graphical tools such as the Control Center and Configuration Assistant. You can also choose to install a typical set of data warehousing features.

    Compact installation
    Only the basic DB2 features and functions are installed. Compact installation does not include graphical tools or federated access to IBM data sources.

    Custom installation
    A custom installation allows you to select the features you want to install.

    The DB2 Setup wizard will provide a disk space estimate for the installation options you select.

    Remember to include disk space allowance for required software, communication products, and documentation. In DB2 version 8, HTML and PDF documentation is provided on separate CD-ROMs.

    Handling Insufficient Space

    If the space required to install selected components exceeds the space found in the path you specify for installing the components, the setup program issues a warning about the insufficient space. You can continue with the installation. However, if the space for the files being installed is in fact insufficient, the DB2 installation will stop when there is no more space. At this time, you will have to manually stop the setup program if you cannot free up space.


    Memory requirements for servers (UNIX)

    At a minimum, DB2 requires 256 MB of RAM. Additional memory may be required.

    When determining memory requirements, be aware of the following:


    Installation requirements for DB2 servers (AIX)

    This topic lists the hardware, operating system, software, and communications requirements for DB2 Enterprise Server Edition and DB2 Workgroup Server Edition.

    Hardware requirements
    One of:

    Operating system requirements

    DB2 Enterprise Server Edition is available on:

    DB2 Workgroup Server Edition is available on:

    Note:
    You can query your system to see if a particular APAR is installed with the instfix -v -i -k <APAR> command. For example, instfix -v -i -k IY31254.

    The following AIX file sets are required to install or run DB2 in languages other than English:

    AIX filesets can be downloaded from: http://techsupport.services.ibm.com/server/fixes

    Software requirements

    Communication requirements
    You can use APPC, TCP/IP or MPTN (APPC over TCP/IP). DB2 Version 8 servers, using the DB2 Connect server support feature, support only outbound client APPC requests; there is no support for inbound client APPC requests. You can only use TCP/IP to remotely administer databases.

    Installing DB2 products or sharing instance directory on NFS
    Currently, we do not support the installation of DB2 products on NFS. Installing DB2 on NFS (for example, NFS mounting /usr/opt/db2_08_01 or /opt/IBM/db2/V8.1) can be error prone and these errors can be difficult to diagnose.

    The following configuration is not supported:

    This configuration can cause file locking and performance problems.


    Installation requirements for DB2 servers (HP-UX)

    This topic lists hardware, operating system, software and communication requirements for DB2 servers (HP-UX).

    Hardware requirements
    HP 9000 series 700 or 800 system

    Operating system requirements
    DB2 Workgroup Server Edition and DB2 Enterprise Server Edition can run on HP-UX 11i (11.11) for PA-RISC 2 with:

    Software requirements

    Communication requirements
    APPC or TCP/IP. You can only use TCP/IP to remotely administer databases.

    DB2 Version 8 servers, using the DB2 Connect server support feature, support only outbound client APPC requests; there is no support for inbound client APPC requests.

    DB2 Version 8 HP-UX 64-bit servers do not support running DB2 Version 7 64-bit local applications.

    Installing DB2 products or sharing instance directory on NFS
    Currently, we do not support the installation of DB2 products on NFS. Installing DB2 on NFS (for example, NFS mounting /usr/opt/db2_08_01 or /opt/IBM/db2/V8.1) can be error prone and these errors can be difficult to diagnose.

    The following configuration is not supported:

    This configuration can cause file locking and performance problems.


    Installation requirements for DB2 servers (Linux)

    This topic lists the hardware, distribution, software, and communication requirements for DB2 Enterprise Server Edition and Workgroup Server Edition (Linux).

    Hardware requirements

    DB2 Workgroup Server Edition is supported on Intel 32-bit machines.

    DB2 Enterprise Server Edition is supported on:

    Distribution requirements
    For the latest information on supported distribution and kernel levels, point your browser to http://www.ibm.com/db2/linux/validate

    Software requirements

    Communication requirements
    TCP/IP is required to access remote databases.

    Installing DB2 products or sharing instance directory on NFS
    Currently, we do not support the installation of DB2 products on NFS. Installing DB2 on NFS (for example, NFS mounting /usr/opt/db2_08_01 or /opt/IBM/db2/V8.1) can be error prone and these errors can be difficult to diagnose.

    The following configuration is not supported:

    This configuration can cause file locking and performance problems.


    Installation requirements for DB2 servers (Solaris)

    This topic list the hardware, operating system, software, and communication requirements for DB2 Enterprise Server Edition or Workgroup Server Edition (Solaris Operating Environment).

    Hardware requirements
    Solaris UltraSPARC-based computer

    Operating system requirements

    DB2 Workgroup Server Edition is supported on the following Solaris Operating Environment versions:

    DB2 Enterprise Server Edition is supported on the following Solaris Operating Environment versions:

    "Recommended & Security Patches" can be obtained from the http://sunsolve.sun.com Web site.

    The SUNWlibC software is required to install DB2 on Solaris.

    For DB2 on 64-bit Fujitsu PRIMEPOWER systems, you also require the following:

    Software requirements

    Communication requirements
    APPC or TCP/IP. DB2 Version 8 servers, using the DB2 Connect server support feature, support only outbound APPC client requests; there is no support for inbound APPC client requests. You can only use TCP/IP to remotely administer databases.

    Installing DB2 products or sharing instance directory on NFS
    Currently, we do not support the installation of DB2 products on NFS. Installing DB2 on NFS (for example, NFS mounting /usr/opt/db2_08_01 or /opt/IBM/db2/V8.1) can be error prone and these errors can be difficult to diagnose.

    The following configuration is not supported:

    This configuration can cause file locking and performance problems.


    Installation Prerequisites: partitioned DB2 Enterprise Server Edition


    Disk requirements for a partitioned DB2 server (UNIX)

    Disk requirements vary depending on your file system and the type of installation you perform. When you install DB2 Enterprise Server Edition using the DB2 Setup wizard, size estimates are dynamically provided by the installation program based on installation type and component selection.

    The DB2 Setup wizard provides typical, data warehouse typical, satellite typical, compact, and custom installation types.

    Typical installation
    DB2 is installed with most features and functionality, using a typical configuration. Includes graphical tools such as the Control Center and Configuration Assistant.

    Compact installation
    Only the basic DB2 features and functions are installed. Does not include graphical tools or federated access to IBM data sources.

    Custom installation
    A custom installation allows you to select the features you want to install.

    Remember to include disk space allowance for required software, communication products, and documentation. For DB2 version 8, documentation is provided on separate CD-ROMs.


    Memory requirements for partitioned DB2 servers (UNIX)

    At a minimum, DB2 requires 256 MB of RAM. Additional memory may be required. In a partitioned database environment, the amount of memory required for each database partition server depends heavily on your configuration.

    When determining memory requirements, be aware of the following:


    Installation requirements for partitioned DB2 servers (AIX)

    This topic lists hardware, operating system, software and communication requirements for a partitioned DB2 server (AIX).

    Hardware requirements
    DB2 supports the following hardware:

    Operating system requirements

    DB2 Enterprise Server Edition is available on:

    The following AIX file sets are required to install or run DB2 in languages other than English:

    AIX file sets can be downloaded from: http://techsupport.services.ibm.com/server/fixes

    Software requirements

    Communication requirements
    You can use APPC, TCP/IP or MPTN (APPC over TCP/IP). To remotely administer a Version 8 DB2 database, you must connect using TCP/IP. DB2 Version 8 servers, using the DB2 Connect server support feature, support only outbound client APPC requests; there is no support for inbound client APPC requests.

    DB2 Administration Server (DAS) requirements
    The following requirements must be met:

    Installing DB2 products or sharing instance directory on NFS
    Currently, we do not support the installation of DB2 products on NFS. Installing DB2 on NFS (for example, NFS mounting /usr/opt/db2_08_01 or /opt/IBM/db2/V8.1) can be error prone and these errors can be difficult to diagnose.

    The following configuration is not supported:

    This configuration can cause file locking and performance problems.


    Installation requirements for partitioned DB2 servers (HP-UX)

    This topic lists hardware, operating system, software and communication requirements for a partitioned DB2 server (HP-UX).

    Hardware requirements
    HP 9000 series 700 or 800 system

    Operating system requirements

    DB2 Enterprise Server Edition can run on HP-UX 11i (11.11) for PA-RISC 2 with:

    Software requirements

    Communication requirements
    APPC or TCP/IP. You can only use TCP/IP to remotely administer databases.

    DB2 Version 8 servers, with DB2 Connect server support, only support outbound client APPC requests; there is no support for inbound client APPC requests.

    DB2 Version 8 HP-UX 64-bit servers do not support running DB2 Version 7 64-bit local applications.

    DB2 Administration Server (DAS) requirements
    The following requirements must be met:

    Installing DB2 products or sharing instance directory on NFS
    Currently, we do not support the installation of DB2 products on NFS. Installing DB2 on NFS (for example, NFS mounting /usr/opt/db2_08_01 or /opt/IBM/db2/V8.1) can be error prone and these errors can be difficult to diagnose.

    The following configuration is not supported:

    This configuration can cause file locking and performance problems.


    Installation requirements for partitioned DB2 servers (Linux)

    This topic lists hardware, operating system, software and communication requirements for a partitioned DB2 server (Linux).

    Hardware requirements
    You require one of the following types of hardware:

    Distribution requirements
    For the latest information on supported distribution and kernel levels, point your browser to http://www.ibm.com/db2/linux/validate

    Software requirements

    Communication requirements
    TCP/IP is required to access remote databases.

    DB2 Administration Server (DAS) requirements
    The following requirements must be met:

    Installing DB2 products or sharing instance directory on NFS
    Currently, we do not support the installation of DB2 products on NFS. Installing DB2 on NFS (for example, NFS mounting /usr/opt/db2_08_01 or /opt/IBM/db2/V8.1) can be error prone and these errors can be difficult to diagnose.

    The following configuration is not supported:

    This configuration can cause file locking and performance problems.


    Installation requirements for partitioned DB2 servers (Solaris Operating Environment)

    This topic lists hardware, operating system, software and communication requirements for a partitioned DB2 server (Solaris Operating Environment).

    Hardware requirements
    Solaris UltraSPARC-based computer

    Operating system requirements

    DB2 Enterprise Server Edition is supported on the following Solaris Operating Environment versions:

    "Recommended & Security Patches" can be obtained from the http://sunsolve.sun.com Web site.

    The following software is required to install DB2 on the Solaris Operating Environment:

    For DB2 on 64-bit Fujitsu PRIMEPOWER systems, you also require the following:

    .

    Software requirements

    Communication requirements
    APPC, or TCP/IP. You can only use TCP/IP to remotely administer databases.

    DB2 Version 8 servers, with DB2 Connect server support, only support outbound APPC client requests; there is no support for inbound APPC client requests.

    DB2 Administration Server (DAS) requirements
    The following requirements must be met:

    Installing DB2 products or sharing instance directory on NFS
    Currently, we do not support the installation of DB2 products on NFS. Installing DB2 on NFS (for example, NFS mounting /usr/opt/db2_08_01 or /opt/IBM/db2/V8.1) can be error prone and these errors can be difficult to diagnose.

    The following configuration is not supported:

    This configuration can cause file locking and performance problems.


    Installation Prerequisites: DB2 Connect Personal Edition


    Disk requirements for DB2 Connect Personal Edition (Linux)

    The disk requirements DB2 Connect Personal Edition depend on the the type of installation and the components you install. When you install DB2 Connect Personal Edition using the DB2 Setup wizard, size estimates are dynamically provided by the installation program based on installation type and component selection.

    The DB2 Setup wizard provides typical, compact, and custom installation types.

    Typical installation
    DB2 Connect Personal Edition is installed with most features and functionality, using a typical configuration. Includes graphical tools such as the Control Center and Configuration Assistant.

    Compact installation
    Only the basic DB2 Connect Personal Edition features and functions are installed. The compact installation does not include graphical tools or federated access to IBM data sources.

    Custom installation
    A custom installation allows you to select the features you want to install.

    Remember to include disk space allowance for required software, communication products, and documentation. In DB2 version 8, HTML and PDF documentation is provided on separate CD-ROMs.


    Memory requirements for DB2 Connect Personal Edition (Linux)

    The amount of memory required to run DB2 Connect Personal Edition depends on the components you install. The following table provides recommended memory requirements for DB2 Personal Edition installed with and without graphical tools such as the Control Center and Configuration Assistant.

    Table 2. DB2 Connect Personal Edition for Linux memory requirements

    Type of installation Recommended minimum memory (RAM)
    DB2 Personal Edition without graphical tools 64 MB
    DB2 Personal Edition with graphical tools 128 MB

    When determining memory requirements, be aware of the following:


    Installation requirements for DB2 Connect Personal Edition (Linux)

    To install a DB2 Connect Personal Edition, the following operating system, software, and communications requirements must be met:

    Hardware requirements
    Your processor must be one of:

    Distribution requirements
    For the latest information on supported distribution and kernel levels, point your browser to http://www.ibm.com/db2/linux/validate

    Software requirements
    The IBM Developer Kit for Java 1.3.1 Service Release 1 is required for DB2 servers, for using the DB2 Control Center, and for creating and running Java applications, including stored procedures and user-defined functions. During the installation process, if the correct level of the JDK is not already installed, it will be installed.

    Communication requirements
    For TCP/IP connectivity, no additional software is required.

    Installation Prerequisites: DB2 Connect Enterprise Edition


    AIX

    Disk requirements for DB2 Connect Enterprise Edition (AIX)

    The disk requirements for DB2 Connect Enterprise Edition depend on the type of installation and the components you install.When you install DB2 Connect Enterprise Edition using the DB2 Setup wizard, size estimates are dynamically provided by the installation program based on installation type and component selection.

    The DB2 Setup wizard provides typical, compact, and custom installation types.

    Typical installation
    DB2 Connect Enterprise Edition installed with a typical configuration has most features and functionality. This installation includes graphical tools such as the Control Center and Configuration Assistant.

    Compact installation
    Only the basic DB2 Connect Enterprise Edition features and functions are installed. Does not include graphical tools or federated access to IBM data sources.

    Custom installation
    A custom installation allows you to select the features and functions you want to install.

    The DB2 Setup wizard will provide a disk space estimate for the installation options you select.

    Remember to include disk space allowance for required software, communication products, and documentation. In DB2 Version 8, HTML and PDF documentation is provided on separate CD-ROMs.

    Memory requirements for DB2 Connect Enterprise Edition (AIX)

    The amount of memory required to run DB2 Connect Enterprise Edition depends on the components you install. The following table provides recommended memory requirements for DB2 Connect Enterprise Edition installed with and without graphical tools such as the Control Center and Configuration Assistant.

    Table 3. DB2 Connect Enterprise Edition memory requirements on AIX

    Type of installation Recommended memory (RAM)
    DB2 Connect Enterprise Edition without graphical tools 64 MB
    DB2 Connect Enterprise Edition with graphical tools 128 MB

    When determining memory requirements, be aware of the following:

    Installation requirements for DB2 Connect Enterprise Edition (AIX)

    To install DB2 Connect Enterprise Edition, the following requirements must be met:

    Hardware requirements

    Operating system requirements
    DB2 Connect Enterprise Edition is available on:
    Note:
    You can query your system to see if a particular APAR is installed with the instfix -v -i -k <APAR> command. For example, instfix -v -i -k IY31254.

    The following AIX filesets are required to install or run DB2 in languages other than English:

    AIX filesets can be downloaded from: http://techsupport.services.ibm.com/server/fixes

    Software requirements

    You will need a Java Runtime Environment (JRE) Version 1.3.1 Service Release 2 to run DB2's Java-based tools, such as the Control Center, and to create and run Java applications, including stored procedures and user-defined functions. During the installation process, if the correct level of the JRE is not already installed, it will be installed.

    If you are running in a 64-bit environment and installing DB2 from a CD-ROM, you will need to install the JRE from a separate CD-ROM called "IBM Developer Kit on 64-bit systems, Java Technology Edition for AIX".

    Communication requirements
    You can use APPC, TCP/IP, and MPTN (APPC over TCP/IP)

    Notes:

    1. If you plan to use the Simple Network Management Protocol (SNMP) subagent, you require DPI 2.0 provided by IBM SystemView Agent.

    2. For LDAP (Lightweight Directory Access Protocol) support, you require an IBM SecureWay Directory Client V3.1.1 running on AIX Version 4.3.3 or higher.

    HP-UX

    Disk requirements for DB2 Connect Enterprise Edition (HP-UX)

    The disk requirements for DB2 Connect Enterprise Edition depend on the type of installation and the components you install. When you install DB2 Connect Enterprise Edition using the DB2 Setup wizard, size estimates are dynamically provided by the installation program based on installation type and component selection.

    The DB2 Setup wizard provides typical, compact, and custom installation types.

    Typical installation
    DB2 Connect Enterprise Edition is installed with most features and functionality, using a typical configuration. This installation includes graphical tools such as the Control Center and Configuration Assistant.

    Compact installation
    Only the basic DB2 Connect Enterprise Edition features and functions are installed. This installation does not include graphical tools or federated access to IBM data sources.

    Custom installation
    A custom installation allows you to select the features you want to install.

    The DB2 Setup wizard will provide a disk space estimate for the installation options you select.

    Remember to include disk space allowance for required software, communication products, and documentation. In DB2 Version 8, HTML and PDF documentation is provided on separate CD-ROMs.

    Memory requirements for DB2 Connect Enterprise Edition (HP-UX)

    The amount of memory required to run DB2 Connect Enterprise Edition depends on the components you install. The following table provides recommended memory requirements for DB2 Connect Enterprise Edition installed with and without graphical tools such as the Control Center and Configuration Assistant.

    Table 4. DB2 Connect Enterprise Edition memory requirements on HP-UX

    Type of installation Recommended memory (RAM)
    DB2 Connect Enterprise Edition without graphical tools 64 MB
    DB2 Connect Enterprise Edition with graphical tools 128 MB

    When determining memory requirements, be aware of the following:

    Installation requirements for DB2 Connect Enterprise Edition (HP-UX)

    To install a DB2 Connect Enterprise Edition, the following operating system, software, and communication requirements must be met:

    Hardware requirements
    HP 9000 Series 700 or 800 system

    Operating system requirements
    DB2 Connect Enterprise Edition can run on:

    HP-UX 11i (11.11) for PA-RISC 2 with:

    Software requirements

    You will need a Java Runtime Environment (JRE) Version 1.3.1 to run DB2's Java-based tools, such as the Control Center, and to create and run Java applications, including stored procedures and user-defined functions. During the installation process, if the correct level of the JRE is not already installed, it will be installed.

    If you are running in a 64-bit environment, you will need JRE Version 1.4. If you are installing DB2 from a CD-ROM you will need to install the JRE from a separate CD-ROM called "IBM Developer Kit on 64-bit systems, Java Technology Edition for HP-UX and the Solaris Operating Environment".

    Communication requirements
    You can use APPC, TCP/IP, and MPTN (APPC over TCP/IP)

    Notes:

    1. If you plan to use the Simple Network Management Protocol (SNMP) subagent, you require DPI 2.0 provided by IBM SystemView Agent.

    Linux

    Disk requirements for DB2 Connect Enterprise Edition (Linux)

    The disk requirements for DB2 Connect Enterprise Edition depend on the type of installation and the components you install. When you install DB2 Connect Enterprise Edition using the DB2 Setup wizard, size estimates are dynamically provided by the installation program based on installation type and component selection.

    The DB2 Setup wizard provides typical, compact, and custom installation types.

    Typical installation
    DB2 Connect Enterprise Edition is installed with most features and functionality, using a typical configuration. This installation includes graphical tools such as the Control Center and Configuration Assistant.

    Compact installation
    Only the basic DB2 Connect Enterprise Edition features and functions are installed. This installation does not include graphical tools or federated access to IBM data sources.

    Custom installation
    A custom installation allows you to select the features you want to install.

    The DB2 Setup wizard will provide a disk space estimate for the installation options you select.

    Remember to include disk space allowance for required software, communication products, and documentation. In DB2 Version 8, HTML and PDF documentation is provided on separate CD-ROMs.

    Memory requirements for DB2 Connect Enterprise Edition (Linux)

    The amount of memory required to run DB2 Connect Enterprise Edition depends on the components you install. The following table provides recommended memory requirements for DB2 Connect Enterprise Edition installed with and without graphical tools such as the Control Center and Configuration Assistant.

    Table 5. DB2 Connect Enterprise Edition memory requirements on Linux

    Type of installation Recommended memory (RAM)
    DB2 Connect Enterprise Edition without graphical tools 64 MB
    DB2 Connect Enterprise Edition with graphical tools 128 MB

    When determining memory requirements, be aware of the following:

    Installation requirements for DB2 Connect Enterprise Edition (Linux)

    To install a DB2 Connect Enterprise Edition, the following operating system, software, and communication requirements must be met:

    Hardware requirements
    Your processor can be:

    Distribution requirements
    To check for the latest technical information on the supported levels of Linux, point your browser to http://ibm.com/db2/linux/validate

    Software requirements

    Communication requirements
    For TCP/IP connectivity, no additional software is required.

    Solaris

    Disk requirements for DB2 Connect Enterprise Edition (Solaris)

    The disk requirements for DB2 Connect Enterprise Edition depend on the type of installation and the components you install. When you install DB2 Connect Enterprise Edition using the DB2 Setup wizard, size estimates are dynamically provided by the installation program based on installation type and component selection.

    The DB2 Setup wizard provides typical, compact, and custom installation types.

    Typical installation
    DB2 Connect Enterprise Edition is installed with most features and functionality, using a typical configuration. This installation includes graphical tools such as the Control Center and Configuration Assistant.

    Compact installation
    Only the basic DB2 Connect Enterprise Edition features and functions are installed. This installation does not include graphical tools or federated access to IBM data sources.

    Custom installation
    A custom installation allows you to select the features you want to install.

    The DB2 Setup wizard will provide a disk space estimate for the installation options you select.

    Remember to include disk space allowance for required software, communication products, and documentation. In DB2 Version 8, HTML and PDF documentation is provided on separate CD-ROMs.

    Memory requirements for DB2 Connect Enterprise Edition (Solaris)

    The amount of memory required to run DB2 Connect Enterprise Edition depends on the components you install. The following table provides recommended memory requirements for DB2 Connect Enterprise Edition installed with and without graphical tools such as the Control Center and Configuration Assistant.

    Table 6. DB2 Connect Enterprise Edition memory requirements on Solaris

    Type of installation Recommended memory (RAM)
    DB2 Connect Enterprise Edition without graphical tools 64 MB
    DB2 Connect Enterprise Edition with graphical tools 128 MB

    When determining memory requirements, be aware of the following:

    Installation requirements for DB2 Connect Enterprise Edition (Solaris)

    To install a DB2 Connect Enterprise Edition, the following operating system, software, and communication requirements must be met:

    Hardware requirements
    Solaris UltraSPARC-based computer

    Operating system requirements
    DB2 Enterprise Server Edition is supported on the following Solaris Operating Environment versions:

    "Recommended & Security Patches" can be obtained from the http://sunsolve.sun.com Web site.

    For DB2 on 64-bit Fujitsu PRIMEPOWER systems, you also require the following:

    The following software is required to install DB2 on Solaris:

    Software requirements

    You will need a Java Runtime Environment (JRE) Version 1.3.1 to run DB2's Java-based tools, such as the Control Center, and to create and run Java applications, including stored procedures and user-defined functions. During the installation process, if the correct level of the JRE is not already installed, it will be installed.

    If you are running in a 64-bit environment, you will need JRE Version 1.4. If you are installing DB2 from a CD-ROM you will need to install the JRE from a separate CD-ROM called "IBM Developer Kit on 64-bit systems, Java Technology Edition for HP-UX and the Solaris Operating Environment".

    Communication requirements
    You can use APPC or TCP/IP

    Notes:

    1. DB2 Connect is supported on Sun Cluster 2.2 if:
      • The protocol to the host is TCP/IP (not SNA)
      • Two-phase commit is not used. This restriction is relaxed if the user configures the SPM log to be on a shared disk (this can be done through the spm_log_path database manager configuration parameter), and the failover machine has an identical TCP/IP configuration (the same host name, IP address, and so on).

    Installation Prerequisites: DB2 Clients


    Disk requirements for DB2 clients

    The actual fixed disk requirements of your installation may vary depending on your file system and the client components you install. Ensure that you have included a disk space allowance for your application development tools and communication products.

    When you install a DB2 client using the DB2 Setup wizard, size estimates are dynamically provided by the installation program based on installation type and component selection.


    Memory requirements for DB2 clients

    The following list outlines the recommended minimum memory requirements for the different types of DB2 clients:

    Note:
    Performance may be affected if less than the recommended minimum memory requirements are used.

    Installation requirements for DB2 clients (AIX)

    The following list provides hardware requirements, operating system requirements, software requirements, and communication requirements for your DB2 client on AIX.

    Hardware requirements
    RISC System/6000

    Operating system requirements
    AIX Version 4.3.3.78 or later

    The following AIX filesets are required to install or run DB2 in languages other than English:

    AIX filesets can be downloaded from: http://techsupport.services.ibm.com/server/fixes

    Software requirements

    Communication requirements
    Note:
    In Version 8, DB2 only supports TCP/IP for remotely administering a database.

    Installation requirements for DB2 clients (HP-UX)

    The following list provides hardware requirements, operating system requirements, software requirements, and communication requirements for your DB2 client on HP-UX.

    Restrictions

    A system reboot is required if the kernel configuration parameters have been updated. The kernel configuration parameters are set in /etc/system and if these parameters require modification to accommodate the DB2 client, a reboot will be necessary to make the changes to /etc/system effective.

    Note:
    The parameters must be set in advance of the DB2 client install.

    Hardware requirements
    HP 9000 Series 700 or 800 system

    Operating system requirements

    Software requirements

    Communication requirements
    Note:
    In Version 8, DB2 only supports TCP/IP for remotely administering a database.

    Installation requirements for DB2 clients (Linux)

    The following list provides operating system requirements, software requirements, and communication requirements for your DB2 client on Linux.

    Restrictions

    A system reboot is required if the kernel configuration parameters have been updated. The kernel configuration parameters are set in /etc/system and if these parameters require modification to accommodate the DB2 client, a reboot will be necessary to make the changes to /etc/system effective.

    Note:
    The parameters must be set in advance of the DB2 client install.

    Operating system requirements

    To check for the latest technical information on the supported levels of Linux, point your browser to http://ibm.com/db2/linux/validate

    Software requirements

    The Java Developer's Kit (JDK) Version 1.3.1 is required to run DB2 graphical tools, such as the Control Center, and to create and run Java applications, including stored procedures and user-defined functions. During the installation process, if the JDK is not already installed, it will be installed.

    The DB2 Java gui tools are not provided with the DB2 Version 8 Run-Time Client.

    Communication requirements
    Note:
    In Version 8, DB2 only supports TCP/IP for remotely administering a database.

    Installation requirements for DB2 clients (Solaris)

    The following list provides hardware requirements, operating system requirements, software requirements, and communication requirements for your DB2 client on the Solaris Operating Environment.

    Restrictions

    A system reboot is required if the kernel configuration parameters have been updated. The kernel configuration parameters are set in /etc/system and if these parameters require modification to accommodate the DB2 client, a reboot will be necessary to make the changes to /etc/system effective.

    Note:
    The parameters must be set in advance of the DB2 client install.

    Hardware requirements
    Solaris SPARC-based computer

    Operating system requirements

    The following software is required to install DB2 on Solaris:

    Software requirements

    Communication requirements
    Note:
    In Version 8, DB2 only supports TCP/IP for remotely administering a database.

    IBM Distributed Debugger for Java Stored Procedures (v9.2.3) CD

    When using the Development Center, you will need to install the Distributed Debugger (v9.2.3) on the DB2 server in order to debug Java stored procedures running on that server.

    To install the IBM Distributed Debugger:

    Windows
    Prerequisites:

    For standalone debugging, the location of the Java executable specified in the PATH environment variable must be from the JDK "bin" directory. For example, if, on Windows NT, the PATH environment variable points to the java.exe in the \WINNT\SYSTEM32 directory, the Debugger cannot debug the application. To avoid this problem, insert the full path to java.exe in the JDK bin directory to the start of the PATH environment variable.

    If you install this version of the Debugger over WebSphere Application Server V3.02 on Windows NT, then you must go into the IBMDebug\bin directory and rename ivbtr30i.302 to ivbtr30i.dll. The Debugger will not function if installed in a directory whose name contains spaces or DBCS characters.

    1. Insert the DB2 Distributed Debugger CD.
    2. From the DB2 Distributed Debugger CD, run the Windows\setup.exe command.
    3. Select the Full radio button to install all components of the Distributed Debugger. The Full install option is required for debugging DB2 Java stored procedures from Windows clients. By default, the Distributed Debugger will be installed in the C:\IBMDebug directory.
    4. To use remote stored procedure debugging on DB2, add the \IBMDebug\lib\dertrjrt.jar file to your system CLASSPATH.

    Linux (Intel)
    1. Log on as root.
    2. Mount the DB2 Distributed Debugger CD. The Linux installation image, DERJPICL-9-2-3.i386.rpm, is on the CD in the \Linux directory.
    3. From the Linux directory, run the rpm -Uvh DERJPICL-9-2-3.i386.rpm command.
    4. To verify the installation, run the rpm -qa | grep -i derj command. The following entry should appear: DERJPICL-9-2.3 4. By default, the Distributed Debugger is installed in the /opt/ibm/IBMDebug directory.

    AIX
    1. Log on as root.
    2. Mount the DB2 Distributed Debugger CD.
    3. Copy the installation files from <cdrom_path>/AIX to the machine on which you want to install the Debugger.
    4. Use installp or smitty install_latest.
    5. If you are debugging remote stored procedures on DB2, you must add the /usr/lpp/idebug/lib/dertrjrt.jar file to your system CLASSPATH.
    6. Users and DB2 instance owners should add /IBMDebug/bin to their PATH.

    Solaris
    Prerequisites:

    If you are using a locale other than en_US, you must add /opt/IBMdebug/msg/%L/%N to the NLSPATH environment variable.

    1. Log on as root.
    2. Mount the DB2 Distributed Debugger CD.
    3. The install image is in the /Solaris directory.
    4. Run the ./dbgsetup idebug.pkg command.
    5. DB2 instance owners should add /opt/ibm/IBMDebug/bin to their PATH.
    6. If you are debugging remote stored procedures on DB2, you must add the /opt/IBMdebug/lib/dertrjrt.jar file to your system CLASSPATH.

    DB2 Server Configuration

    On each DB2 instance that will support debugging of stored procedures, enter the db2set DB2ROUTINE_DEBUG=on command.

    For instructions on uninstalling the debugger, please refer to the README file from the installation.


    IBM(R) DB2 Universal Database(TM) Installation Notes for UNIX - Version 8

    Review this entire section before installing DB2.


    Installing DB2 from compressed images on AIX 5L and the Solaris Operating Environment

    The installation images on AIX 5L and the Solaris Operating Environment are delivered in compressed format on the product CD-ROMs. To install DB2 on these platforms, you need to copy the installation image to a temporary directory, uncompress it, and perform the installation.

    Note:
    In addition to the software disk requirements described in this document, you need to have a filesystem with 2 GB of free space to contain the tar.Z file and the uncompressed installation image.

    To install DB2, perform the following steps:

    1. Copy the compressed installation image to a temporary file system containing at least 2 GB of free space. The compressed image on the CD-ROM is called PRODUCT.tar.Z, where PRODUCT is the DB2 product that you are installing. For example, if you are installing DB2 Enterprise Server Edition, the compressed image on the relevant CD-ROM is called ese.tar.Z.
    2. Change to the directory where you have copied the installation image by entering cd /TMP, where /TMP represents the directory where you have copied the compressed image.
    3. Enter the following command to uncompress the installation image: zcat PRODUCT.tar.Z | tar -xf - where PRODUCT is again the DB2 product that you are installing.
    4. Run the following command to start the DB2 Setup wizard: ./PRODUCT/db2setup

    DB2 HTML Documentation CD installation must follow DB2 Product installation


    DB2 HTML Documentation CD installation must follow DB2 Product installation

    You must install the DB2 Version 8 Administration Client before installing the DB2 HTML documentation in order to view the documentation from the Administration tools. The DB2 Administration client is installed automatically if you perform a typical installation using the DB2 Setup wizard.


    Availability of Asian fonts for Linux

    IBM offers additional font packages for Linux that contain additional double-byte character set (DBCS) support for Asian characters. These font packages are necessary with some versions of Linux which install only the fonts required to display the country-specific or region-specific characters.

    If you run the db2setup command and find missing characters in the DB2 setup wizard interface, then it is likely that your Linux system does not have all the necessary fonts installed. To enable db2setup to properly reference the fonts embedded in the installation CD-ROM, perform the following:

    1. Enter the following command: export JAVA_FONTS=/<cdrom>/db2/<linux_platform>/java/jre/lib/fonts where <cdrom> is the location of the install image, and <linux_platform> is either "linux" or "linux390"
    2. Re-run the db2setup command.

    If you notice missing characters when using the DB2 GUI tools after installation, you will have to install the necessary fonts provided with the DB2 product. These fonts can be found in the fonts directory on the CD-ROM called IBM Developer Kit on 64-bit Enabled Platforms, Java Technology Edition, Version 1.3.1.

    In this directory, there are two typefaces available: Times New Roman WorldType and Monotype Sans Duospace WorldType. For each typeface, there is a country- or region-specific font. The following table lists the eight fonts provided in compressed format in the fonts directory.


    Font typeface Font file name Country/Region
    Times New Roman WT J tnrwt_j.zip Japan and other countries/regions
    Times New Roman WT K tnrwt_k.zip Korea
    Times New Roman WT SC tnrwt_s.zip China (Simplified Chinese)
    Times New Roman WT TC tnrwt_t.zip Taiwan (Traditional Chinese)
    Monotype Sans Duospace WT J mtsansdj.zip Japan and other countries/regions
    Monotype Sans Duospace WT K mtsansdk.zip Korea
    Monotype Sans Duospace WT SC mtsansds.zip China (Simplified Chinese)
    Monotype Sans Duospace WT TC mtsansdt.zip Taiwan (Traditional Chinese)
    Note:
    These fonts do not replace the system fonts. These fonts are to be used in conjunction with or for use with DB2 Universal Database. You cannot engage in the general or unrestricted sale or distribution of these fonts.

    To install a font:

    1. Unzip the font package.
    2. Copy the font package to the /opt/IBMJava2-131/jre/lib/fonts directory. You need to create the directory if it does not already exist.
    3. Enter the following command: export JAVA_FONTS=/opt/IBMJava2-131/jre/lib/fonts

    As a minimum you need to install one font of each typeface for your country or region. If you are in China, Korea, or Taiwan, use the country-specific or region-specific versions; otherwise, use the Japanese version of the fonts. If you have space on your system, it is recommended that you install all eight fonts.


    Prerequisites for DB2 Version 8 Clients connecting to DB2 for z/VM and VM/VSE, DB2 for eServer iSeries and AS/400, and DB2 for z/OS and OS/390

    DB2 Version 8 client applications which connect to host databases (DB2 for z/VM and VM/VSE, DB2 for eServer iSeries and AS/400, and DB2 for z/OS and OS/390) require that a set of DB2 PTF/APARs be applied to the target servers.

    To use DB2 Version 8 clients which connect to DB2 for z/VM and VM/VSE, contact DB2 for VM/VSE support for the patches that need to be applied to the target database.

    To use DB2 Version 8 clients which connect to DB2 for z/OS and OS/390, you must install the patch for APAR PQ62695.

    To use DB2 Version 8 clients which call these functions and connect to DB2 for eServer iSeries and AS/400, you must install the following patches:

    APAR PTF
    V5R1: 5722SS1 SI05363

    Additional information about these patches, and the patches themselves can be downloaded from: http://techsupport.services.ibm.com/server/support


    Migrating the Information Catalog database during Warehouse Manager installation

    This task is part of the larger task of installing the Warehouse Manager.

    Procedure

    The Information Catalog database can be either a local database or a remote database. If the previous Information Catalog database (Version 6 or Version 7) is local, then perform the following steps:

    1. On the "Prepare the information catalog" installation panel, choose the "Use a local database to store your information catalog" radio button.
    2. Click the "Next" button at the bottom of the panel.
    3. On the "Specify a local database to store the information catalog" installation panel, select the instance of the existing information catalog database from the "Instance name" drop-down menu.
    4. Select the "Existing" radio button from the "Database name" text field. The existing ICM database will be displayed in the text field.
      Note:
      If the database that is displayed in the text field is not the desired database, then click the button beside the text field. This will pop up a list of existing databases that can be chosen.
    5. Select the "Existing" radio button from the "Schema" text field. The existing Schema will be displayed in the text field.
      Note:
      If the schema that is displayed in the text field is not the desired schema, then click the button beside the text field. This will pop up a list of existing schemas that can be chosen.
    6. Click the "Next" button at the bottom of the panel to continue with the installation.

    If the previous Information Catalog database (Version 6 or Version 7) is remote, then perform the following steps:

    1. On the "Prepare the information catalog" installation panel, choose the "Use a remote database to store your information catalog" radio button.
    2. Click the "Next" button at the bottom of the panel.
    3. On the "Specify a remote database to store the information catalog" installation panel, specify the "Host name", the "Service name", the "Database name", the "Schema", the "Database user name", and the "Password" in the fields provided.
    4. Click the "Next" button at the bottom of the panel to continue with the installation.

    Configuring the Development Center to use JDKs that are not installed or configured by DB2

    In some cases, DB2 does not install or configure a Java Development Kit on the client machine operating system. On Linux, the JDK is installed but not configured to be used by the Development Center. On Sun Solaris and AIX, no JDK is installed on the client. To use the Development Center to develop Java stored procedures on these clients, you must point the Development Center to the location of an installed JDK.

    To identify the location of a JDK, add a jdk subdirectory under ~/sqllib/java and create links to the subdirectory where a JDK is installed.

    The following example shows how to create the links to the JDK on a Linux client:

    Note:
    Replace db2admin below if your instance owner is named differently
     # Setup the jdk directorymkdir /home/db2admin/sqllib/java/jdk 
    chown bin /home/db2admin/sqllib/java/jdk
    chgrp bin /home/db2admin/sqllib/java/jdk 
     
     # Setup the links for jdk
    cd /home/db2admin/sqllib/java/jdk
    ln -s /opt/IBMJava2-131/bin
    ln -s /opt/IBMJava2-131/demo
    ln -s /opt/IBMJava2-131/docs
    ln -s /opt/IBMJava2-131/include 
    ln -s /opt/IBMJava2-131/jre
    ln -s /opt/IBMJava2-131/lib 
    ln -s /opt/IBMJava2-131/src.jar
     
     # Setup the links to the .so files 
    cd /usr/lib
    ln -s /opt/IBMJava2-131/jre/bin/libhpi.so 
    ln -s /opt/IBMJava2-131/jre/bin/libjava.so
    ln -s /opt/IBMJava2-131/jre/bin/libjitc.so
    ln -s /opt/IBMJava2-131/jre/bin/libxhpi.so
    ln -s /opt/IBMJava2-131/jre/bin/libzip.so
    ln -s /opt/IBMJava2-131/jre/bin/classic/libjvm.so 
    

    DB2 for UNIX and Windows Version 7.2 federated databases

    To successfully create nicknames for DB2 for UNIX and Windows Version 8 tables and views, you must apply the DB2 for UNIX and Windows Version 7.2 Fixpak 8 on your DB2 for UNIX and Windows Version 7.2 federated database. If you do not apply Fixpak 8 on your DB2 for UNIX and Windows Version 7.2 federated database, an error will occur when you access the nicknames.


    Post Installation step for DB2 Version 8 Spatial Extender on the Solaris Operating Environment

    You must set the following registry variable after you install DB2 Spatial Extender on a 32-bit Solaris Operating Environment. To set the variable, use this command: db2set DB2DBMSADDR=0X40000000

    This setting is required for certain spatial applications that require a large heap size.


    DB2 Information Center installation prerequisite

    The search facility for the DB2 Information Center requires a Java-enabled browser and Java Plug-in for viewing Java applets.


    Notices

    IBM may not offer the products, services, or features discussed in this document in all countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service.

    IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:

    IBM Director of Licensing
    IBM Corporation
    North Castle Drive
    Armonk, NY 10504-1785
    U.S.A.

    For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country/region or send inquiries, in writing, to:

    IBM World Trade Asia Corporation
    Licensing
    2-31 Roppongi 3-chome, Minato-ku
    Tokyo 106, Japan

    The following paragraph does not apply to the United Kingdom or any other country/region where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY, OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions; therefore, this statement may not apply to you.

    This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.

    Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product, and use of those Web sites is at your own risk.

    IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.

    Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information that has been exchanged, should contact:

    IBM Canada Limited
    Office of the Lab Director
    8200 Warden Avenue
    Markham, Ontario
    L6G 1C7
    CANADA

    Such information may be available, subject to appropriate terms and conditions, including in some cases payment of a fee.

    The licensed program described in this document and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us.

    Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems, and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.

    Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements, or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility, or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.

    All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.

    This information may contain examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious, and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.

    COPYRIGHT LICENSE:

    This information may contain sample application programs, in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM for the purposes of developing, using, marketing, or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs.

    Each copy or any portion of these sample programs or any derivative work must include a copyright notice as follows:

    (C) (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs. (C) Copyright IBM Corp. _enter the year or years_. All rights reserved.


    Trademarks

    The following terms are trademarks of International Business Machines Corporation in the United States, other countries, or both, and have been used in at least one of the documents in the DB2 UDB documentation library.

    ACF/VTAM
    AISPO
    AIX
    AIXwindows
    AnyNet
    APPN
    AS/400
    BookManager
    C Set++
    C/370
    CICS
    Database 2
    DataHub
    DataJoiner
    DataPropagator
    DataRefresher
    DB2
    DB2 Connect
    DB2 Extenders
    DB2 OLAP Server
    DB2 Universal Database
    Distributed Relational
    Database Architecture
    DRDA
    eServer
    Extended Services
    FFST
    First Failure Support Technology
    IBM
    IMS
    IMS/ESA
    iSeries
    LAN Distance
    MVS
    MVS/ESA
    MVS/XA
    Net.Data
    NetView
    OS/390
    OS/400
    PowerPC
    pSeries
    QBIC
    QMF
    RACF
    RISC System/6000
    RS/6000
    S/370
    SP
    SQL/400
    SQL/DS
    System/370
    System/390
    SystemView
    Tivoli
    VisualAge
    VM/ESA
    VSE/ESA
    VTAM
    WebExplorer
    WebSphere
    WIN-OS/2
    z/OS
    zSeries

    The following terms are trademarks or registered trademarks of other companies and have been used in at least one of the documents in the DB2 UDB documentation library:

    Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.

    Intel and Pentium are trademarks of Intel Corporation in the United States, other countries, or both.

    Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.

    UNIX is a registered trademark of The Open Group in the United States and other countries.

    Other company, product, or service names may be trademarks or service marks of others.