Resetting the wcsadmin user password

It is quite obvious that you might forget the password for the wcsadmin user if you are not using it quite oftenly and we have to do a reset of the password for wcsadmin user.

Execute the following queries to reset the wcsadmin password

Cloudscape/DB2 : 

update userreg set logonpassword = x'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;

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

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