Show TOC

SM50 in Detail: Column OverviewLocate this document in the navigation structure

Use

Note that not all columns are displayed in the default view.

You can remove or add columns using Change Layout.

The following columns are available in the process overview:

Features

Column

Meaning

Number (Work Process Number)

The internal ID of a work process. Used to identify messages that belong to a work process in the system log.

Internal ID numbers are assigned in ascending order after the server has started. However, because dynamic processes can be started or terminated while the system is running, this consecutive numbering can contain gaps.

Type (work process type)

There are the following work process types:

  • DIA Work processes to execute:

    - UI requests

    - RFC requests

    - Internal requests

  • UPD: process to execute update requests

  • UP2 process to execute deferred update requests

  • ENQ process to execute lock requests

  • BTC process to execute background jobs

  • SPO process to execute print requests

Process ID (Process Identification)

Process ID of the operating system.

With this number the process can be processed using operating system commands (e.g. ps or kill in UNIX).

Info (Work Process Status Info)

Current status of the work process. Possible statuses are:

  • Waiting: Process is waiting for requests

  • Running: The process is processing a request.

  • Stopped: The process is stopped for an individual user. Process is waiting for a message. Column Work Process Status indicates what the work process is waiting for.

    If too many processes have status Stopped, then system performance suffers.

  • Ended: An error has terminated the process

  • Shutdown: Process terminated because of a shutdown

  • Standby : Process is only used in special situations (for example, for load situations or executing requests with high priority).

Info (Work Process Status Info)

If a work process has status Stopped, the reason is displayed. Typical reasons include the following: Debugging, CPIC activity, locks, updates, GUI (system waits for response from the SAPGUI front-end program, for example, for a remote function call (RFC)). For an overview of the possible parameters, refer to the F1 help in the system.

You may also see PRIV (PRIVate use) as a reason for holding a work process. PRIV indicates that a work process is reserved for a single user for memory management use. The work process has exceeded the limit of the SAP memory that is used by other processes. The process is stopped for as long as the current user requires local memory.

If more than a certain percentage of work processes are in PRIV hold state, then PRIV transactions are automatically terminated if the user is not active in the transaction for a set period of time. You can set this timespan in the SAP system profile.

Restart (after error)

Specifies whether the process should be automatically restarted if a process ends prematurely.

You can change the restrat status of a process from the menu: Start of the navigation path Administration Next navigation step Process Next navigation step Restart After Error  Next navigation step Yes/No End of the navigation path. Normally, leave Restart set to Yes.

If a work process aborts during its startup, the system automatically sets the restart status to No. This measure protects against endless attempts to restart a process if a database system is not available or another serious problem is affecting the system. As soon as the problem is fixed, you can set the restart status to Yes so that the system starts the work processes.

Failures (Work Process Failures).

Indicates how many times a work process has failed since the instance was started. A work process can be terminated by the administrator or due to an error. The termination counter can be reset from the menu: Start of the navigation path List Next navigation step Reset Next navigation step Failures End of the navigation path.

locked Sem. (Locked Semaphore)

Specifies the number of the semaphore held by the work process. If the process has stopped several semaphores, the numbers are separated by inverted commas. For a detailed list of possible semaphores, refer to the F1 help in the system.

(Semaphore To Be Locked)

Specifies the number of the semaphore to be locked. Normally, this field should be empty. If the sempahore appears again after refresh, you can see in the Locked Semaphores column whether the semaphore is being held by another work process. F1 help provides a list of all semaphores used by SAP.

CPU Time

CPU time since a work process was started. The CPU time of the work process is the sum of CPU system time and CPU user time. The time units are seconds and hundredths of seconds.

Time (runtime)

This column shows the current runtime of a request in seconds.

Priority

Priority with which requests are executed for this session. If there are work process bottlenecks, a request can be displaced by another request with higher priority.

Presently, the following priorities are supported:

  • High: Priority for online sessions and internal system processes

  • Medium Priority for RFC calls from online sessions.

  • Low: Priority for background processing (batch) and RFC calls from background programs (batch jobs)

Client

Client in which the current request is being processed.

User Name

User whose request is being processed.

Work Process Action (Current Action of the Work Process)

Action being executed by the active program. The actions that are displayed are those that are recorded by the SAP performance monitor. The performance monitor must be active (SAP profile parameter stat/level = 1 (default)) for actions or database table accesses to be displayed.

F1 help provides a list of all possible Current Actions of the Work Process.

Current Action Info

If the database is being accessed, this column contains the name of the table that is being accessed. If it is an AD opcode, this information is the number and name of the AD opcode.

Server name

Name of the server. This name usually consists of the host name, database name, and system number. The default value should not be changed.

CPU Time (CPU system time)

Current CPU system time used in the kernel at operating system level since the process was started. The time units are seconds and hundredths of seconds.

CPU Time (CPU user time)

Current CPU user time used in the application program of the user since the process was started. The time units are seconds and hundredths of seconds.

Session Type

Type of session executed, e.g. GUI, HTTP, RFC. F1 help provides a list of all possible session types.

Main Program

Name of the main program.

Session Key

Internal key of a session The internal key of a session consists of three parts:

  • Logon handle: index in the logon table

  • Logon ID: unique ID of the logon

  • Session handle: internal number of the session

The session key is displayed in the form T<logon handle>_U<logon ID>_M<session handle>, (for example, T15_U234_M2) and is also written in this format within the developer trace.