Entering content frame

Background documentation Task State Locate the document in its SAP Library structure

The table shows the possible states of the database tasks.

You can view the current task states using the database console, among other things.

AsynClose

Closing the input/output channels after a backup or restore

AsynCntl

Task is determining parameters or initializing the backup device

AsynOpen

Opening the input/output channels for a backup or restore

AsynWait

Task waiting for execution of input/output activity when making backup/restore

Command reply

Task is sending the result of a request to the application

Command wait

Task is a database session without a request

Connect wait

Free database session

Diaginit

Initializing the trace volume

DcomObjCalled

Task is executing a database procedure/COM object

Inactive

Task is in an initial state and has no resources (such as stack)

InsertEvent

Task is generating an event

IO wait

Waiting for I/O (W:write, R:read)

RescheduleMsec

Short-term wait situation; starts running again automatically after specified period (in microseconds)

Runnable

Can run now, but swapped due to long runtime or priority of another task

Running

Running, using CPU

Sus...

Special suspend situations

Terminated

Task is being terminated/database session is being terminated

Vattach

Opening the input/output channels (volumes, normal operation)

Vbegexcl

Waiting for protected memory access

Vdetach

Closing the input/output channels (volumes, normal operation)

Vdevsize

Determining the size or formatting of a volume

Vendexcl

Can run again after protected memory access that caused lock a collision

Vopmsg

Writing a message to the database files knldiag, knldiag.err, and/or opmsg[n]

Vrelease

Ending the database session between the database instance and application

Vshutdown

Operational state of the database instance is changing from ONLINE to ADMIN

Vsleep

Short-term wait situation; starts running again automatically after specified period

Vsuspend

Waiting for a B* tree lock (very short) or a log I/O, awoken explicitly

Vwait

Waiting for an SQL lock

WaitForEvent

Task is waiting for events to be generated

 

 

Leaving content frame