How to recover db2 instance user's privilege?

[Mockey Chen]

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

[Norbert Munkel]

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

[Norbert Munkel]

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