End Off-line Processing

The procedure to end off-line processing consists of checking for failed off-line transactions.  The user may choose to change and back up the journal receiver at this time, as well as at the end of online processing.  Otherwise, no further processing is required.  The Recovery Management Menu is used to perform this step.  The required user procedures are described below.  These procedures are illustrated in Figure 8.

End Off-line Processing.

How to End Off-line Processing

Note:    Steps 3 and 4 are optional.

End Processing Off-Line

Each morning, before you begin the daily processing, you should run the End Processing Off-line option found on the Recovery Management Menu (*see the Daily Procedures Section of this manual).  The End Processing Off-line option will search the system for failed transaction.  These failed transactions will most likely be batch transactions.

When to Run End Processing Off-Line

Run the End Processing Off-Line program first thing in the morning before any online processing has started for the day.  If someone has already logged on and has made database changes before the program is run, their changes could be backed out by this program.  Nothing will be rolled back unless a problem is found; however, if a problem is found everything processed after that problem will be rolled back if you choose the recover option using F22-Cont Recovery.  This includes all online database changes.

Off-line Processing

In order for failed batch jobs to appear on this screen, special processing is included with all batch programs that use the off-line processing program for recovery.  At the beginning of the job, these programs that perform a manual journal entry to the journal receiver with a Send Journal Receiver command (SNDJRNE).  The journal entry contains a begin stamp (BE) as well as an area stamp.  The area stamp tells whether it is a manufacturing, distribution, or financial program.  Upon successful completion of the job, the program performs another manual journal entry to the journal receiver, sending an end stamp (EN).

The off-line rollback program formats these begin and end stamps into a file and matches them.  Any begin stamp without an end stamp signifies a failed off-line job.  These failed jobs are candidates for recovery.  If you choose to recover the failed job, the recovery process will roll back the journal changes between the begin stamp that was missing an end and the next begin stamp.  Then, it will use the area stamp to roll back all changes in the same area that have occurred since the problem.  For example, the first financial job fails and every subsequent job is successful.  The effect of recovering the failed job will result in all posted financial jobs being rolled backed because they are based on incomplete data from the original posted job.

Priority Submits of Batch Jobs

MAC-PAC controls the submission of your batch jobs to make off-line recovery easier.  All jobs that use the manual journal entry processing are submitted with higher job priorities so they will run at the end of your nightly job stream.  Programs that do not perform a manual journal entry to the journal receiver (and therefore use commitment control) are submitted with lower job priorities so they will run at the beginning of your nightly job stream.  By allowing jobs that use rollback for recovery to run last, you minimize the processing that needs to be rolled back should a failure occur.  Submitting jobs with the correct job priorities will keep you from having to recover unnecessary jobs should a problem occur.

List of Batch Jobs Using End Off-Line Processing

Never run jobs using the manual journal entry processing during online hours.  Doing so can cause hours of online work being rolled back if recovery is performed.  Table 1 lists the batch jobs that use the manual journal entry processing as well as their job priority when submitted.  Be sure your batch jobs run in a single threaded job queue to take advantage of these job priorities.

Note     Reorganization programs are submitted with a job priority of 5.  You will probably need to run them over the weekend when you can have full control of your journal receivers.  When these programs perform their reorganize physical file member command (RGZPFM), they use a key file parameter (KEYFILE). This parameter changes the relative record number on the file it reorganizes.  When this is changed, the journal receiver attached to that file becomes unusable and must be changed.

      MAC-PAC programs using manual journal entry processing

     These programs are to be run at the end of your nightly batch run.