¶ 1 Overview
RED provides a set of views in the database for monitoring purposes. Even the status of the RED-PSS can be monitored in this way using SQL-queries only. Therefore, it is not strictly necessary to monitor individual processes on OS-level.However, this guide concentrates on monitoring layer for ELT processes provided for end users and application managers mainly.Detailed documentation of individual columns in the referenced tables and views can be found directly in the database itself as column comments.
¶ 2 Naming Conventions
Process Control and Monitoring
¶ 3 Monitoring Views
¶ 3.1 Object Status (REDADM)
¶ 3.2 TSA-Loader Status (REDADM)
The related views in REDADM show status information of all TSA-connectors in the
system, i.e. DBI, CFI and custom connectors.
-
STA_TSA_QUEUED_LOADER: Shows the status of all TSA-loaders which are currently queued for execution (status: NOT SCHEDULED).
-
STA_TSA_ACTIVE_LOADER: Shows the status of all TSA-loaders which are currently in status SCHEDULED, RUNNING or FAILED. The column RUNTIME shows the actual runtime in seconds while RUNTIME_AVG shows the average runtime of this loader and RUNTIME_STDDEV shows the corresponding standard deviation of the sample.
The ALERT column switches to 1 if:
- the loader has been more than 30s in status SCHEDULED
- the RUNTIME > RUNTIME_AVG + 3 x RUNTIME_STDDEV (3-sigma rule)
The ALERT column switches to 2 if:
- the loader has been more than 60s in status SCHEDULED
- the RUNTIME > RUNTIME_AVG + 4 x RUNTIME_STDDEV (4-sigma rule)
-
STA_TSA LOADER_COUNT: Gives an overview (total count) of all not scheduled, scheduled, running and failed TSA loaders in the framework.
¶ 3.3 PSA-Loader Status (REDADM)
The related views in REDADM show status information of currently active PSA-loader processes.
-
STA_PSA_QUEUED_LOADER: Shows the status of all PSA-loaders which are currently queued for execution (status: NOT SCHEDULED).
-
STA_PSA_ACTIVE_LOADER: Shows the status of all PSA-loaders which are currently in status SCHEDULED, RUNNING or FAILED. The column RUNTIME shows the actual runtime in seconds while RUNTIME_AVG shows the average runtime of this loader and RUNTIME_STDDEV shows the corresponding standard deviation of the sample.
The ALERT column switches to 1 if:
- the loader has been more than 30s in status SCHEDULED
- the RUNTIME > RUNTIME_AVG + 3 x RUNTIME_STDDEV (3-sigma rule)
The ALERT column switches to 2 if:
- the loader has been more than 60s in status SCHEDULED
- the RUNTIME > RUNTIME_AVG + 4 x RUNTIME_STDDEV (4-sigma rule)
-
STA_PSA_LOADER_COUNT: Gives an overview (total count) of all not scheduled, scheduled, running and failed PSA loaders in the framework.
-
STA_PSA_CONTROL_DETAIL: Shows the full history of each and every PSA loader process.
¶ 3.4 Application Status (REDADM)
- STA_APP_OBJECT_STATUS: Shows the object status of all components of an application. The OBJECT_STATUS takes its values from STA_OBJECT_STATUS (see section 3.1) and LAST_CHANGE is taken from LAST_PSA_FINISH. Alert values are based on STA_OBJECT_STATUS as well. Note that this view ignores all loads which are not planned by a corresponding load cycle since they not relevant for an application status
- STA_APP_STATUS: Applications
- RED_APP_ACT_STATUS: Shows the status application actions for each BDate (information about the last run only).
- RED_APP_ACT_CONTROL_DETAIL: Shows detailed information of each action run (full history).
¶ 3.5 Connector Logs
For detailed log information regarding the data import from source to TSA check out the views CFIADM.CFI_IMPLOG_DETAILS and DBIADM.DBI_CDC_LOG_DETAILS, respectively. An aggregated status can be found in DBIADM.DBI_CDC_STATUS and CFIADM.CFI_IMP_STATUS, respectively.
¶ 3.6 redinfo
redinfo is a commandline tool which gives a (constantly refreshing) overview of the RED framework including watchers, jobs and active loaders as well as of the general status of the DB. It may be used for interactive monitoring.