Report: /DVD/MON_HEALTH_CHECK
This report can be run through the transaction: SE38. Ask your consultant to run this report (checkboxes 1 - 3) and then sent the results back to us. You may use the functionality in the upper toolbar: press List >Save/Send, then File and select HTML Format or a other functionality. This way you receive the analysis as one document. After you send us the analysis, we will inform you about the results and if it is necessary, you will use 4th checkbox which deletes / repairs data.
This report contains 4 functionalities:
1. Check system ID length
Displays system IDs (SIDs) that have not correct length.
2. Check unknown system ID
Checks all tables and analyses, if any of the tables contain SIDs that do not exist in the table /dvd/mon_sysdef and displays all the erroneous SIDs. Each system ID must be in this table, in case it is not, this must be corrected.
When you want to check only some tables, the select option enables you to use different selection criteria, from single values, to ranges and exclusions.
3. Check detail table definition
Checks if a version of detail table is defined in main table of detail tables definition (/dvd/mon_detdef) and if such a table has any field definition, then it will check if a detail tables used in fields definitions table (/dvd/mon_detfld) are defined in main table of detail tables definition and if such a table has any version (/dvd/mon_detver). Also detail tables used for all SIDs will be checked if they are defined in main table of detail tables definition and if such a detail table has a version.
4. Check alert relations
All the alerts are defined in the master table /dvd/mon_evtdef. All the tables with the key field Monitoring alert name are checked. If there is some redundant data, you can repair it with the fix functionality.
Fix / Delete erroneous data
This checkbox deletes corrupted data displayed in 2. or 3. checkbox. To perform the deletion, mark other checkboxes along with the deleting one. If the 1st checkbox and the last one is marked, the incorrect SID length is repaired in every table and corrupted data is deleted.
Last check permanently deletes data from database tables displayed in check no 2. Before using this checkbox, always execute the other check boxes to first display the results. If there are data, which should not be deleted, use the exclusion in select option (check number 2).
Output from this check is available right after the execution or in SLG1 after selecting:
Object: /dvd/mon
Subobject: /dvd/mon_checks
External ID: name of check (may be empty to display all the checks)
Double-click the log to display further information.