This table describes all currently active SQL sessions.
An entry is generated after a new session ID is read
and claimed by a manager application (see
hicomSQLsessionIdGenerator).
An entry is deleted from the table when its timeout
(see hicomSQLsessionTimeout) - which is restarted with
each access on hicomSQLresultData - expires.
The state of a new created entry initially is idle(1).
The manager must then SET hicomSQLsessionStatement and
hicomSQLsessionWhereClause, optionally may set
hicomSQLsessionTimeout, and then SET hicomSQLsessionState
to run(2). The completion of a session will be
indicated to the manager via a hicomSQLsessionFinished
trap.
Parsed from file SIEMENS-PN-MIB.mib
Module: SIEMENS-PN-MIB
Vendor: Fujitsu Siemens Computers
Module: SIEMENS-PN-MIB
[Automatically extracted from oidview.com]
hicomSQLsessionTable OBJECT-TYPE SYNTAX SEQUENCE OF HicomSQLsessionEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "This table describes all currently active SQL sessions. An entry is generated after a new session ID is read and claimed by a manager application (see hicomSQLsessionIdGenerator). An entry is deleted from the table when its timeout (see hicomSQLsessionTimeout) - which is restarted with each access on hicomSQLresultData - expires. The state of a new created entry initially is idle(1). The manager must then SET hicomSQLsessionStatement and hicomSQLsessionWhereClause, optionally may set hicomSQLsessionTimeout, and then SET hicomSQLsessionState to run(2). The completion of a session will be indicated to the manager via a hicomSQLsessionFinished trap." ::= { hicomSQL 2 }
OID | Name | Sub children | Sub Nodes Total | Description |
---|---|---|---|---|
1.3.6.1.4.1.231.7.2.1.8.2.1 | hicomSQLsessionEntry | 7 | 7 | An entry in the hicomSQLsessionTable. |
OID | Name | Sub children | Sub Nodes Total | Description |
---|---|---|---|---|
1.3.6.1.4.1.231.7.2.1.8.1 | hicomSQLsessionIdGenerator | 0 | 0 | hicomSQLsessionIdGenerator is used to create and assign unique SQL session identifiers to concurrent manager applications. hicomSQ… |
1.3.6.1.4.1.231.7.2.1.8.3 | hicomSQLresultTable | 1 | 4 | This table contains the results of finished SQL sessions. |
1.3.6.1.4.1.231.7.2.1.8.4 | hicomSQLinfo | 2 | 2 | None |