DB2/Unix old hand needs DB2/Windows help

[Tomas]

Hey all,

I've worked with DB2 for a long time, but it looks like Windows and
user management is getting the better of me.

I'm trying to set up a DB2 9 Express-C system. It's installed and
ready to go. However, no matter what I try, I can't get my user to
get the necessary privileges to do the most basic tasks.

My user is a domain user. I've made that user the member of a local
group, and I've made that local group the one pointed to by
SYSADM_GROUP in the dbm cfg. I added DB2_GRP_LOOKUP=local to the DB2
registry. Even so, I can't create databases, I can't catalog remote
databases... All that happens is that I get a SQL1092N. I can't do
much of anything and it's starting to annoy me. Could someone please
give me a hint on how to proceed?

By the way, I find it hilarious that I have the authorization to drop
and create instances, update dbm cfg, and set registry variables, but
not catalog a remote database.

thanks,

/T

[Mark A]

"Tomas" <th*****@gmail.comwrote in message
news:11**********************@64g2000cwx.googlegro ups.com...

Hey all,

I've worked with DB2 for a long time, but it looks like Windows and
user management is getting the better of me.

I'm trying to set up a DB2 9 Express-C system. It's installed and
ready to go. However, no matter what I try, I can't get my user to
get the necessary privileges to do the most basic tasks.

My user is a domain user. I've made that user the member of a local
group, and I've made that local group the one pointed to by
SYSADM_GROUP in the dbm cfg. I added DB2_GRP_LOOKUP=local to the DB2
registry. Even so, I can't create databases, I can't catalog remote
databases... All that happens is that I get a SQL1092N. I can't do
much of anything and it's starting to annoy me. Could someone please
give me a hint on how to proceed?

By the way, I find it hilarious that I have the authorization to drop
and create instances, update dbm cfg, and set registry variables, but
not catalog a remote database.

thanks,

/T

I am not sure about V9 but I believe if you install DB2 with a domain user,
you must be a domain administrator. With V8, I solved this problem by
installing as a local user, and making sure the DB2 Windows Services are
tied to the local userid.

[Tomas]

Hmm, no... I installed it using my domain user, but I'm only a local
administrator.

/T

On Mar 3, 12:52 pm, "Mark A" <[e-mail]:

"Tomas" <[e-mail] in message

news:11**********************@64g2000cwx.googlegro ups.com...

Hey all,

I've worked with DB2 for a long time, but it looks like Windows and
user management is getting the better of me.

I'm trying to set up a DB2 9 Express-C system. It's installed and
ready to go. However, no matter what I try, I can't get my user to
get the necessary privileges to do the most basic tasks.

My user is a domain user. I've made that user the member of a local
group, and I've made that local group the one pointed to by
SYSADM_GROUP in the dbm cfg. I added DB2_GRP_LOOKUP=local to the DB2
registry. Even so, I can't create databases, I can't catalog remote
databases... All that happens is that I get a SQL1092N. I can't do
much of anything and it's starting to annoy me. Could someone please
give me a hint on how to proceed?

By the way, I find it hilarious that I have the authorization to drop
and create instances, update dbm cfg, and set registry variables, but
not catalog a remote database.

thanks,

/T

I am not sure about V9 but I believe if you install DB2 with a domain user,
you must be a domain administrator. With V8, I solved this problem by
installing as a local user, and making sure the DB2 Windows Services are
tied to the local userid.- Hide quoted text -

- Show quoted text -

[Mark A]

On Mar 5, 3:05 pm, "Tomas" <[e-mail]:

Hmm, no... I installed it using my domain user, but I'm only a local
administrator.

/T

That's why it does not work properly.

[Ray]

On Mar 5, 4:05 pm, "Tomas" <[e-mail]:

Hmm, no... I installed it using my domain user, but I'm only a local
administrator.

We've always added a local user specifically for the purpose of
running the DB2 instances but we haven't installed any v9 yet.

[Tomas]

On Mar 5, 6:33 pm, "Mark A" <[e-mail]:

On Mar 5, 3:05 pm, "Tomas" <[e-mail]:

Hmm, no... I installed it using my domain user, but I'm only a local
administrator.

/T

That's why it does not work properly.

No, being a local adminstrator is enough. I'm a DBA and not a Windows
admin - there's NO WAY I could talk the Windows admins into making me
a domain admin. Much in the same way they would be unable to persuade
me to add them to the SYSADM_GROUP for a production database.

Anyway, I dropped the instance, recreated it, and re-added the
DB2_GRP_LOOKUP=local registry variable, and now I'm in business. Not
sure what I did wrong the first time - I thought I did exactly the
same stuff the second time around.

/T