7.4.1.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.
  2. Records information about the batch in the KDD_PRCSNG_BATCH_ HIST table. This table contains a history of all batches that appear by start date and end date. The following sample illustrates a 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 alerts 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 alerts from the current batch to set the Processing Complete flag to Y. This makes the alerts available for alert viewer.
  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.