multiple DB2 instances under one OS userid?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sthand - 11 Jan 2005 18:30 GMT

It appears that normally each DB2 instance runs under a separate
Unix/Linux userid. Is it possible to run *multiple* DB2 instances
under a *single* userid?

If so, how can you identify which instance each top-level db2sysc
process is associated with?

I've traced the db2_local_ps, db2nps, and db2gdeps commands without
finding a solution.

ADVthanksANCE
Steve

Reply to this Message

Ian - 11 Jan 2005 19:52 GMT

> It appears that normally each DB2 instance runs under a separate
> Unix/Linux userid. Is it possible to run *multiple* DB2 instances
> under a *single* userid?

I don't think it's possible, but then again why would you want to?

The point of having a unique ID per instance is to prevent instances
from trouncing on each other. Similar to the idea of using a separate
ID for fenced processes.

Reply to this Message

sthand - 11 Jan 2005 21:32 GMT

I think you're right, it's not possible. I tried to do it with the
db2isetup utility and got the following error message: "The user you
selected already has an sqllib directory in their home directory. This
user cannot be used as the instance-owning user."

I was exploring this because it was reported to me that a particular
DB2 machine was set up this way, but they must have been wrong.
Thanks,
Steve

Reply to this Message

dotyet - 11 Jan 2005 23:49 GMT

I saw a similar question in a quiz i was undergoing:

How many UDB Instances can a single userid own at anytime on a single
system?

a) None
b) One
c) More than One
d) As defined in db2 "get dbm cfg"
Correct answer is b).

regards,
dotyet

Reply to this Message