HP Enterprise Cluster Master Toolkit User Guide (5900-2131, December 2011)

the Serviceguard user manual available at http://www.hp.com/go/hpux-serviceguard-docs
-> HP Serviceguard.
2. Make sure that the minimum hardware and the software prerequisites are met before the
product installation is initiated. The latest installation requirements are listed on IBM web site:
http://www-306.ibm.com/software/data/db2/9/sysreqs.html.
3. Use the DB2 Setup Wizard or db2install script to install the database server deferring the
instance creation. The destination directory for DB2 server must be the same on all cluster
nodes. DB2 installation must be done by a root user.
4. IBM provides a utility called /opt/IBM/DB2/V9.5/bin/db2osconf in determining the
minimum recommended kernel values for DB2 server. As root, run /opt/IBM/DB2/V9.5/
bin/db2osconf or /opt/IBM/DB2/V9.7/bin/db2osconf utility to aid administrators
in determining the minimum recommended kernel values for the DB2 server. Login as root,
modify the kernel parameters using kctune command or kcweb (graphical browser) based
utility. For example, to modify the value of maxuprc execute as root the following:
root@hp46t191:/home/root>kctune maxuprc=256.
For more information regarding the recommended kernel values for DB2 server, see IBM DB2
Information center.
https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp
https://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
5. Create required users and groups on all cluster members.
To create required groups using command line utilities, execute as root:
root@node1/]> groupadd -g 400 db2iadm1
[root@node1/]> groupadd -g 500 db2fadm1
[root@node1/]> groupadd -g 600 dasadm1
To create required users using command line utilities, execute as root:
[root@node1/]> useradd -u 400 -g db2iadm1 -m -d /home/payroll_inst payrollinst
[root@node1/]> useradd -u 500 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1
[root@node1/]> useradd -u 600 -g dasadm1 -m -d /home/dasusr1 dasusr1
see useradd (1M) and groupadd (1M) man pages for additional details.
NOTE: The user names, user ID and groups shown here are for illustration purposes only.
6. Create a DB2 instance using db2icrt. The DB2 instances should be created on shared volume
group.
[root@node1 /]><DB2_installation_dir>/instance/db2icrt -a client -u db2fenc1 payroll_inst
7. In case of logical multi-partitioned database installation, edit DB2 node configuration file
db2nodes.cfg in the exported instance owner home directory to define the database
partitions that participate in a DB2 instance.
For example:
[payroll_inst@node1 ~]> vi /home/payroll_inst/sqllib/db2nodes.cfg
0 node1 0 node1
1 node1 1 node1
8. In case of physical multi-partitioned database installation, edit the DB2 node configuration
file db2nodes.cfg in the exported instance owner home directory to define the physical
and logical database partitions that participate in a DB2 instance.
For example:
[payroll_inst@node1 ~]> vi /home/payroll_inst/sqllib/db2nodes.cfg
0 node1 0 node1
1 node1 1 node1
72 Using the DB2 database Toolkit in a Serviceguard Cluster in HP-UX