Home » DB2 » Unlocking SAP users like(SAP* & DDIC) in DB2 — Emergency only

Unlocking SAP users like(SAP* & DDIC) in DB2 — Emergency only

Pages

March 2015
M T W T F S S
« Nov   Apr »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

RSS Link

  • An error has occurred; the feed is probably down. Try again later.

Twitter Updates

Blog Stats

  • 345,582 hits

Archives

Pengunjung


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. jtxmisc says:

    info yang bagus , mantap banget ini infonya🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: