Verifying the status of database schema users accounts

This topic explains how to verify the database schema user’s accounts are not locked.

1. Log in as oracle user.
2. Log into SqlPlus by entering the following command:

   $ sqlplus "/as sysdba"

3. Verify if any database schema user account is locked by using the following command:

   $ select username, account_status from dba_users where username like 'PV%';

4. If any user account is in the LOCKED (TIMED) status, run the following command to unlock:

   $ alter user <DB_USER> account unlock;

   For example:

   $ alter user PV_GUI account unlock;

5. Log in as db2 user.
6. Connect to the DB2 database by running the following command:

   $ clpplus -nw <DB_USER_ROOT>_ADMIN/<DB_ADMIN_PASSWORD>@localhost:60000/<SID>

   For example:

   $ clpplus -nw PV_ADMIN/PV@localhost:60000/PV

7. Verify if any database schema user account is locked by using the following command:

   $ select userid,account_status from db2auth.users where account_status='L';

8. If any user account is in the LOCKED status, run the following command to unlock:

   $ update db2auth.users set account_status='N' where userid=<USERID>;