WebSphere Commerce Portal V5.4 Solutions

376 WebSphere Commerce Portal V5.4 Solutions

Restore a DB2 database

If you need to restore a DB2 database, do the following:

1. Stop the applications that are connected to the DB2 database.

2. If a database exists on the DB2 Server that is no longer needed, drop the

database with the following command from a DB2 command window:

db2 drop db <db_name>

3. Copy the backup of the database to the DB2 Server.

4. To restore the database, enter the following from a DB2 command window:

db2 restore db <wc_dbname> from <path>

For example:

db2 restore db wc1db from c:\ibm\dbbackup

Reset a disable account

In the event that you incorrectly enter your password and the account becomes

disabled, do the following:

1. Open a DB2 command window.

2. Connect to the WebSphere Commerce instance database:

db2 connect to <db_name>

3. Enter the following DB2 command to reset the WebSphere Commerce

wcsadmin logon ID:

db2 update USERREG SET STATUS=1, PASSWORDRETRIES=0 WHERE LOGONID=’wcsadmin’