Hi All

I have a question, can you please guys guide me on how to implement it:

We have a set of DB2 installation in different servers.
We need to administer it using our own domain user IDs. For example,
when I login to a DB2 server with my NT domain ID and password, I
should be able to do the DB2 database activities.

My NT domain ID is a power user , not an administrator ID. Our policy
will not allow as to be a Administrator.

I added this domain ID to the DB2 servers DB2ADMIN group, but I cannot
do the database administration..

So can u guys help me on this..

Regards
Santhosh

First, you need to setup a group (name like DB2SUPER) in NT domain.
Second, update your db2 dbm cfg
(SYSADM_GROUP)
(SYSCTRL_GROUP)
(SYSMAINT_GROUP)
(SYSMON_GROUP)
to the group y created

Santhosh wrote:
> Hi All
>
> I have a question, can you please guys guide me on how to implement it:
>
> We have a set of DB2 installation in different servers.
> We need to administer it using our own domain user IDs. For example,
> when I login to a DB2 server with my NT domain ID and password, I
> should be able to do the DB2 database activities.
>
> My NT domain ID is a power user , not an administrator ID. Our policy
> will not allow as to be a Administrator.
>
> I added this domain ID to the DB2 servers DB2ADMIN group, but I cannot
> do the database administration..
>
> So can u guys help me on this..
>
> Regards
> Santhosh

That will work. By the way, if you are in the SYSADMIN group you have all
the authorities that SYSCONTROL, SYSMAINT, SYSMON would acquire.
Please note, that by not being a local administrator on the platform you wil
still NOT be able to create/drop instances and/or install DB2 or fixpacks.
Those require local administration authority.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<shenanwei@gmail.com> a écrit dans le message de news:
1149172944.054171.228670@g10g2000cwb.googlegroups. com...
> First, you need to setup a group (name like DB2SUPER) in NT domain.
> Second, update your db2 dbm cfg
> (SYSADM_GROUP)
> (SYSCTRL_GROUP)
> (SYSMAINT_GROUP)
> (SYSMON_GROUP)
> to the group y created
>
> Santhosh wrote:
>> Hi All
>>
>> I have a question, can you please guys guide me on how to implement it:
>>
>> We have a set of DB2 installation in different servers.
>> We need to administer it using our own domain user IDs. For example,
>> when I login to a DB2 server with my NT domain ID and password, I
>> should be able to do the DB2 database activities.
>>
>> My NT domain ID is a power user , not an administrator ID. Our policy
>> will not allow as to be a Administrator.
>>
>> I added this domain ID to the DB2 servers DB2ADMIN group, but I cannot
>> do the database administration..
>>
>> So can u guys help me on this..
>>
>> Regards
>> Santhosh
>

If db2admins is a local Windows group, you must configure DB2 to actually
use it:
db2set -g DB2_GRP_LOOKUP=LOCAL

"Santhosh" <kollam68@yahoo.com> wrote in message
news:1149169559.840701.324450@c74g2000cwc.googlegr oups.com...
> Hi All
>
> I have a question, can you please guys guide me on how to implement it:
>
> We have a set of DB2 installation in different servers.
> We need to administer it using our own domain user IDs. For example,
> when I login to a DB2 server with my NT domain ID and password, I
> should be able to do the DB2 database activities.
>
> My NT domain ID is a power user , not an administrator ID. Our policy
> will not allow as to be a Administrator.
>
> I added this domain ID to the DB2 servers DB2ADMIN group, but I cannot
> do the database administration..
>
> So can u guys help me on this..
>
> Regards
> Santhosh
>