For every instance of a manager and for every service one entry in this table is created.
The SYB record contains
1. information, that a service has been started
2. information, that a service is alive
3. approximate performance information about the last CNTTIM period
If last update time + 1.5 x UPDFRE has elapsed, this service is assumed to have failed (as it should update itself automatically every UPDFRE hours).
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
MGR | Manager | Text | 8 | 1 | Edit | Yes | Public | ||
SRV | Service | Text | 6 | 1 | Edit | Yes | Public | ||
SSNINR | Session ID | Text | 8 | 1 | Edit | Yes | Public | ||
INS | Instance | Text | 16 | 1 | Edit | Yes | Public | ||
STRDATTIM | Creation of Service Instance | Datetime | 15 | 0 | Unknown | Yes | Public | ||
UPDDATTIM | Last Update The date and time on when this service instance has been started. | Datetime | 15 | 0 | Unknown | Yes | Public | ||
UPDFRE | Update Frequency (in Hours) (-1 for 'no Update') | Numeric | 6 | 4 | Edit | Yes | Public | ||
CNTSUC | Count Successful | Numeric | 8 | 0 | Edit | Yes | Public | ||
CNTRET | Count Retry | Numeric | 8 | 0 | Edit | Yes | Public | ||
CNTERR | Count Errors | Numeric | 8 | 0 | Edit | Yes | Public | ||
CNTTIM | Period for Count (in Hours) | Numeric | 8 | 4 | Edit | Yes | Public | ||
STA | Status | Text | 1 | 1 | Edit | Yes | Public | Embedded |
Name | Fields | Properties |
---|---|---|
SYB_MGR | MGR, SRV, INS | |
SYB_SSNSRV | SSNINR, SRV | Unique |
SYB_STA | STA |
/
SRV, SSNINR
Transaction name of the manager.
Transaction name of the manager.
Name of the service instance.
Name of the instance for the service.
Session INR of the session executing the manager
ID of the session launching the Manager
Currently unused
Not currently used
The date and time on when this service instance has been started.
The date and time when this instance of the service was started.
Last date and time when this service instance record has been updated.
Date and time when this instance record was last updated.
Update frequency of a service in hours.
Update frequency of a service in hours.
Counter of successful completed service entries.
Counter of successful completed service entries.
Counter of retry attempts of in service entries.
Counter of retry attempts of in service entries.
Counter of errors of a service entry.
Counter of errors of a service entry.
Period for Count (in Hours)
Period for Count (in Hours)
Status of a service.
Status of a service.
Code | Text |
---|---|
R | Running |
X | Stopped due to errors |
I | Inactive |
T | Terminated |
S | During Start |
C | Recovered |