AsynClose

Stream Close

Task is closing I/O ports after backup or restore.

AsynCntl

-

Task is determining parameters or initializing a backup device.

AsynIO

Stream IO

Task is executing I/O operation (during backup or restore).

-

Stream Init

Task is initializing backup or restore operation.

AsynOpen

Stream Open

Task is opening I/O ports for backup or restore.

AsynWaitRead/Write

Stream Wait(R)/(W)

Task is waiting for the end of an I/O operation during backup or restore (W: Write, R: Read).

Command reply

Command reply

Task is sending the result of a request to the application.

Command wait

Command wait

Database session without a request.

Connect wait

Connect wait

Task is already running and waiting for the database session to be created.

Continue

Continue

Tasks is in the process of releasing another task from the Stopped state.

DcomObjCalled

LCApp Called

Task is executing an SAP liveCache application routine.

Inactive

Inactive

Task is free (not linked) and cannot run. The task does not have a stack.

InsertEvent

Insert Event

Task is generating an event.

-

IO CPort Wait

Task is waiting for an RTE Completion Port.

-

IO Job Execute

Task is executing an I/O job.

-

IO Job Wait

Task is waiting for the end of an I/O job.

IO wait (W/R)

IO wait (W/R)

Task is waiting for the result of an I/O operation (W: Write, R: Read).

Locked

Locked

Task was locked as the kernel was shut down (to avoid this task being rescheduled).

Mark for Start

Startable

Task is free (not linked) and cannot run. The task already has a stack (system has already allocated all resources) and is waiting for the start.

RescheduleMsec

RescheduleMsec

Short-term wait situation, task will run again automatically after a predefined time span (in microseconds).

Runnable

ShareLck Yield

Task can run now, but has been displaced due to long runtime or priority of another task.

Runnable

ExclLock Yield

Task can run now, but has been displaced due to long runtime or priority of another task.

Running

Running

Task is running, using CPU.

Spinlock loop

Spinlock Loop

Task is trying to obtain a spinlock.

SpinlockYield

Spinlock Yield

Task gives up control voluntarily. This situation occurs when the task has just tried to obtain a spinlock but without success.

Stopped

Stopped

Task was stopped by the kernel and is waiting to run again.

Terminated

Terminated

Task or database session was ended.

UNKNOWN

UNKNOWN

Task state is unknown.

Vattach

Volume Attach

Task is opening I/O ports (volumes, normal operation).

Vbegexcl

Enter ExclLock

Task is waiting to be allowed to enter a protected area exclusively.

Vdetach

Volume Detach

Task is closing I/O ports (volumes).

Vdevsize

-

Task is determining the size of a volume or formatting a volume.

Vdualvectorio

Dual Vector IO

Task is performing a vector I/O operation (read or write) on two volumes in parallel.

vdiaginit

Trace init

Task is initializing the trace volume.

Vendexcl

Leave ExclLock

Task is leaving a protected area.

VenterRWRegion

Enter ShareLck

Task is waiting to be allowed to enter a conditionally shared area.

Vfclose

File Close

Task is closing a file.

Vfopen

File Open

Task is opening a file.

Vfwrite

File Write

Task is writing to a file.

VleaveRWRegion

Leave ShareLck

Task is exiting a protected, conditionally shared area.

-

VolumeFormatW

Task is waiting for a volume to be formatted.

Vopmsg

Message Output

Task is writing a message to one of the following database files: knldiag, knldiag.err, opmsg[n]

Vrelease

Connect Close

Task is ending the database session.

Vshutdown

DB OFFLINE

Task is changing the operational state of the database from ONLINE to OFFLINE.

Vsleep

Sleeping

Short-term wait situation, task will run again automatically after a predefined time span.

Vsuspend

Suspend

Task is suspended and waiting to be awoken explicitly by another task (Vresume).

There are special Vsuspend wait situations that are displayed under a specific name.

More information: Vsuspend Task States table

