what are the db2 users db2fenc1 and dasusr1 for ?

[srihari]

Thanks guys for answering my previous question.

I created the users according to db2 installation manual as db2fenc1(
fenced user) and dasusr1( administration server user) during
installation but all the configuration using control center, im doing
thru the user db2inst1(instance user).

so please tell me what are the db2 users db2fenc1 and dasusr1 for ?

[Darin McBride]

srihari wrote:

I created the users according to db2 installation manual as db2fenc1(
fenced user) and dasusr1( administration server user) during
installation but all the configuration using control center, im doing
thru the user db2inst1(instance user).

so please tell me what are the db2 users db2fenc1 and dasusr1 for ?

Fenced user and administration server user. Er, you want something a
bit more explicit? ;-)

The fenced user is a user under which some stored procedures ("fenced"
stored procedures) can run to have reduced operating system authority.
This can help prevent fenced stored procedures from overwriting
instance files since the OS will prevent it.

The DB2 administration server (DAS) user is the user under which the
DAS service runs. It is this service which you are really using with
the Control Center. In this case, the service is set up for the
opposite reasons from the fenced user: it's to prevent db2inst1 from
overwriting your admin configuration.

[Knut Stolze]

Darin McBride wrote:

The fenced user is a user under which some stored procedures ("fenced"
stored procedures) can run to have reduced operating system authority.
This can help prevent fenced stored procedures from overwriting
instance files since the OS will prevent it.

Also, the stored procedures and UDFs don't have access to the DB2 address
space and, thus, a malicious or buggy function cannot crash the database
engine. I trusted (not fenced) UDF/SP has a much better chance to do that,
even though it's not so easy there either. ;-)

--
Knut Stolze
Information Integration
IBM Germany / University of Jena