A record in this table represents one node (machine) of a multi node (grid) installation.
Nodes are identified by their hostname.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Watchdog Session | Text | 8 | 1 | Edit | Yes | Public | ||
| SSNINR | INR of Session | Text | 8 | 1 | Edit | Yes | Public | ||
| APPSRV | Application Server | Text | 32 | 1 | Edit | Yes | Public | ||
| STA | Status of Session | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| VALDATTIM | Valid until | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| LSTDATTIM | Timestamp of last update of this record | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| REQSTA | Requested Status of Node | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| REQEVTINR | Internal Unique ID of Event for request | Text | 8 | 1 | Edit | Yes | Public | ||
| PRIFLG | Primary Flag to mark 'Leading Watchdog' | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| LOALCKFLG | Node locked for new users/managers sessions | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| LOA | Consolidated Load Figure | Numeric | 7 | 2 | Edit | Yes | Public | ||
| LOADATTIM | Timestamp of Load Figure | Datetime | 15 | 0 | Unknown | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| SYN_APPSRV | APPSRV, STA | |
| SYN_INR | INR | Unique |
| SYN_LSTDATTIM | LSTDATTIM | |
| SYN_STA | STA | |
| SYN_VALDATTIM | VALDATTIM |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter SSN. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field identifies the session entry in the table SSN, responsible for issuing this event.
This field identifies the session entry in the table SSN, responsible for issuing this event.
The name of the server executing the watchdog process.
The name of the server executing the watchdog process.
The status of the SYN record reflects the logical status of this node and it's controlling watchdog.
'R'unning: In normal operation
'D'own: Watchdog terminated (due to scheduled or gracefull shutdown)
'C'anceled: Watchdog marked as terminated by other process as SYN record was not updated in time.
'B'locked: Watchdog is down but new session must not start (i.e. if a watchdog process finds during start a 'B'locked entry on it's node it will terminate immediately without creating a new SYN record)
The status of the SYN record reflects the logical status of this node and it's controlling watchdog.
'R'unning: In normal operation
'D'own: Watchdog terminated (due to scheduled or gracefull shutdown)
'C'anceled: Watchdog marked as terminated by other process as SYN record was not updated in time.
'B'locked: Watchdog is down but new session must not start (i.e. if a watchdog process finds during start a 'B'locked entry on it's node it will terminate immediately without creating a new SYN record)
| Code | Text |
|---|---|
| S | Starting |
| R | Running |
| D | Down |
| C | Canceled |
| B | Blocked |
After this timestamp this entry is assumed to be stale as the expected update did not take place.
So after this timestamp the watchdog responsible for updating this entry is assumed to benolonger active.
After this timestamp this entry is assumed to be stale as the expected update did not take place.
So after this timestamp the watchdog responsible for updating this entry is assumed to be no longer active.
Date and time when the transaction identified in LSTFRM was started.
Date and time when the transaction identified in LSTFRM was started.
Requested status of a node as per codetable.
Requested status of a node as per codetable.
| Code | Text |
|---|---|
| D | Down Watchdog + Manager |
| B | Lock and Down Watchdog + Manager |
| L | Lock |
| O | Open |
| - |
Whenever REQSTA is set (by anopther process) a corresponding event describing the triggering process and reason will be written.
Whenever REQSTA is set (by another process) a corresponding event describing the triggering process and reason will be written.
At any time exactly one of the running watchdog instances on a grid will be marked as 'Primary'.
Only this instance of watchdog will execute such topics that are not node specific (i.e. typically SQLs on the database)
At any time exactly one of the running watchdog instances on a grid will be marked as 'Primary'.
Only this instance of watchdog will execute such topics that are not node specific (i.e. typically SQLs on the database)
| Code | Text |
|---|---|
| P | Leader |
| Not Leader | |
| ? | Undetermined |
Node locked for new users/managers sessions.
Node locked for new users/managers sessions.
| Code | Text |
|---|---|
| Accept Sessions | |
| B | No New Sessions |
| L | Locked on request |
Consolidated Load Figure.
Consolidated Load Figure.
Timestamp of Load Figure with date and time.
Timestamp of Load Figure with date and time.