(Glue-2111) Structure Watchdog

Owned by SNP
Nov 22, 2021
2 min read

This watchdog periodically checks pairs DDIC Table ↔︎ Glue Table for differences in the structure and if found any, alters the target Glue Table based on the source DDIC Table.

Current option for alter is only appending new fields to the Glue Table.

This watchdog can be accessed via transaction /DVD/GL_SWD or via the GLUE gateway (transaction /DVD/GLUE).

The screen of the Glue Structure Watchdog consists of two main blocks:

  • Background job settings

  • Mapping configuration

Background job settings

  • Watchdog status - running/stopped

  • Last check - last run of the Structure watchdog

  • Next check - next scheduled run of the Structure watchdog

  • Background job name - name of the background job of the Structure watchdog

  • Execution period

    • Count of a time unit - numeric value

    • Unit - minutes/hours/days, etc.

Mapping configuration

  • Tables available for watching - tables that can be watched by the Structure watchdog

  • Tables selected for watching - tables that are being watched

  • Log - clicking on the log button, the application logs for the particular table are shown

 

Additional information

Table list

The Tables available for the watching list are not maintainable via the Structure Watchdog screen. The list is being created during the creation of the Glue table, although not every Glue table is fit for being watched by the Structure watchdog. The Glue table needs to be (almost) of the same structure as the DDIC table which are the fields imported from:

  • The user can add only the GLDELFLAG field (GLREQUEST is allowed also)

  • No field cannot be removed

  • No field cannot be changed type-wise

Except for these three rules, no other adjustments are allowed.

 

Saving the data

The data on the screen (settings + mapping) is saved into DB automatically when the watchdog is turned on. The user can save it also manually by clicking on the Save icon.