Installing and configuring DB2

Depending on which version of DB2 you want to install, you install DB2 either before installing the BigFix server or at the same time:

DB2 V10.5 Enterprise Server Edition / V11.5 GA / 11.5.4 / 11.5.5 / 11.5.6 / 11.5.7 / 11.5.8 Standard Edition: if you want to install the Enterprise Server Edition you must install this version of DB2 before installing the BigFix server.

Note: Starting from Patch 14, the DB2 Standard Edition V11.5 GA is also supported. For more details, see BigFix Server - Support for DB2 11.5 GA.

Note: Starting from Patch 17, the DB2 Standard Edition V11.5.4 / V11.5.5 / V11.5.6 / V11.5.7 / V11.5.8 are also supported.

Install it on the local workstation where you want to install the BigFix server or on a remote workstation. For information about how to install and verify DB2 server installation on Red Hat Enterprise Linux server 64-bit, see DB2 servers and IBM data server clients. Before installing the BigFix server, ensure that the DB2 V10.5 Enterprise Server Edition / V11.5 GA / 11.5.4 / 11.5.5 / 11.5.6 / 11.5.7 / 11.5.8 Standard Edition was installed and started as follows:
- If DB2 V10.5 Enterprise Server Edition / V11.5 GA / 11.5.4 / 11.5.5 / 11.5.6 / 11.5.7 / 11.5.8 Standard Edition is installed locally:
  1. Ensure that the DB2 instance is up and running and that the DB2 administrative server is started. If you configured DB2 to use the default user names, run the following commands:
```
su - db2inst1
db2start
exit
```
  2. You can also verify that the DB2 instance is running by checking that the db2sysc process is active using the following command:
```
ps -ef | grep db2sysc
```
- If DB2 V10.5 Enterprise Server Edition / V11.5 GA / 11.5.4 / 11.5.5 / 11.5.6 / 11.5.7 / 11.5.8 Standard Edition is installed remotely:
  1. Install a DB2 V10.5 / V11.5 GA / 11.5.4 / 11.5.5 / 11.5.6 / 11.5.7 / 11.5.8 client on the workstation from where you run the BigFix server installation. The actual product you need to install is IBM Data Server Client and its product identifier is "db2client". The port of the remote DB2 database (default 50000) must be reachable by the workstation where the installation is running. No additional DB2 configurations (such as the catalog of the remote database) are required.
    Note:
    To use a remote database for BigFix, ensure you provide the following information in the installation procedure:
    
    The remote DB2 node
    
    The DB2 port number
    
    The user name of the local DB2 instance owner for the remote DB2 client and the remote DB2 server.
    Important: The DB2 instance names used to install the BES Root Server cannot contain the following special characters:
    blanks, tabs (\t), returns (\n) and ; & | " ' < >.
    The DB2 password used to install the BES Root Server cannot contain the following special characters:
    blanks, tabs (\t), returns (\n) and $ " ; `.
    To install the DB2 client you can run the installation wizard or the silent installation with a response file. For additional details, see Installation methods for IBM data server clients.
  2. On the remote DB2, ensure that the DB2 instance is up and running and that the DB2 administrative server is started. If you configured DB2 to use the default user names, run the following commands:
```
su - db2inst1
db2start
exit
```
DB2 V10.5 Workgroup Server Edition: This is the DB2 version included in the BigFix installation package. Depending on the BigFix installation package you download, you can install this version of DB2 either before installing the BigFix server by following the previous steps or together with the BigFix server installation after downloading it. You download it to the local workstation where you want to install the BigFix server. During the BigFix server installation, you must provide the following information:

DB2 Setup Location

The path where you downloaded the DB2. The default is ../wser/db2setup.

DB2 Administrative User Password

The password of the DB2 Administrative user. When setting this password, use only ASCII characters.

All the steps to configure DB2 are then performed by the BigFix server installation program.

Note: To successfully install the BigFix server on Linux systems, ensure that you unset the DB2 registry variable DB2_COMPATIBILITY_VECTOR. This variable should be set to null.

For information about database requirements, see Installation requirements for DB2 database products and Database requirements.