Reset WCS Admin Password

We can reset by using the below query's.

Cloudscape/DB2 :

update userreg set logonpassword = '74434f61354f51593862415655304d5

268424e54723865685653356151374a2b353163506c4261363730633d20202020202

02020202020202020202020202020202020202020202020202020202020202020202

02020202020202020202020202020202020202020202020202020202020202020202

020202020202020202020' where logonid='wcsadmin';

update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin';

update userreg set status = 1 where logonid='wcsadmin';

update userreg set passwordexpired = 0 where logonid='wcsadmin';

Oracle :

update userreg set logonpassword = '74434f61354f51593862415655304d52

68424e54723865685653356151374a2b353163506c4261363730633d202020202020

20202020202020202020202020202020202020202020202020202020202020202020

20202020202020202020202020202020202020202020202020202020202020202020

20202020202020202020' where logonid='wcsadmin';

update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin';

update userreg set status = 1 where logonid='wcsadmin';

update userreg set passwordexpired = 0 where logonid='wcsadmin';

commit;

Once the above querys executed, the username and password will be reset to wcsadmin/wcsadmin

Reference : http://pic.dhe.ibm.com/infocenter/wchelp/v6r0m0/index.jsp?

topic=%2Fcom.ibm.commerce.admin.doc%2Ftasks%2Ftseresetwcsadminaccount.htm