Options for installing the database software

You must determine how you will install the database system for each database, and how you will create the databases within the database system.

The procedure for setting up IBM® InfoSphere® Information Server databases differs depending upon the database system that you use and the location of the database system.

To use a clustered database configuration for high availability, you must first install the database system and configure the cluster. Then, use the scripts on the InfoSphere Information Server installation media to create the databases within the instance. When you run the InfoSphere Information Server installation program, specify the database system for the installation. See Pre-installing the metadata repository database for more information about installing databases.

IBM Db2

There are two major options to configure the Db2 11.1 Enterprise Server Edition database:

Installing the Db2® database system by using the InfoSphere Information Server installation program

Use the InfoSphere Information Server installation program to install Db2 11.1 Enterprise Server Edition on the target computer and create the database within it. Db2 is bundled with InfoSphere Information Server. Within the installation program, select the Repository tier installation option to install Db2 and create the databases.

Note: If you want to use Db2 with IBM InfoSphere Information Server on an AIX Power7 High Availability system, you must preinstall Db2. You cannot install the Db2 server that is bundled with the InfoSphere Information Server installation program.

Preinstalling the Db2 database system

Before you run the installation program, preinstall the Db2 database system (any supported version) on the target computer or another computer. Then, create the databases by using one of the following methods:

If the Db2 instance is located on the target computer, use the InfoSphere Information Server installation program to create the databases within the instance. Within the installation program, select the Repository tier installation option to create the databases.
If the Db2 instance is not located on the target computer, create the databases within the instance before running the InfoSphere Information Server installation program. To create the databases, use the scripts that are provided with the InfoSphere Information Server software.

The following table summarizes the different installation options for IBM Db2 databases:

Table 1. Summary of database system installation and database creation options for IBM Db2 databases
Configuration	Database system installation options	Database creation options
Db2, non-clustered configuration	You can preinstall Db2 before you run the InfoSphere Information Server installation program. If you don't preinstall Db2, you can use the InfoSphere Information Server installation program to install it.	Use either of the following methods: Use the InfoSphere Information Server installation program. Use the scripts on the InfoSphere Information Server installation media.
Db2, clustered configuration	Preinstall, and then create the cluster.	Use the scripts on the InfoSphere Information Server installation media.
Db2, high availability disaster recovery (HADR) configuration (a supported version earlier than what is bundled with InfoSphere Information Server).	Preinstall, and then create the HADR configuration.	Use either of the following methods to create the database on the primary node: Use the InfoSphere Information Server installation program. Use the scripts on the InfoSphere Information Server installation media.
Db2, high availability disaster recovery (HADR) configuration (the same version that is bundled with InfoSphere Information Server).	Use either of the following methods: Use InfoSphere Information Server installation program to install Preinstall before you run the InfoSphere Information Server installation program	Use either of the following methods to create the database on the primary node: Use the InfoSphere Information Server installation program. Use the scripts on the InfoSphere Information Server installation media.

Other database types

Set up the databases by using one of the following methods:

Preinstall the database system: Create the databases within the database system before running the InfoSphere Information Server installation program. To create the databases, use scripts that are provided with the InfoSphere Information Server software.
Use an existing database system: Before you run the InfoSphere Information Server installation program, create the databases within the database system by using scripts that are provided with the InfoSphere Information Server installation media.

In either case, you do not use the Metadata Repository tier option when you run the installation program.

The following table summarizes the different installation options for other supported databases:

Table 2. Summary of database system installation and database creation options for Oracle and Microsoft databases
Configuration	Database system installation options	Database creation options
Oracle database system (any supported version), non-clustered configuration	Preinstall before you run the InfoSphere Information Server installation program.	Use scripts on InfoSphere Information Server installation media.
Oracle Real Application Clusters (RAC) cluster (any supported version)	Preinstall, and then create the RAC setup.	Use the scripts on the InfoSphere Information Server installation media.
Microsoft SQL Server database system (any supported version), non-clustered configuration	Preinstall before you run the InfoSphere Information Server installation program.	Use the scripts on the InfoSphere Information Server installation media.