How to Unlock & Reset SAP* Password in DB2

Unlock & Reset SAP* Password in DB2 


Log in to the operating system as db2 and switch to the SQL mode.
 
Status of the SAP* user
 
Execute as following.

db2 => select BNAME, MANDT, UFLAG from .USR02 where BNAME='SAP*'

BNAME  MANDT UFLAG
------------ -----        ------
SAP*         000        0
SAP*         500        0
SAP*         900        0

 3 record(s) selected.

 Unlock SAP* on DB2

Execute the following command.

UPDATE SAPSCHEMA.USR02 set UFLAG=0 where BNAME='SAP*' and MANDT='000'
 
Reset / Delete SAP* on DB2

Execute the following command.

DELETE SAPSCHEMA.USR02 where BNAME='SAP*'and MANDT='000'


Find SAP Schema name in DB2

Log in to the operating system as db2 and switch to the SQL mode. 


select schemaname from syscat.schemata