7.5.4.6 Processing for End Batch

After establishing the required Java environment and initiating various Java processing activities, the Batch Control Utility does the following:
  1. Determines whether a batch is running by querying the KDD_PRCSNG_BATCH_CONTROL table (See Table 7-13 table) .
  2. Records information about the batch in the Table 7-13 table . This table contains a history of all batches that appear by start date and end date. The following figure illustrates a sample table query; an end time-stamp in END_TS and status of FIN in STATUS_CD for the bolded entry indicates that the batch has ended.

    Figure 7-3 Sample KDD_PRCSNG_BATCH_HIST Table—Batch End Status


    Description of Figure 7-3 follows
    Description of "Figure 7-3 Sample KDD_PRCSNG_BATCH_HIST Table—Batch End Status"

  3. Calculates the age of all open events and writes it to KDD_REVIEW.AGE if the EOD_BATCH_FL is Y in the KDD_PRCSNG_BATCH_CONTROL table.
  4. Updates the KDD_REVIEW table for all events from the current batch to set the Processing Complete flag to Y. This makes the events available for event management.
  5. Deletes any records in the KDD_DOC table that the system marks as temporary and are older than 24 hours.
  6. Logs a message in the <OFSAAI Installed Directory>/database/db_tools/logs/ batch_control.log file, stating that the end batch process has begun.