Skip to end of metadata
Go to start of metadata

x_cons <database_name> show tasks

Shows statistics for all tasks

ID   UKT  Win   TASK       APPL Current         Timeout Region     Wait
          tid   type        pid state          priority cnt try    item
T1     6  0xC94 Timer           Vsleep                0 0               145(s)
T2     2  0xCEC Logwr           No-Work  (255)        0 0               40(s)
T3     1  0xD0C Tracewr         No-Work  (255)        0 0               2(s)
T4     3  0xD24 Utility         Inactive              0 0               1(s)
T5     6  0xC94 Pager           No-Work  (255)        0 0               145(s)
T6     6  0xC94 Pager           No-Work  (255)        0 0               145(s)
T7     6  0xC94 Pager           No-Work  (255)        0 0               145(s)
T8     6  0xC94 Pager           No-Work  (255)        0 0               145(s)
:
T118   7  0xC98 User       5304 Command wait         no 0               2311(s)
T119   4  0xD20 Server          No-Work  (255)        0 0               246(s)
:
T146   4  0xD20 Savepnt         No-Work  (255)        0 0               246(s)
:
T166   4  0xD20 Server          No-Work  (255)        0 0               246(s)
T167   5  0xD28 Event      2996 Stopped               0 0               17(s)
T169   5  0xD28 GarbCol         No-Work  (255)        0 0               17(s)
  • ID: Task ID
  • UKT: Number of the user kernel thread
  • Unix tid/Win tid: Unix/Windows thread ID of the user kernel thread
    Type: Type of the task. (Timer, Log Writer, Trace Writer, Utility, Pager (Data Writer), Server Task, User Task, Garbage Collector).
  • APPL pid: Process ID of the application program linked to the task. An asterisk (*) after the pid indicates that the process ID is on a separate computer and is being accessed remotely. The number, 0, in pid field indicates a java process.
  • Current state: Current state of the task. An ampersand (&) after the state means that the task is in a COM routine which is called from SAP liveCache kernel. An asterisk (*) in the current state means that the task is in the run queue meaning it is ready to run but it is waiting for other tasks to yield the CPU. An exclaimation mark (!) after the state means that the issued command is already cancelled. The user might have killed the process. The numbers after the state indicates the name of the item it is waiting for.
  • Timeout priority: If the task is in a state pending a timeout, for example, vwait, the seconds until the end of the timeout are shown in this column.
  • Region cnt: Count that a critical region has been accessed since the task has been running.
  • Region try: Number of the queried or held critical region that the task is waiting for because that specific region is locked by another task.
  • Wait item: The item the task is waiting for. It depends on the wait situation. If the task is waiting for the ExclLock to be released, then the "wait item" displays the page number it is waiting for. If the task is in IO wait status, the "wait item" displays the number of the volume for which the current I/O is done.