Adding your user ID to the DB2ADMNS and DB2USERS user groups (Windows)

 

After successfully completing a DB2® installation, you now have to add users to the DB2ADMNS or the DB2USERS groups for users that need to run local DB2 applications and tools on the machine. The DB2 installer creates two new groups. You can either use a new name or accept the default names. The default group names are DB2ADMNS and DB2USERS.

Prerequisites

To add users to the appropriate group:

  1. Click Start and select Run.

  2. Type lusrmgr.msc and click OK.

  3. Select Local Users and Groups.

  4. Select Users.

  5. Select the user you want to add.

  6. Click Properties.

  7. Click the Member Of tab.

  8. Click Add.

  9. Select the appropriate group.

  10. Click OK.

If you did the install and chose not to enable the new security feature you can still do so post-install by running the db2extsec.exe command. Adding a user to a group takes effect the first time the user logs on after the user has been added. For example, if you add you user ID to the DB2ADMNS group, you need to log out and then log in again for this change to take effect.

Parent topic: DB2 servers and IBM data server clients

Related concepts
Extended Windows security using DB2ADMNS and DB2USERS groups

Related reference
Required user accounts for installation of DB2 server products (Windows) db2extsec - Set permissions for DB2 objects command