SAP Lock Value In USR02

SAP Lock Value In USR02 table

We use USR02 table for checking the status of an user whether user is locked or not.

There are 6 type of values are there.

0	Not locked
16	Mystery values
32	Locked by CUA admin (User Admin)
64	Locked by system Administrator
128	Locked due to incorrect logon attempts or too many failed attempts
192	A combination of both. The user is locked by admin and user tries to logon with incorrect passwords and gets locked ( 192 = 64+128)

SAP Performance transaction codes

DB02	Database Analysis
ST02	Performance Tuning Analysis
ST03N	Workload Monitor
ST04	Database Performance Monitor
STOS	Performance Analysis (Traces)
ST06N	Operating System Performance Monito
ST07	Application Monitor
ST10	Statistics for Table Calls
STAD	Transaction Analysis
OS06	Operaling System Monitor

SAP System monitoring transaction codes

AL08
This transaction code shows a list off all user currently logged on to the SAP system (all app servers).

DB01
This transaction codes will display table locks.

SM12
This transaction code will display the enqueue locks.

Fill in the selection criteria as you want them

SM21
This transaction code is used to see the system log files.

After you have filled in your selection make sure to choose system log, choose, all remote system logs before you hit the read log button.


SM36
This transaction is used to schedule a background job.

SM37
This transaction code is used to display background (or batch) jobs submitted by users.

SM50
This transaction code is used to display all the work processes on the current apps server.

SM51
This transaction code is used to display a list off all the running apps servers. There should be 12 apps servers running at all times.


By double clicking on one off the servers in the list you will then see a listing off all the workprocesses on that server (same as using sm50). Note: you will also connect to that server.

SM66
This transaction code will display a list off all current running work processes on all the apps servers. It doesn’t refresh itself automatically so hit or select the refresh button located at the top.

The list can be sorted by selecting a colum and hitting the sort button located at the top.

ST04
This transaction code will bring up the Informix database overview. It displays information about the current use of the database

If you select the detail analysis menu using the button in the top bar you will see the screen shown below.