Sunday, March 20, 2011

Unlocking SAP users like(SAP* & DDIC) in DB2


1.Login to db2 using db2<SID> user.

2.db2 connect to SID user sapSID using <password>

Here SID = XYZ Password = 1234
e.g db2 connect to XYZ user sapxyz using 1234

3.db2 select bname,uflag from sapxyz.usr02 where mandt='700' and bname='SAP*'

BNAME                                UFLAG
------------------------------------ ------
SAP*                                  128

  1 record(s) selected.

4.db2 update usr02 set uflag=0 where mandt='700' and bname='SAP*'
  DB20000I  The SQL command completed successfully.

db2 commit

DB20000I  The SQL command completed successfully.


1 comment:

  1. I believe field names and values need to be capitalized

    ReplyDelete