17.10 - Session State Definitions - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The following table shows the valid states that can occur for a session.

State Represents
CS_ASNRSP an assign response received from the assign task.
CS_ASNRSPSSO an assign response received from the assign task with saved SSO.
CS_ASNRSPWAIT waiting for an assign response from the assign task.
CS_ASNRSPWAITERR waiting for an assign response from the assign task after an error occurred.
CS_ASNRSPWAITERRCLOSED waiting for an assign response from the assign task with the socket closed.
CS_ASNRSPWAITSSO waiting for an assign response from the assign task with saved SSO.
CS_CLIENTWAITDUNMSG waiting for a DUN start message from the client.
CS_CLIENTWAITELICITDATARSP waiting for a response from the client after deferred transfer of lob data.
CS_CLIENTWAITINDOUBT waiting for a request from the client after an in doubt transaction.
CS_CLIENTWAITINTRAN waiting for a request from the client after a transaction.
CS_CLIENTWAITINTTRANSECPOL a recursive state that handles security policy violation while waiting for client request in a transaction.
CS_CLIENTWAITNOTRAN waiting for a request from the client after no transaction.
CS_CLOSEWAIT waiting for the client to close the virtual circuit.
CS_CLOSEWAITTERM waiting for the client to close the virtual circuit and notify assign to free context.
CS_CLOSEWAITTERMDISC waiting for the client to close the virtual circuit and notify assign to keep context.
CS_CLOSEWAITTERMGONE waiting for the client to close the virtual circuit and notify assign to force the context.
CS_CONSSOWAIT waiting for an SSO connect request from the client.
CS_CONTMSGRSPINDOUBTLOGOFFOK a recursive state that handles a continue message response after logoff in an in doubt transaction.
CS_CONTMSGRSPINTRANLOGOFFOK a recursive state that handles a continue message response after logoff in a transaction.
CS_CONTMSGRSPNOTRANLOGOFFOK a recursive state that handles a continue message response after logoff not in a transaction.
CS_CONWAIT waiting for a connect request from the client.
CS_DIRECTMSGRSPBAD a recursive state that handles a bad direct response from DBS.
CS_DIRECTMSGRSPOK a recursive state that handles a correct direct response from DBS.
CS_DUNRSP waiting for message from client or database.
CS_DUNSQLMSG a recursive state that handles a DUN SQL message received from DBS.
CS_ELICITDATAMSGREQ a recursive state that handles elicit data request from DBS.
CS_ERRWAITFORCLOSE waiting for the client to close the connection after being sent an error message.
CS_ERRWAITFORLOGOFF waiting for the logoff to complete after the client closed the connection due to an error.
CS_ESTABLISHED an idle logged on session.
CS_ESTABLISHEDELICITSTARTRSP an idle logged on session that uses recoverable protocol.
CS_ESTSECPOLVIOL a recursive state that handles a security policy violation on a logged on session.
CS_IDLE a new session waiting for its first message from the Client.
CS_LOGOFFRSPERR a recursive state that handles an error response for a logoff from the database.
CS_LOGOFFRSPERRINDOUBT a recursive state that handles an error response for a logoff from the database when it was in an in doubt transaction.
CS_LOGOFFRSPERRINTRAN a recursive state that handles an error response for a logoff from the database when it was in a transaction.
CS_LOGOFFRSPERRNOTRAN a recursive state that handles an error response from the database for a logoff when it was not in a transaction.
CS_LOGOFFRSPOK a recursive state that handles a logoff response from the database.
CS_LOGOFFRSPOKINDOUBT a recursive state that handles a logoff response from the database when it was in an in doubt transaction.
CS_LOGOFFRSPOKINTRAN a recursive state that handles a logoff response from the database when it was in a transaction.
CS_LOGOFFRSPOKNOTRAN a recursive state that handles a logoff response from the database when it was not in a transaction.
CS_LOGOFFRSPWAITUCABTRSP waiting for a UC abort response after sending a UC abort request during logoff processing.
CS_LOGOFFWAITRSP waiting for a logoff response from session control.
CS_LOGOFFWAITRSPCLOSECONTIMER waiting for a logoff response from session control and the virtual circuit was timed out.
CS_LOGOFFWAITRSPCLOSED waiting for a logoff response from session control and the virtual circuit was closed.
CS_LOGOFFWAITRSPCLOSEDDISC waiting for a logoff response from session control and the virtual circuit was disconnected.
CS_LOGOFFWAITRSPERR waiting for a logoff response from session control.
CS_LOGOFFWAITRSPFORCED waiting for a logoff response from session control and the client was killed.
CS_LOGOFFWAITRSPINDOUBT waiting for a logoff response from session control after the client sent a logoff request when it was in an in doubt transaction.
CS_LOGOFFWAITRSPINDOUBTDISC waiting for a logoff response from session control after the client sent a logoff request when it was in an in doubt transaction and the virtual circuit was disconnected.
CS_LOGOFFWAITRSPINDOUBTFORCED waiting for a logoff response from session control after the client sent a logoff request when it was in an in doubt transaction and the session was killed.
CS_LOGOFFWAITRSPINDOUBTTERM waiting for a logoff response from session control after the client sent a logoff request when it was in an in doubt transaction and the virtual circuit was closed.
CS_LOGOFFWAITRSPINTRAN waiting for a logoff response from session control after the client sent a logoff request when it was in a transaction.
CS_LOGOFFWAITRSPINTRANDISC waiting for a logoff response from session control after the client sent a logoff request when it was in a transaction and the virtual circuit was disconnected.
CS_LOGOFFWAITRSPINTRANFORCED waiting for a logoff response from session control after the client sent a logoff request when it was in a transaction and the session was killed.
CS_LOGOFFWAITRSPINTRANSECPOL a recursive state that handles a security policy violation while waiting for the response to a logoff request when it was in a transaction.
CS_LOGOFFWAITRSPINTRANTERM waiting for a logoff response from session control after the client sent a logoff request when it was in a transaction and the virtual circuit was closed.
CS_LOGOFFWAITRSPNOTRAN waiting for a logoff response from session control after the client sent a logoff request when it was not in a transaction.
CS_LOGOFFWAITRSPNOTRANDISC waiting for a logoff response from session control after the client sent a logoff request when it was not in a transaction and the virtual circuit was disconnected.
CS_LOGOFFWAITRSPNOTRANFORCED waiting for a logoff response from session control after the client sent a logoff request when it was not in a transaction and the session was killed.
CS_LOGOFFWAITRSPNOTRANTERM waiting for a logoff response from session control after the client sent a logoff request when it was not in a transaction and the virtual circuit was closed.
CS_LOGOFFWAITRSPSECPOL a recursive state that handles a security policy violation while waiting for the response to a logoff request.
CS_LOGONFAILRSP a recursive state that handles a response from session control to a logon fail request.
CS_LOGONFAILWAIT waiting for a response from session control to a logon fail request.
CS_LOGONFAILWAITCLOSED waiting for a response from session control to a logon fail request after the client has gone away.
CS_LOGONFAILWAITCONTIMER waiting for a response from session control to a logon fail request after the client has timed out.
CS_LOGONFAILWAITERR waiting for a response from session control to a logon fail request after an error has occurred.
CS_LOGONRSPBAD a recursive state that handles bad Logon response.
CS_LOGONRSPOK a recursive state that handles correct Logon response.
CS_LOGONWAIT waiting for a response from session control to a logon request.
CS_LOGONWAITCLOSED waiting for a response from session control to a logon request after the client has gone away.
CS_LOGONWAITCLOSEDFORCED waiting for a response from session control to a logon request after the client has gone away and was killed.
CS_LOGONWAITERR waiting for a response from session control to a logon request after an error has occurred.
CS_OFFWAITUCABTRSP waiting for a UCAbort request after a successful logoff request.
CS_OFFWAITUCABTRSPFORCED waiting for a UCAbort request after a successful logoff request where the client was killed.
CS_OFFWAITUCABTRSPSECPOL a recursive state that handles security policy violation while waiting for the response to UCAbort after logoff.
CS_OFFWAITUCABTRSPTERM waiting for a UCAbort request after a successful logoff request where the client closed the virtual circuit.
CS_REASNRSP reassign response received from the assign task.
CS_REASNRSPSSO reassign response received from the assign task with saved SSO parcel.
CS_REASNRSPWAIT waiting for a reassign response from the assign task.
CS_REASNRSPWAITSSO waiting for a reassign response from the assign task with saved SSO parcel.
CS_REASNWAITCLOSED waiting for a reassign response from the assign task after an error has occurred.
CS_REASNWAITCLOSEDDISC waiting for a reassign response from the assign task after an error has occurred and the client disconnected.
CS_REASNWAITCLOSEDKILL waiting for a reassign response from the assign task after receiving a GONE/KILL message.
CS_REASNWAITERR waiting for a reassign response from the assign task after an error has occurred.
CS_RECONFAILLOGOFFWAITRSP waiting for a logoff response from session control after reconnect failed.
CS_RECONSSOWAIT waiting for a reconnect response from the client using SSO.
CS_RECONWAIT waiting for a reconnect response from the client.
CS_RESSOWAIT waiting for an SSO response from the client as part of reconnect.
CS_SECPOLVIOLLOGOFFWAITRSP waiting for a logoff response after a Security Policy Violation.
CS_SECPOLVIOLLOGOFFWAITRSPINTRAN waiting for a logoff response or client connection close after a Security Policy Violation. The logoff request was received inside a transaction.
CS_SECPOLVIOLLOGOFFWAITRSPINTRANTERM waiting for a logoff response after a Security Policy Violation. The logoff request was received inside a transaction.
CS_SECPOLVIOLLOGOFFWAITRSPWAITTERM waiting for the client to close the connection after a Security Policy Violation during logoff processing.
CS_SECPOLVIOLOFFWAITUCABTRSP waiting for a UC abort response or client connection close after a Security Policy Violation during the UC abort processing as part of a logoff.
CS_SECPOLVIOLOFFWAITUCABTRSPWAITABTRSP waiting for a UC abort response after a Security Policy Violation during the UC abort processing as part of a logoff.
CS_SECPOLVIOLWAITABORTRSP waiting for abort response after Security Policy Violation.
CS_SECPOLVIOLWAITABORTRSPTERM waiting for abort response gateway has got terminate or disconnect from client after Security Policy Violation.
CS_SECPOLVIOLWAITCONTRSPINTRAN waiting for a continue response or client connection close after a Security Policy Violation. The continue request was received inside a transaction.
CS_SECPOLVIOLWAITCONTRSPINTRANWAITTERM waiting for a continue response after a Security Policy Violation. The continue request was received inside a transaction.
CS_SECPOLVIOLWAITCONTRSPNOTRAN waiting for a continue response or client connection close after a Security Policy Violation.
CS_SECPOLVIOLWAITCONTRSPNOTRANWAITTERM waiting for a continue response after a Security Policy Violation.
CS_SECPOLVIOLWAITDIRECT waiting for DBS response from a Directed request after Security Policy Violation.
CS_SECPOLVIOLWAITDIRECTLOGOFF waiting for DBS response from a Directed request after Security Policy Violation.
CS_SECPOLVIOLWAITSTARTRSPLOGOFF waiting for a start response or client connection close after a Security Policy Violation during logoff processing.
CS_SECPOLVIOLWAITSTARTRSPLOGOFFTERM waiting for a start response after a Security Policy Violation during logoff processing.
CS_SECPOLVIOLWAITUCABTRSP waiting for Ucabort response after Security Policy Violation.
CS_SECPOLVIOLWAITUCABTRSPTERM waiting for Ucabort response gateway has got terminate or disconnect from client after Security Policy Violation.
CS_SSOWAIT waiting for an SSO response from the client.
CS_STARTMSGRSPINDOUBT a recursive state that handles a start message response in an in doubt transaction.
CS_STARTMSGRSPINTRAN a recursive state that handles a start message response in a transaction.
CS_STARTMSGRSPNOTRAN a recursive state that handles a start message response when not in a transaction.
CS_WAITABORTRSP waiting for a DBS response to an ABORT request.
CS_WAITCONTINUEACKINDOUBT waiting for an HSCMSGRECEIVED message as acknowledgement was received for a CONTINUE message that is in an in doubt transaction.
CS_WAITCONTINUEACKINTRAN waiting for an HSCMSGRECEIVED message as acknowledgement was received for a CONTINUE message that is in a transaction.
CS_WAITCONTINUEACKNOTRAN waiting for an HSCMSGRECEIVED message as acknowledgement was received for a CONTINUE message that is not in a transaction.
CS_WAITCONTINUERSPINDOUBT waiting for a DBS response from the Continue Request in an in doubt transaction.
CS_WAITCONTINUERSPINTRAN waiting for a DBS response from the Continue Request in a transaction.
CS_WAITCONTINUERSPNOTRAN waiting for a DBS response from the Continue Request not in a transaction.
CS_WAITCONTRSPINDOUBTDISC waiting for a DBS response from the Continue Request in an in doubt transaction after disconnect.
CS_WAITCONTRSPINDOUBTFORCED waiting for a DBS response from the Continue Request in an in doubt transaction after kill.
CS_WAITCONTRSPINDOUBTLOGOFF waiting for a DBS response from the Continue Request in an in doubt transaction after logoff.
CS_WAITCONTRSPINDOUBTTERM waiting for a DBS response from the Continue Request in an in doubt transaction after terminate.
CS_WAITCONTRSPINTRANDISC waiting for a DBS response from the Continue Request in a transaction after disconnect.
CS_WAITCONTRSPINTRANFORCED waiting for a DBS response from the Continue Request in a transaction after kill.
CS_WAITCONTRSPINTRANLOGOFF waiting for a DBS response from the Continue Request in a transaction after logoff.
CS_WAITCONTRSPINTRANSECPOL a recursive state that handles security policy violation while waiting for the response to a continue request in a transaction.
CS_WAITCONTRSPINTRANTERM waiting for a DBS response from the Continue Request in a transaction after terminate.
CS_WAITCONTRSPNOTRANDISC waiting for a DBS response from the Continue Request not in a transaction after disconnect.
CS_WAITCONTRSPNOTRANFORCED waiting for a DBS response from the Continue Request not in a transaction after kill.
CS_WAITCONTRSPNOTRANLOGOFF waiting for a DBS response from the Continue Request not in a transaction after logoff.
CS_WAITCONTRSPNOTRANSECPOL a recursive state that handles a security policy violation while waiting for the response to a continue request.
CS_WAITCONTRSPNOTRANTERM waiting for a DBS response from the Continue Request not in a transaction after terminate.
CS_WAITDIRECTACK waiting for an HSCMSGRECEIVED message as acknowledgement that the DIRECT message was received.
CS_WAITDIRECTRSP waiting for a DBS response from a Directed Request.
CS_WAITDIRECTRSPDISC waiting for a DBS response from a Directed Request after a disconnect.
CS_WAITDIRECTRSPLOGOFF waiting for a DBS response from a Directed Request after logoff.
CS_WAITDIRECTRSPLOGOFFFORCED waiting for a DBS response from a Directed Request after logoff due to a kill.
CS_WAITDIRECTRSPLOGOFFTERM waiting for a DBS response from a Directed Request after logoff due to a terminate.
CS_WAITDIRECTRSPSECPOL a recursive state that handles security policy violation while waiting for the response to a directed request.
CS_WAITDUNABORTRSP waiting for DBS response to an ABORT request for DUN transaction.
CS_WAITDUNRSP waiting for DUN response from database.
CS_WAITFORTAKEOVERRSP waiting for TakeoverRsp from assign task.
CS_WAITFORTAKEOVERRSPCLOSED waiting for TakeoverRsp from assign task after close.
CS_WAITSTARTACK waiting for an HSCMSGRECEIVED message as acknowledgement that the START message was received.
CS_WAITSTARTDBSRSPDISC waiting for a DBS response after a disconnect.
CS_WAITSTARTDBSRSPFORCED waiting for a DBS response after a kill.
CS_WAITSTARTDBSRSPTERM waiting for a DBS response after a terminate.
CS_WAITSTARTRSP waiting for a DBS response from a Start Request.
CS_WAITSTARTRSPLOGOFF waiting for a start response after receiving a logoff request.
CS_WAITSTARTRSPLOGOFFSECPOL a recursive state that handles security policy violation while waiting for the response to an abort request.
CS_WAITSTARTSECPOL a recursive state that handles security policy violation while waiting for start response.
CS_WAITSTRTDBSRSPFORCEDSECPOL a recursive state that handles security policy violation while waiting for the response to an abort request.
CS_WAITUCABTRSP waiting for a DBS response to a UCAbort Request.
CS_WAITUCABTRSPDISC waiting for a DBS response to a UCAbort Request after a disconnect.
CS_WAITUCABTRSPFORCED waiting for a DBS response to a UCAbort Request after a kill.
CS_WAITUCABTRSPSECPOL a recursive state that handles security policy violation while waiting for the response to UCAbort.
CS_WAITUCABTRSPTERM waiting for a DBS response to a UCAbort Request after a terminate.