IBM Endpoint Manager, Version 9.0

Installing and configuring DB2

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

DB2 V10.1 Enterprise Server Edition: you must install this version of DB2 before installing the Endpoint Manager server. Install it on the local workstation where you want to install the Endpoint Manager 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 Endpoint Manager server ensure that the DB2 V10.1 Enterprise Server Edition has been installed and started as follows:
- If the DB2 V10.1 Enterprise Server Edition is installed locally:
  1. Switch to the local DB2 Administrative user (default: db2inst1) by running the following command:
```
su – db2inst1
```
  2. Verify that the DB2 instance is active by running the command db2start. If the DB2 instance is running, you get this message:
```
SQL1026N The database manager is already active
```
    otherwise the DB2 instance is started. You can also verify it by checking that the db2sysc process is active using the following command:
```
ps -ef | grep db2sysc
```
- If the DB2 V10.1 Enterprise Server Edition is installed remotely:
  1. Install a DB2 10.1 client locally and connect it to the DB2 10.1 server installed on the remote workstation. No additional DB2 configurations (such as the catalog of the remote database) are required.
  2. On the remote DB2, ensure that the DB2 administrative server db2admin is started to enable remote administration. To start db2admin, run the following commands:
```
# su – dasusr1
# $ db2admin start
```
DB2 V10.1 Workgroup Server Edition: you can install this version of DB2 either before installing the Endpoint Manager server by following the previous steps or together with the Endpoint Manager server installation after downloading it. You download it to the local workstation where you want to install the Endpoint Manager server. During the Endpoint Manager 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.

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

To automatically start the DB2 instance after a reboot, perform the following steps:

Run the following command::

/opt/ibm/db2/V10.1/bin/db2iauto -on db2inst1

or create a shell script in the /etc/init.d directory, such as db2auto.sh, containing the following code:

#! /bin/sh	
for i in `/opt/ibm/db2/V10.1/bin/db2ilist`;
do	
su - $i -c "db2start"
done

Give execution rights 3 to the script and add it to the Linux Startup Applications from System ->Preferences->Startup Applications.

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

Feedback