Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Windows DB2 v8 - v9 Personal Edition Migration Security Issues

Status
Not open for further replies.

HanbingL

IS-IT--Management
Dec 4, 2007
7
US
Hello,

Our developers use Db2 v8.1 Personal Edition we want to migrate these boxes to V9.1 Personal Edition.

I am stuck on Security problems. In v8.1 we Created 2 local groups DB2USERS and DB2ADMNS; 2 local Users: DB2ADMIN, DEVUSER. Then we added the developer's Domain/LOGIN ID to both groups with local Administrators right.

This is no problem with V8.1, we can create databases, restore databases with no problem.

We then migrated to v9.1 PE, I've done the migration for Instance and all the databases and everything seem to OK. However, when we try to restore databases it failed because the Developer domain account do not have the authority.

I've update the dbm config to include DB2ADMNS and DBGroupLook for Local only:

db2set DB2_GRP_LOOKUP=local
Db2 update dbm cfg using sysadm_group DB2ADMNS

I still get the same problem.

Please help, thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top