How to unlock the admin user in Netezza Database?

Issue:
we had faced issue where we unfortunately locked the admin user on Netezza and unable to conenct to NZSQL,NZADMIN and even aginity work bench.


User wrongly updated the system table .
update _t_user set uselocked=TRUE where usename='ADMIN';

because of the above admin user locked out and its throwing the  error "access denied".

SYSTEM.ADMIN(ADMIN)=> select uselocked from _t_user where USEname='ADMIN1';
 USELOCKED
-----------
 t
(1 row)

Solution:
we have special command to reset the admin  user and it worked.


nzsql -admin -c "alter user admin reset account" ;

SYSTEM.ADMIN(ADMIN)=> select uselocked from _t_user where USEname='ADMIN1';
 USELOCKED
-----------
 f
(1 row)