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=