If a WebSphere Commerce account gets locked or disabled
for some reason, an administrator can unlock or enable the account.
Procedure
- Connect to your WebSphere Commerce database.
- Run the following SQL statements:
UPDATE USERREG SET STATUS=1, PASSWORDRETRIES=0 WHERE LOGONID='logonId';
commit;
where logonId is the user ID of
the account that you want to reset (for example, wcsadmin
).
Note: To enter SQL statements, you can use either the DB2/400
Query Manager and the SQL development kit, or you can use System i
Navigator. To use System i Navigator to perform database queries:
- Start System i Navigatorfrom the PC where it is installed.
- Expand the iSeries system. Expand Databases, right-click the Relational
Database, and select Run SQL Scripts. The Run
SQL Scripts window opens.
- From the Connection menu, select JDBC Setup.
Click the Server tab.
- In the Default libraries field, erase any existing values and
enter the name of the database schema of your instance. By default
the schema name is the name of the instance. Click OK to
save your changes.
- Type the preceding SQL statement in the window.
- Disconnect from the database.