Unlock & Reset SAP* Password in DB2



Share this article :

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.

Tags:

Related posts

Kick a User Session in SAP
Delete SAP Client at OS Level
SCUL: CUA Process Distribution Logs
SM59: Incomplete Logon Data
© 2017 ITsiti. All Rights Reserved
Powered by KEEM