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.
Facebook