Vvectorio

Vector IO

Task is executing a vector I/O operation (read or write).

-

Volume Format

Task is formatting volume(s).

-

IOComPort Wait

Task is waiting for an I/O order confirmation from the I/O completion port.

-

Aborting

Task is exiting the database session.

Yielding

-

Task gives up control voluntarily.

-

Initialized

Task was initialized.

WaitForEvent

Wait For Event

Task is waiting for an event.

DB FULL

The data area is full and cannot accept any more pages. Add a new data volume.

DC OvFlow

The data cache is operating at capacity and cannot accept any new data. Only after the system has written pages from the data cache to the volumes can the data cache accept new pages. If you frequently observe DC OvFlow states, check whether your data cache is large enough or the I/O system too slow.

InvNodeExcl

Can occur while accessing B* trees that represent an index.

A task is trying to set an exclusive lock on a non-root page of a B* tree but has to wait due to a lock collision.

InvNodeShare

Can occur while accessing B* trees that represent and index.

A task is trying to set a shared lock on a non-root page of a B* tree but has to wait due to a lock collision.

InvRootExcl

Can occur while accessing B* trees that represent an index.

A task is trying to set an exclusive lock on the root page of a B* tree but has to wait due to a lock collision.

InvRootShare

Can occur while accessing B* trees that represent and index.

A task is trying to set a shared lock on the root page of a B* tree but has to wait due to a lock collision.

LOG FULL

The log area is full. You have to back up your log entries.

LogIOWait

Can occur during a commit

Waiting for a log page to be written to the log area.

LogQ FULL

The log queues are operating at capacity and cannot accept any new redo log entries. Only when the log writer has written data from the log queues to the log area can the log queues accept log entries again. If you frequently observe LogQ Full states, check whether your log queues are too small or the I/O system too slow.

ObjNodeExcl

Can occur while accessing page chains which represent SAP liveCache objects.

A task is trying to set an exclusive lock on a non-root page of a page chain but has to wait due to a lock collision.

ObjNodeShare

Can occur while accessing page chains which represent SAP liveCache objects.

A task is trying to set a shared lock on a non-root page of a page chain but has to wait due to a lock collision.

ObjRootExcl

Can occur while accessing page chains which represent SAP liveCache objects.

A task is trying to set an exclusive lock on the root page of a page chain but has to wait due to a lock collision.

ObjRootShare

Can occur while accessing page chains which represent SAP liveCache objects.

A task is trying to set a shared lock on the root page of a page chain but has to wait due to a lock collision.

SVP-End

Can occur while a savepoint is active

A task is trying to execute an operation which needs to be synchronized with the savepoint

SyncRedo

During a redo, the system writes information on all transactions which need to be repeated to transaction-specific files. These files are processed by a redo server when the respective commit time stamp is reached in the redo process. As long as the commit time stamp has not yet been reached, the redo task has to wait.

TableNodeExcl

Can occur while accessing B* trees that represent permanent data.

A task is trying to set an exclusive lock on a non-root page of a B* tree but has to wait due to a lock collision.

TableNodeShare

Can occur while accessing B* trees that represent permanent data.

A task is trying to set a shared lock on a non-root page of a B* tree but has to wait due to a lock collision.

TableRootExcl

Can occur while accessing B* trees that represent permanent data.

A task is trying to set an exclusive lock on the root page of a B* tree but has to wait due to a lock collision. Tasks request exclusive locks on B* trees for structure-changing operations such as tree balancing, among others.

TableRootShare

Can occur while accessing B* trees that represent permanent data.

A task is trying to set a shared lock on the root page of a B* tree but has to wait due to a lock collision. As a rule, all operations on a B* tree begin with a shared lock, which is refined as the operation descends into the B* tree, that is, it is extended to become an exclusive or shared lock at non-root level.

Vwait

Task is waiting to be awoken explicitly by another task (Vsignal). Example: Task is waiting for an SQL lock.