... got: win2K, v8.1.6
login to win2K is to the network: user; bob13, domain; foo
it's a win2K domain.
i then login to my local db as db2admin. LIST APPLICATIONS
fails with security error. tells me bob13 doesn't have the
rights. bob13 has all rights in CC user maintenance. bob13
is member of Administrators in win2K on the box. i'm not logged
in to DB2 as bob13, just the box(? domain).
login to win2K, local machine: user; db2admin
now, LIST APPLICATIONS works fine. but that doesn't do
much good. there are references to "regularizing" the
windoze login and DB2, but no description of where to do that.
mention is made of making a group with SYSADM rights, then
add all users to the group, but i don't see where CC lets you
add users to groups.
DB2 starts auto. tried both LocalSystem and .\db2admin, no
difference.
if how to fix this is written down somewhere, pleeeeeeeeease
say where <G>
thx,
btdb
Fan Ruo Xin - 25 Mar 2005 01:25 GMT
> ... got: win2K, v8.1.6
>
[quoted text clipped - 16 lines]
> add all users to the group, but i don't see where CC lets you
> add users to groups.
DB2 server can't create any user or group, which is done by the OS. So you
need create NT group, add user bob13, db2admin, ... to this group (for
example - db2grp) by using NT Administrative Tool.
Then you can work on DB2 CC, open the instance parameter page (I can't run
db2 code in my laptop, so I couldn't tell the step-by-step way, hope you can
find out). Update sys_adm_grp as db2grp.
I don't think you need to recycle db2 server if you use db2 udb version8.
> DB2 starts auto. tried both LocalSystem and .\db2admin, no
> difference.
[quoted text clipped - 4 lines]
> thx,
> btdb
BobTheDatabaseBoy - 25 Mar 2005 02:01 GMT
bless you.
> > ... got: win2K, v8.1.6
> >
[quoted text clipped - 33 lines]
> > thx,
> > btdb
Dmitri - 25 Mar 2005 08:11 GMT
The "list application" command requires attachment to the instance. If no
attachment exists, "list application" performs attachment using logged user
account.
Instead of modifying accounts you can attach explicitly first:
attach to <instance> user db2admin using ....
list applications
regards,
Dmitri
> ... got: win2K, v8.1.6
>
[quoted text clipped - 25 lines]
> thx,
> btdb