60 IBM Enterprise Workload Manager
3.3 Enabling DB2 Universal Database for ARM
Instrumenting DB2 Universal Database on each operating system platform is done in a very
similar way, but there are some differences. Therefore, we describe the steps for each
platforms separately.
AIX
Instrumenting DB2 Universal Database on AIX includes these steps:
1. Set AIX authorization attributes.
2. Set DB2 variable.
Set AIX authorization attributes
On AIX, the ARM platform support uses the native OS security model. In order for an
application to ARM register itself, you have to add two capabilities,
CAP_ARM_APPLICATION and CAP_PROPAGATE, to the user profile of the instance owner
who runs the application. The root user automatically has all of the capabilities but not the
DB2 instance owner, for example, db2inst1. To provide the capabilities to the DB2 instance
owner:
1. Log in as root user.
2. Start a terminal session.
3. Add the capabilities to the DB2 instance owner ID db2inst1 using chuser and verify it
using lsuser. Follow the sequence shown in Example 3-1.
Example 3-1 Add ARM related capabilities to user db2inst1
root@ewlm4:/> chuser “capabilities = CAP_ARM_APPLICATION,CAP_PROPAGATE” db2inst1
root@ewlm4:/> lsuser db2inst1
db2inst1 id=106 pgrp=db2grp1 groups=db2grp1,staff,dasadm1 home=/home/db2inst1 sh
ell=/usr/bin/ksh login=true su=true rlogin=true daemon=true admin=false sugroups
=ALL admgroups= tpath=nosak ttys=ALL expires=0 auth1=SYSTEM auth2=NONE umask=22
registry=files SYSTEM=compat logintimes= loginretries=0 pwdwarntime=0 account_lo
cked=false minage=0 maxage=0 maxexpired=-1 minalpha=0 minother=0 mindiff=0 maxre
peats=8 minlen=0 histexpire=0 histsize=0 pwdchecks= dictionlist= capabilities=CA
P_ARM_APPLICATION,CAP_PROPAGATE fsize=-1 cpu=-1 data=491519 stack
=32767 core=-1 rss=-1 nofiles=2000 time_last_login=1086381962 tty_last_login= ho
st_last_login=ewlm4 unsuccessful_login_count=0 roles=
4. Verify the user’s capabilities at the /etc/security/user file as shown in Example 3-2.
Verify operating system
instrumentation
X
2
X
2
X
2
Verify communication between
domain manager and managed server
X
2
X
2
X
2
X
2
1
Refer to 2.4, “EWLM configuration in our ITSO environment” on page 32, 2.5, “Installing the domain manager on other
operating systems” on page 50 and 4.1, “EWLM Control Center overview” on page 78 for details.
2
Refer to 2.4, “EWLM configuration in our ITSO environment” on page 32 and 2.6, “Configuring managed servers on
other operating systems” on page 54 for details.
Host name ewlmdm1 ewlm1 ewlm2, ewlm3 ewlm4
Role Domain manager Web server Application server Database server