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

How to recover db2 instance user's privilege?

P: n/a
I installed a DB2 instance named db2inst1, while the user
db2inst1's DBA privilege revoked by some one by accident.
I want to recove the db2inst1's DBA privilege,
then what should I do?


--
Regards.
Mockey Chen
Email: mo*********@gmail.com
Apr 11 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Mockey Chen schrieb:
I installed a DB2 instance named db2inst1, while the user
db2inst1's DBA privilege revoked by some one by accident.
I want to recove the db2inst1's DBA privilege,
then what should I do?


There are three possibilities what might have happened:

1. The user "db2inst1" has been removed from the (operating system)
group configured as SYSADM_GROUP in the database managers configuration.

2. The (operating system) group has been removed.

3. The accident included something like "db2 update dbm cfg using
SYSADM_GROUP=somegroup" and db2inst1 is not member of "somegroup"

Conclusion:

1.

If you can still remember which group was configured as "SYSADM_GROUP",
just add db2inst1 to that group (create the group if necessary, eg
db2iadm1). Unfortunately "get dbm cfg" will not work to figure that out
due to limited privileges.

OR

2.

Drop the instance, recreate it and catalog your databases again.
Restoring them should not be necessary (although a fresh backup always
gives a better feeling).

Hint: db2cfexp and db2cfimp are very nice tools to backup/restore and
even edit the (instance)-configuration.

regards,

Norbert
Apr 11 '06 #2

P: n/a
Hi again,

Mockey Chen wrote:
I re-create the instance, and how to know the database name through
the DB2 data directory?


Well, you should at least remember which database you are missing. E.g.
If it was "test" something like

db2 catalog database test

should do.

If you _really_ can't remember the missings database Name, a look at the
name of the corresponding Backup-Image should help.

Best regards,

Norbert
Apr 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.