IBM(R) DB2 Universal Database(TM) Installation Notes
IBM(R) DB2 Universal Database(TM) Installation Notes
About this document
Memory Requirements for DB2 Version 8 using the Control Center and other graphical tools
Installation Prerequisites: DB2 Personal Edition
Installation Prerequisites: DB2 Workgroup Server Edition and non-partitioned DB2 Enterprise Server Edition
Installation Prerequisites: partitioned DB2 Enterprise Server Edition
Installation Prerequisites: DB2 Connect Personal Edition
Installation Prerequisites: DB2 Connect Enterprise Edition
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
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:
- Verify that your environment meets the Disk, Memory and Installation
requirements for the platform and DB2 product you are installing.
- Review the Installation Notes for last minute information about performing
the installation.
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:
- The memory requirements documented do not account for non-DB2 software
that may be running on your system.
- Memory requirements may be affected by the size and complexity of your
database system.
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.
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:
- The memory requirements documented above do not account for non-DB2
software that may be running on your system.
- Memory requirements may be affected by the size and complexity of your
database system.
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.
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.
At a minimum, DB2 requires 256 MB of RAM. Additional memory may be
required.
When determining memory requirements, be aware of the following:
- Additional memory may be required for non-DB2 software that may be running
on your system.
- Additional memory is required to support database clients.
- Specific performance requirements may determine the amount of memory
needed.
- Memory requirements will be affected by the size and complexity of your
database system.
- Memory requirements will be affected by the extent of database activity
and the number of clients accessing your system.
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:
- IBM RISC/6000
- eServer pSeries
- Operating system requirements
-
DB2 Enterprise Server Edition is available on:
- Version 4.3.3 with maintenance level 9 or later, APARs
IY22308, Y32690, and IY33024 (32-bit only)
- Version 5.1.0 with maintenance level 2 or later, APARs
IY31254, IY32217, IY32905, IY29345, and IY33023 (32-bit)
- Version 5.1.0 with maintenance level 2 or later, APARs
IY31254, IY32217, IY32466, IY32905, IY29345, IY32466, and IY33023 (64-bit)
- Version 5.2.0 with APARs IY29345 and IY32466 (32-bit and
64-bit)
DB2 Workgroup Server Edition is available on:
- Version 4.3.3 with maintenance level 9 or later, APARs
IY22308, Y32690, and IY33024 (32-bit only)
- Version 5.1.0 with maintenance level 2 or later, APARs
IY22308, Y32690, and IY33024 (32-bit only)
- 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:
- X11.fnt.ucs.ttf (AIX Windows Unicode
TrueType Fonts)
- xlC.rte 5.0.2.x
- For Asian languages, the following file sets are also required:
- X11.fnt.ucs.ttf_CN (for zh_CN or Zh_CN)
- X11.fnt.ucs.ttf_KR (for ko_KR)
- X11.fnt.ucs.ttf_TW (for zh_TW or Zh_TW)
- On AIX Version 4.3.3 the following file set is
required:
- On AIX Version 5.x the following fileset is required:
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".
- A browser is required to view online help.
- 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.
- For TCP/IP connectivity, no additional software is required.
- For APPC (CPI-C) connectivity, through the DB2 Connect server support
feature, one of the following communication products is required:
- IBM eNetwork Communications Server for AIX V5.0.3
- Bull DPX/20 SNA/20
- For LDAP (Lightweight Directory Access Protocol) support, you require an
IBM SecureWay Directory Client V3.1.1
- If you plan to use the Simple Network Management Protocol (SNMP) subagent,
you require DPI 2.0 provided by IBM SystemView Agent.
- 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:
- Setting up an instance on a file system
- NFS mounting a filesystem from multiple computers, and then run DB2 on
these computers using that same instance.
This configuration can cause file locking and performance
problems.
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:
- December 2001 GOLDBASE11i bundle
- December 2001 GOLDAPPS11i bundle
- patch PHSS_26560
- 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".
- A browser is required to view online help.
- Communication requirements
- APPC or TCP/IP. You can only use TCP/IP to remotely administer
databases.
- For TCP/IP connectivity, no additional software is required.
- For APPC (CPI-C) connectivity through the DB2 Connect server support
feature, the following software is required:
- SNAplus2 Link R6.11.00.00
- SNAplus2 API R.6.11.00.00
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:
- Setting up an instance on a file system
- NFS mounting a filesystem from multiple machines, and then run DB2 on
these machines using that same instance.
This configuration can cause file locking and performance
problems.
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:
- Intel 32-bit
- Intel 64-bit
- S/390 9672 Generation 5 or higher, Multiprise 3000 or eServer z-Series
- 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.
- A browser is required to view online help.
- 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:
- Setting up an instance on a file system
- NFS mounting a file system from multiple computers, and then running DB2
on these machines using that same instance.
This configuration can cause file locking and performance
problems.
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:
- Solaris 7 (32-bit) "Recommended & Security Patches" + 107226-17 +
107153-01 + 106327-10
- Solaris 8 (32-bit) "Recommended & Security Patches" + 108921-12 +
108940-24 + 108434-03 and 108528-12
- Solaris 9 (32-bit)
DB2 Enterprise Server Edition is supported on the following Solaris
Operating Environment versions:
- Solaris 7 (32-bit) "Recommended & Security Patches" + 107226-17 +
107153-01 + 106327-10
- Solaris 7 (64-bit) "Recommended & Security Patches" + 107226-17 +
107153-01 + 106300-11
- Solaris 8 (32-bit) "Recommended & Security Patches" + 108921-12 +
108940-24 + 108434-03 and 108528-12
- Solaris 8 (64-bit) "Recommended & Security Patches" + 108921-12 +
108940-24 + 108435-03 and 108528-12
- Solaris 9 (32-bit)
- Solaris 9 (64-bit)
"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:
- Solaris 8 KU15 921040-01
- Solaris 9 FCS 912031-01
- 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".
- A browser is required to view online help.
- 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.
- For TCP/IP connectivity, no additional software is required.
- For APPC (CPI-C) connectivity, through the DB2 Connect server support
feature, you require SNAP-IX for Solaris V7.02.
- 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:
- Setting up an instance on a file system
- NFS mounting a file system from multiple computers, and then running DB2
on these machines using that same instance.
This configuration can cause file locking and performance
problems.
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.
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:
- Additional memory may be required for non-DB2 software that may be running
on your system.
- Additional memory is required to support database clients.
- Specific performance requirements may determine the amount of memory
needed.
- Memory requirements will be affected by the size and complexity of your
database system.
- Memory requirements will be affected by the extent of database activity
and the number of clients accessing your system.
- Memory requirements in a partitioned environment may be affected by system
design. Demand for memory on one computer may be greater than the
demand on another.
This topic lists hardware, operating system, software and communication
requirements for a partitioned DB2 server (AIX).
- Hardware requirements
- DB2 supports the following hardware:
- IBM RISC/6000
- eServer pSeries
- Operating system requirements
-
DB2 Enterprise Server Edition is available on:
- Version 4.3.3 with maintenance level 9 or later, and APARs
IY22308, Y32690, and IY33024 (32-bit only)
- Version 5.1.0 with maintenance level 2 or later, and APARs
IY31254, IY32217, IY32905, IY29345, and IY33023 (32-bit)
- Version 5.1.0 with maintenance level 2 or later, and APARs
IY31254, IY32217, IY32466, IY32905, IY29345, and IY33023, IY32466 (64-bit)
- Version 5.2.0 with APARs IY32466 and IY29345 (32-bit and
64-bit)
The following AIX file sets are required to install or run DB2 in
languages other than English:
- X11.fnt.ucs.ttf (AIX Windows Unicode
TrueType Fonts)
- xlC.rte 5.0.2.x
- For Asian languages, the following file sets are also required:
- X11.fnt.ucs.ttf_CN (for zh_CN or Zh_CN)
- X11.fnt.ucs.ttf_KR (for ko_KR)
- X11.fnt.ucs.ttf_TW (for zh_TW or Zh_TW)
- On AIX Version 4.3.3 the following file set is
required:
- On AIX Version 5.x the following file set is required:
AIX file sets 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 working 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".
- A browser is required to view online help.
- 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.
- For TCP/IP connectivity, no additional software is required.
- For APPC (CPI-C) connectivity, through the DB2 Connect server support
feature, one of the following communication products is required:
- IBM eNetwork Communications Server for AIX V5.0.3
- Bull DPX/20 SNA/20
- For LDAP (Lightweight Directory Access Protocol) support, you require an
IBM SecureWay Directory Client V3.1.1
- If you plan to use the Simple Network Management Protocol (SNMP) subagent,
you require DPI 2.0 provided by IBM SystemView Agent.
- DB2 Administration Server (DAS) requirements
- The following requirements must be met:
- A DAS must be created on each physical computer for the Control Center and
the Task Center to work properly.
- Each DAS must be created under a user ID (same as an instance).
- If the same user ID is to be used on all physical computers, then that
userID's home directory cannot be shared (cross mounted) with the other
computers.
- If a different user ID is used for each DAS, then the home directories of
the user IDs that are used can be shared (cross mounted).
- As long as a DAS is created on each computer, it does not matter
whether:
- A different user ID is used for each DAS, or
- The same user ID is used and that the user ID's home directory is not
shared.
- 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:
- Setting up an instance on a file system
- NFS mounting a file system from multiple computers, and then running DB2
on these computers using that same instance.
This configuration can cause file locking and performance
problems.
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:
- December 2001 GOLDBASE11i bundle
- December 2001 GOLDAPPS11i bundle
- patch PHSS_26560
- 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".
- A browser is required to view online help.
- Communication requirements
- APPC or TCP/IP. You can only use TCP/IP to remotely administer
databases.
- For TCP/IP connectivity, no additional software is required.
- For APPC (CPI-C) connectivity through the DB2 Connect server support
feature, the following software is required:
- SNAplus2 Link R6.11.00.00
- SNAplus2 API R.6.11.00.00
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:
- A DAS must be created on each physical machine for the Control Center and
the Task Center to work properly.
- Each DAS must be created under a userID (same as an instance).
- If the same userID is to be used on all physical machines, then that
userID's home directory cannot be shared (cross mounted) with the other
machines.
- If a different userID is used for each DAS, then the home directories of
the userIDs that are used can be shared (cross mounted).
- As long as a DAS is created on each machine, it does not matter
whether:
- A different userID is used for each DAS, or
- The same userID is used and that the userID's home directory is not
shared.
- 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:
- Setting up an instance on a file system
- NFS mounting a file system from multiple machines, and then run DB2 on
these machines using that same instance.
This configuration can cause file locking and performance
problems.
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:
- Intel 32-bit
- Intel 64-bit
- S/390 9672 generations or higher, Multiprise 3000, or eServer z-Series
- 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.
- A browser is required to view online help.
- Communication requirements
- TCP/IP is required to access remote databases.
- DB2 Administration Server (DAS) requirements
- The following requirements must be met:
- A DAS must be created on each physical machine for the Control Center and
the Task Center to work properly.
- Each DAS must be created under a userID (same as an instance).
- If the same userID is to be used on all physical machines, then that
userID's home directory cannot be shared (cross mounted) with the other
machines.
- If a different userID is used for each DAS, then the home directories of
the userIDs that are used can be shared (cross mounted).
- As long as a DAS is created on each machine, it does not matter
whether:
- A different userID is used for each DAS, or
- The same userID is used and that the userID's home directory is not
shared.
- 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:
- Setting up an instance on a file system
- NFS mounting a file system from multiple computers, and then running DB2
on these computers using that same instance.
This configuration can cause file locking and performance
problems.
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:
- Solaris 7 (32-bit) "Recommended & Security Patches" + 107226-17 +
107153-01 + 106327-10
- Solaris 7 (64-bit) "Recommended & Security Patches" + 107226-17 +
107153-01 + 106300-11
- Solaris 8 (32-bit) "Recommended & Security Patches" + 108921-12 +
108940-24 + 108434-03 and 108528-12
- Solaris 8 (64-bit) "Recommended & Security Patches" + 108921-12 +
108940-24 + 108435-03 and 108528-12
- Solaris 9 (32-bit)
- Solaris 9 (64-bit)
"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:
- Solaris 8 KU15 921040-01
- Solaris 9 FCS 912031-01
.
- 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".
- A browser is required to view online help.
- Communication requirements
- APPC, or TCP/IP. You can only use TCP/IP to remotely
administer databases.
- For TCP/IP connectivity, no additional software is required.
- For APPC (CPI-C) connectivity, through the DB2 Connect server support
feature, you require SNAP-IX for Solaris V7.02.
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:
- A DAS must be created on each physical computer for the Control Center and
the Task Center to work properly.
- Each DAS must be created under a userID (same as an instance).
- If the same user ID is to be used on all physical computer, then that
userID's home directory cannot be shared (cross mounted) with the other
computers.
- If a different user ID is used for each DAS, then the home directories of
the user IDs that are used can be shared (cross mounted).
- As long as a DAS is created on each computer , it does not matter
whether:
- A different user ID is used for each DAS, or
- The same user ID is used and that the user ID's home directory is not
shared.
- 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:
- Setting up an instance on a file system
- NFS mounting a file system from multiple computers, and then run DB2 on
these computers using that same instance.
This configuration can cause file locking and performance
problems.
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.
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:
- These memory requirements do not account for non-DB2 software that may be
running on your system.
- Specific performance requirements may increase the minimum amount of
memory needed.
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:
- x86 compatible (for example, Intel, AMD, or Cyrix).
- Intel Itanium processor (IA64) for the 64-bit version of Linux
- 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.
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.
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:
- These memory requirements are for a base of 5 concurrent client
connections. You will need an additional 16 MB of RAM per 5 client
connections.
- These memory requirements do not account for non-DB2 software that may be
running on your system.
- Specific performance requirements may determine the amount of memory
required.
To install DB2 Connect Enterprise Edition, the following requirements must
be met:
- Hardware requirements
-
- IBM RISC/6000
- eServer pSeries
- Operating system requirements
- DB2 Connect Enterprise Edition is available on:
- Version 4.3.3 with maintenance level 9 or later, and APARs
IY22308, Y32690, and IY33024 (32-bit only)
- Version 5.1.0 with maintenance level 2 or later, and APARs
IY31254, IY32217, IY32905, IY29345, and IY33023 (32-bit)
- Version 5.1.0 with maintenance level 2 or later, and APARs
IY31254, IY32217, IY32466, IY32905, IY29345, IY32466, and IY33023 (64-bit)
- Version 5.2.0 with APARs IY29345 and IY32466 (32-bit and
64-bit)
- 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:
- X11.fnt.ucs.ttf (AIX Windows Unicode
TrueType Fonts)
- xlC.rte 5.0.2.x
- For Asian languages, the following filesets are also required:
- X11.fnt.ucs.ttf_CN (for zh_CN or Zh_CN)
- X11.fnt.ucs.ttf_KR (for ko_KR)
- X11.fnt.ucs.ttf_TW (for zh_TW or Zh_TW)
- On AIX Version 4.3.3 the following fileset is
required:
- On AIX Version 5.x the following fileset is required:
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)
- For TCP/IP connectivity, no additional software is required.
- For SNA (APPC) connectivity, one of the following communication products
is required:
- Note:
- You should consider switching to TCP/IP as SNA may no longer be supported in
future releases of DB2 Connect. SNA requires significant configuration
knowledge and the configuration process itself can prove to be error
prone. TCP/IP is simple to configure, has lower maintenance costs, and
provides superior performance.
- IBM eNetwork Communications Server for AIX Version 5.0.3 or
later.
- Bull DPX/20 SNA/20
Notes:
- If you plan to use the Simple Network Management Protocol (SNMP) subagent,
you require DPI 2.0 provided by IBM SystemView Agent.
- 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.
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.
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:
- These memory requirements are for a base of 5 concurrent client
connections. You will need an additional 16 MB of RAM per 5 client
connections.
- These memory requirements do not account for non-DB2 software that may be
running on your system.
- Specific performance requirements may determine the amount of memory
required.
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:
- December 2001 GOLDBASE11i bundle
- December 2001 GOLDAPPS11i bundle
- patch PHSS_26560
- 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)
- For TCP/IP connectivity, no additional software is required.
- For SNA (APPC) connectivity, you require either SNAplus2 Link
R6.11.00.00 or SNAplus2 API
R6.11.00.00. You should consider switching to
TCP/IP as SNA may no longer be supported in future releases of DB2
Connect. SNA requires significant configuration knowledge and the
configuration process itself can prove to be error prone. TCP/IP is
simple to configure, has lower maintenance costs, and provides superior
performance.
Notes:
- If you plan to use the Simple Network Management Protocol (SNMP) subagent,
you require DPI 2.0 provided by IBM SystemView Agent.
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.
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:
- These memory requirements are for a base of 5 concurrent client
connections. You will need an additional 16 MB of RAM per 5 client
connections.
- These memory requirements do not account for non-DB2 software that may be
running on your system.
- Specific performance requirements may determine the amount of memory
required.
To install a DB2 Connect Enterprise Edition, the following operating
system, software, and communication requirements must be met:
- Hardware requirements
- Your processor can be:
- x86 compatible (for example, Intel, AMD, or Cyrix)
- Intel Itanium processor (IA64) for the 64 bit version of Linux
- S/390 9672 Generation 5 or higher, Multiprise 3000
- eServer zSeries
- 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
-
- 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.
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.
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:
- These memory requirements are for a base of 5 concurrent client
connections. You will need an additional 16 MB of RAM per 5 client
connections.
- These memory requirements do not account for non-DB2 software that may be
running on your system.
- Specific performance requirements may determine the amount of memory
required.
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:
- Solaris 7 (32-bit) "Recommended & Security Patches" + 107226-17 +
107153-01 + 106327-10
- Solaris 7 (64-bit) "Recommended & Security Patches" + 107226-17 +
107153-01 +106300-11
- Solaris 8 (32-bit) "Recommended & Security Patches" + 108921-12 +
108940-24 + 108434-03 and 108528-12
- Solaris 8 (64-bit) "Recommended & Security Patches" + 108921-12 +
108940-24 + 108435-03 and 108528-12
- Solaris 9 (32-bit)
- Solaris 9 (64-bit)
"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:
- Solaris 8 KU15 921040-01
- Solaris 9 FCS 912031-01
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
- For TCP/IP connectivity, no additional software is required.
- For APPC (CPI-C) connectivity, you require SNAP-IX for Solaris
V7.02.
- Note:
- You should consider switching to TCP/IP as SNA may no longer be supported in
future releases of DB2 Connect. SNA requires significant configuration
knowledge and the configuration process itself can prove to be error
prone. TCP/IP is simple to configure, has lower maintenance costs, and
provides superior performance.
Notes:
- 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).
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.
The following list outlines the recommended minimum memory requirements for
the different types of DB2 clients:
- The amount of memory required for the DB2 Run-Time client depends on the
operating system and the database applications that you are running. In
most cases, it should be sufficient to use the minimum memory requirements of
the operating system as the minimum requirement for running the DB2 Run-Time
client.
- To run graphical tools on an Administration or Application Development
client, you will require an additional amount of 64 MB of RAM. For
example, to run graphical tools on an Administration Client machine running
Windows 2000 Professional, you would need a minimum of 64 MB of RAM for the
operating system plus an additional amount of 64 MB of RAM for the
tools.
- Note:
- Performance may be affected if less than the recommended minimum memory
requirements are used.
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:
- X11.fnt.ucs.ttf (AIX Windows Unicode
TrueType Fonts)
- xlC.rte 5.0.2.x
- For Asian languages, the following filesets are also required:
- X11.fnt.ucs.ttf_CN (for zh_CN or Zh_CN)
- X11.fnt.ucs.ttf_KR (for ko_KR)
- X11.fnt.ucs.ttf_TW (for zh_TW or Zh_TW)
- On AIX Version 4.3.3 the following fileset is
required:
- On AIX Version 5.x the following fileset is required:
AIX filesets can be downloaded from:
http://techsupport.services.ibm.com/server/fixes
- Software requirements
-
- For LDAP (Lightweight Directory Access Protocol) support, you require an
IBM SecureWay Directory Client V3.1.1 running on AIX
V4.3.3.78 or later.
- The Java Runtime Environment (JRE) Version 1.3.1 is required
to run DB2 graphical tools, such as the Control Center. During the
installation process, if the JRE is not already installed, it will be
installed.
- If you are installing the Application Development Client, you may require
the Java Developer's Kit (JDK). During the installation process,
if the JDK is not already installed, it will be installed.
- For 64-bit systems, if you do not already have the required level
installed, you must install it from the separate CD-ROM provided.
- The DB2 Java gui tools are not provided with the DB2 Version 8 Run-Time
Client.
- If you are installing the Application Development Client, you must have a
C compiler to build SQL Stored Procedures.
- Communication requirements
-
- TCP/IP (The AIX base operating system provides TCP/IP connectivity, if
selected during install.)
- Note:
- In Version 8, DB2 only supports TCP/IP for remotely administering a
database.
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
-
- HP-UX 11i(11.11) for PA-RISC 2 with March 2002 GOLDBASE11i
and March 2002 GOLDAPPS11i bundles and patch PHSS_22535
- Software requirements
-
- The Java Runtime Environment (JRE) Version 1.3.1 is required
to run DB2 graphical tools, such as the Control Center. During the
installation process, if the JRE is not already installed, it will be
installed.
- If you are installing the Application Development Client, you may require
the Java Developer's Kit (JDK). During the installation process,
if the JDK is not already installed, it will be installed.
- For 64-bit system, the required JRE level is JRE Version
1.4.0. If you do not already have the required level
installed, you must install it from the separate CD-ROM provided.
- The DB2 Java gui tools are not provided with the DB2 Version 8 Run-Time
Client.
- If you are installing the Application Development Client, you must have a
C compiler to build SQL Stored Procedures.
- Communication requirements
-
- TCP/IP (TCP/IP is provided with the HP-UX base operating system.)
- Note:
- In Version 8, DB2 only supports TCP/IP for remotely administering a
database.
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
-
- TCP/IP (The Linux base operating system provides TCP/IP connectivity, if
selected during installation).
- Note:
- In Version 8, DB2 only supports TCP/IP for remotely administering a
database.
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
-
- Solaris Version 2.7 or later
- Note:
- Solaris Version 2.7 is required for 64-bit.
- The following patches are required for the Solaris operating environment
Version 2.7:
- Solaris 7 (32-bit) patch 106327-8
- Solaris 7 (64-bit) patch 106300-09
- Solaris 8 (32-bit) patch 108434-01 + 108528-12
- Solaris 8 (64-bit) patches 108435-01 + 108528-12
The following software is required to install DB2 on Solaris:
- Software requirements
-
- The Java Runtime Environment (JRE) Version 1.3.1 is required
to run DB2 graphical tools, such as the Control Center. During the
installation process, if the JRE is not already installed, it will be
installed.
- If you are installing the Application Development Client, you may require
the Java Developer's Kit (JDK). During the installation process,
if the JDK is not already installed, it will be installed.
- For 64-bit system, the required JRE level is JRE Version
1.4.0. If you do not already have the required level
installed, you must install it from the separate CD-ROM provided.
- The DB2 Java gui tools are not provided with the DB2 Version 8 Run-Time
Client.
- If you are installing the Application Development Client, you must have a
C compiler to build SQL Stored Procedures.
- Communication requirements
-
- TCP/IP (The Solaris Operating Environment provides TCP/IP
connectivity.)
- Note:
- In Version 8, DB2 only supports TCP/IP for remotely administering a
database.
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.
- Insert the DB2 Distributed Debugger CD.
- From the DB2 Distributed Debugger CD, run the
Windows\setup.exe command.
- 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.
- To use remote stored procedure debugging on DB2, add the
\IBMDebug\lib\dertrjrt.jar file to your system
CLASSPATH.
- Linux (Intel)
-
- Log on as root.
- Mount the DB2 Distributed Debugger CD. The Linux installation
image, DERJPICL-9-2-3.i386.rpm, is on the CD in the
\Linux directory.
- From the Linux directory, run the rpm -Uvh
DERJPICL-9-2-3.i386.rpm command.
- 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
-
- Log on as root.
- Mount the DB2 Distributed Debugger CD.
- Copy the installation files from <cdrom_path>/AIX to the
machine on which you want to install the Debugger.
- Use installp or smitty install_latest.
- If you are debugging remote stored procedures on DB2, you must add the
/usr/lpp/idebug/lib/dertrjrt.jar file to your system
CLASSPATH.
- 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.
- Log on as root.
- Mount the DB2 Distributed Debugger CD.
- The install image is in the /Solaris directory.
- Run the ./dbgsetup idebug.pkg command.
- DB2 instance owners should add /opt/ibm/IBMDebug/bin to their
PATH.
- If you are debugging remote stored procedures on DB2, you must add the
/opt/IBMdebug/lib/dertrjrt.jar file to your system
CLASSPATH.
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.
Review this entire section before installing DB2.
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:
- 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.
- 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.
- 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.
- Run the following command to start the DB2 Setup wizard:
./PRODUCT/db2setup
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.
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:
- 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"
- 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:
- Unzip the font package.
- 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.
- 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.
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
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:
- On the "Prepare the information catalog" installation panel, choose the
"Use a local database to store your information catalog" radio button.
- Click the "Next" button at the bottom of the panel.
- 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.
- 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.
- 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.
- 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:
- On the "Prepare the information catalog" installation panel, choose the
"Use a remote database to store your information catalog" radio button.
- Click the "Next" button at the bottom of the panel.
- 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.
- Click the "Next" button at the bottom of the panel to continue with the
installation.
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
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.
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.
The search facility for the DB2 Information Center requires a Java-enabled
browser and Java Plug-in for viewing Java applets.
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.
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.