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:

  1. Open the interactive administration program with the command:
    db2auth_admin admin

  2. Enter the name of the DB2 authentication database to connect to.

  3. 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.

  4. When the progrm asks to enter an action number, enter 2.

  5. Add the SYSADM group name (as you specified in the db2auth_key.txt file) using option #3.

  6. Add the user to the group using option #4.

  7. Exit the program using option #9.

  8. If your authorization database is remote, then also issue the following command:
    db2auth_grant_admin (your SYSADM group name here) > out.txt

  9. Keep the termianl open.