By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

DB2/Unix old hand needs DB2/Windows help

P: n/a
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

Mar 3 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/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.
Mar 3 '07 #2

P: n/a
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" <nob...@nowhere.comwrote:
"Tomas" <thal...@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.- Hide quoted text -

- Show quoted text -

Mar 5 '07 #3

P: n/a
On Mar 5, 3:05 pm, "Tomas" <thal...@gmail.comwrote:
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.

Mar 6 '07 #4

P: n/a
Ray
On Mar 5, 4:05 pm, "Tomas" <thal...@gmail.comwrote:
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.

Mar 6 '07 #5

P: n/a
On Mar 5, 6:33 pm, "Mark A" <m00...@yahoo.comwrote:
On Mar 5, 3:05 pm, "Tomas" <thal...@gmail.comwrote:
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

Mar 6 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.