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.
No comments:
Post a Comment