Setting the Administrator User and Group
The next steps are adding the administrator user name to the USERS table, adding the SYSADM group name to the GROUPS table, and making the administrator user a member of the newly added SYSADM group by adding the information to the GROUP_MEMBERSHIPS table.
Steps:
- Open the interactive administration program with the command:
db2auth_admin admin
- Enter the name of the DB2 authentication database to connect to.
- This is the name of the database which you specified in the db2auth_key.txt file.
- In the screenshot to the right, 'db2auth' is the name of the DB2 authentication database.
- If the DB2 authentication database is local, then press the Enter key without entering a userid when it asks for the connection userid.
If it is remote, then enter the userid.
- When the program asks to enter an action number, enter 2.
- This will let you add the system administrator's name (as you specified in the db2auth_key.txt file)
- The screenshot to the right uses the name 'db2admin' as the system administrator.
- Add the SYSADM group name (as you specified in the db2auth_key.txt file) using option #3.
- Add the user to the group using option #4.
- Exit the program using option #9.
- Keep the terminal open.