The rows in the database table are uniquely identified by their row identification number. These rows are defined in several different logical files which are not shipped with the system and must be created by the user, if desired. The logical files can be created with the DDS shown in Database monitor logical file DDS. The column descriptions are explained in the tables following each figure.
| Note: | The database monitor logical files are keyed logical files that contain some select/omit criteria. Therefore, there will be some maintenance overhead associated with these tables while the database monitor is active. The user may wish to minimize this overhead while the database monitor is active, especially if monitoring all jobs. When monitoring all jobs the number of rows generated could be quite large. |
Minimizing maintenance overhead
Possible ways to minimize maintenance overhead associated with database monitor logical files:
By minimizing the maintenance overhead at run time, you are merely delaying the maintenance cost until the database monitor logical file is either created or opened. The choice is to either spend the time while the database monitor is active or spend the time after the database monitor has completed.