getting LIST APPLICATIONS to run...

[BobTheDatabaseBoy]

.... 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]

"BobTheDatabaseBoy" <gn*****@rcn.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

... 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 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.

if how to fix this is written down somewhere, pleeeeeeeeease
say where <G>

thx,
btdb

[BobTheDatabaseBoy]

bless you.
Fan Ruo Xin wrote:

"BobTheDatabaseBoy" <gn*****@rcn.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

... 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 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.

if how to fix this is written down somewhere, pleeeeeeeeease
say where <G>

thx,
btdb

[Dmitri]

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

"BobTheDatabaseBoy" <gn*****@rcn.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

... 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