Thursday, 14 August 2014

Unlock SAP User Account / Delete SAP* user in DB2

At command line:

  • db2
  • connect
  • update sapsr3.usr02 set uflag=0 where mandt='<client>' and bname='<username>'
  • delete from sapsr3.usr02 where mandt='<client>' and bname='SAP*'

Response should be:
DB20000I  The SQL command completed successfully.

Effect is immediate. No 'commit' required.

(* Assumes the schema is sapsr3)