Unlock & Reset SAP* Password in DB2

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

Status of the SAP* user

Execute as following.

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

BNAME        MANDT UFLAG
------------ ----- ------
SAP*         001        0
SAP*         066        0
SAP*         000        0
SAP*         100        0
SAP*         200        0

  5 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'

Note

• SAPSCHEMA is the database schema.
• MANDT is the client number.