Installing IBM Db2 for i2 Analyze

i2 Analyze supports using IBM Db2 as its database management system. This topic describes how to install Db2 for use with i2 Analyze.

Location

If you are creating a production deployment, you can install Db2 in any location. When you install Db2, record the location of the installation directory because you must specify this location in the deployment toolkit before you can deploy i2 Analyze.

If you are creating an example deployment, install Db2 in the following location:

  • For Windows: C:\Program Files\IBM\SQLLIB

  • For Linux: /opt/ibm/db2/<Db2_version>

Features and language

In all deployments, you must ensure that the following features are installed:

  • Spatial Extender server support

  • Spatial Extender client

For Linux deployments, if you are deploying with a schema that contains non-English characters, ensure that the operating system's LANG environment variable is set to the locale of the non-English characters. You can only deploy i2 Analyze with a Db2 instance where the DB2_WORKLOAD environment variable is not set and the database is row-organized. If you have an existing Db2 instance where DB2_WORKLOAD is set or the database is column-organized, you must create a Db2 instance with the supported configuration and deploy i2 Analyze with it. For more information about the DB2_WORKLOAD environment variable, see System environment. For more information about column-organized databases, see Setting the default table organization.

Users

On Windows, Db2 creates a Windows user account (db2admin), and two Windows groups (DB2ADMNS, DB2USERS). To work successfully with Db2, ensure that your Windows user account is a member of the DB2ADMNS >Windows group.

On Linux, Db2 creates an Administration Server user (dasusr1) and group (dasadm1), an instance-owning user (db2inst1) and group (db2iadm1), and a fenced user (db2fenc1) and group (db2fadm1). To work successfully with Db2, ensure that the user that runs the deployment script is a member of the dasadm1 and db2iadm1 groups.

Make a note of any user names and passwords that are specified during the installation process.

Note: In all scenarios, the user that you use to run the deployment scripts must have permission to create and modify the database. For more information, see CREATE DATABASE command".

Post-install

After you install Db2 for the Information Store, you must enable the administrative task scheduler and set the code page on the Db2 installation:

  • On the command line, navigate to the SQLLIB\bin directory of your Db2 installation. On Linux, navigate to the db2inst1/sqllib/bin directory.

  • To enable the administrative task scheduler, run the following command: db2set DB2_ATS_ENABLE=YES

  • To set the code page for UTF-8 encoding, run the following command:

    db2set DB2CODEPAGE=1208

For more information about installing Db2, see Installing Db2 database servers.

If you installed IBM Db2 on Linux, ensure that the operating system user process resource limits (ulimits) meet the Db2 recommended values. For more information about the recommended ulimits, see Operating system user limit requirements (Linux and UNIX).

Collation

In Db2, the collation settings that determine the case- and accent-sensitivity of comparisons in a database (for example, whether Cafe matches café) are set at creation and cannot be changed without re-creating the database.

Important: Before any deployment of i2 Analyze with the Chart Store or the Information Store, read the documentation about the Collation setting in InfoStoreNamesDb2Server.properties and change the default value if you need to.

Remote Db2 database storage

If you plan to deploy i2 Analyze with remote database storage, you must install Db2 on your database server, and Db2 or IBM Data Server Client on the application server. Install Db2 according to the previous instructions; if you are using IBM Data Server Client, also ensure that Spatial Extender client support is installed. For more information about IBM Data Server Client, see Installing IBM Data Server drivers and clients.

The instance of Db2 or IBM Data Server Client on the application server must be the same version level as the instance of Db2 on the database server. For example, if the instance of Db2 on your database server is version 11.1, the instance of Db2 or IBM Data Server Client on the application server must also be version 11.1.

High availability

When you install Db2 in a deployment that uses HADR, the following must be true:

  • The version of Db2 installed on the primary and standby servers must be the same.

  • Install Db2 on all servers according to the previous information.

  • Db2 must be installed with the same bit size (32 or 64 bit) for both the primary and standby servers.

  • The primary and standby databases must have the same database name.

  • The primary and standby databases must be in difference instances.

  • The amount of space allocated for log files must be the same on both the primary and standby databases.

For more information about the Db2 requirements, see High availability disaster recovery (HADR) support. For more information about the Db2 HADR feature, see High availability disaster recovery (HADR).