Task Manager (SAP DB) 

Use

Display all database tasks and their current statuses.

Terminate running SQL commands and tasks.

Prerequisites

You are assigned the SAP DB administrator role in the CCMS (SAP_BC_DB_ADMIN_SAPDB).

Procedure

In the SAP_BC_DB_ADMIN_SAPDB role, choose Database: Monitoring ® Database assistant (transaction DB50 ).

Choose SAP DB Assistant ® Processes ® Task manager.

Result

An overview of the database tasks appears as well as information about the current status of each task.

You can choose between the following views:

Active tasks

User tasks (task type User)

System tasks

All tasks

The following data (among other information) appears:

Task ID

Internal task ID

Thread/Process ID

Thread ID of corresponding internal task.

Application PID

Process ID of application program assigned to task.

If there is an asterisk (*) in front of the PID, the PID is on a different server.

Task Status

Information about the current statuses of the database tasks.

If logwriter tasks often have the status I/O wait , this may be caused by an I/O bottleneck in your log.

You can execute the following functions:

To terminate the action of an active task, select the task.

By choosing Edit ® SQL command, you terminate the command just executed.

If you choose Edit ® Terminate SQL session instead, you terminate the task itself. If an R/3 System work process was assigned to this task, the work process will immediately be assigned to a new task.

Use one of these two possibilities for ending an active action, if you want to add the relevant SQL command to the performance trace after the command is terminated. If you terminate an action by terminating the relevant work process (transaction SM50 ), the command is not added to the trace.

If you observe that certain tasks have the status Vsuspend for a long time, choose B* tree locks, to check whether the tasks are waiting for B* tree locks.

If you observe that certain tasks have the status Vwait for a long time, choose Current system status ® SQL lock ® Waits for information about the current waits.

To refresh the display, choose Edit ® Refresh.