Update statistics of PACG logs tables

The purpose of this program is updating the ‘Connector tables statistics data’. The report collects all the required data and updates it in the table. It can be found in FSM Connector Cockpit under top toolbar menu:

The report will open, inside it user must click on ‘Update Report’:

This selection is based on a list of valid tables:

/PACG/ECM_AHASH
/PACG/ECM_APRV1
/PACG/ECM_EOBREF
/PACG/ECM_FSMLGH
/PACG/ECM_FSMLGI
/PACG/ECM_FSMLGL
/PACG/ECM_MIDMAP
/PACG/ECM_MSIDIM
/PACG/ECM_SATT
/PACG/ECM_WRHSND

On the selection screen, it is possible to select the table for which statistics are to be updated. The selection allows as well to select the range of tables which wanted to be updated, for instance:

In this case all the tables will be updated.

The option ‘Save Log’ is enabled by default. The user can also choose to display the logs, and then when the report is successfully executed, the logs will be displayed. If the table is empty, the user will receive a warning about it. Otherwise, statistics are displayed.

The report can be scheduled to run as a job.