JPH07121419A - Data base restoration management system - Google Patents

Abstract

PURPOSE:To immediately execute a restoration operation and to concentrate on a restoration processing by means of a monitor and an operator by reporting information required for the restoration of an external storage file to the monitor and the operator when abnormality occurs in a job. CONSTITUTION:External storage file information used in a minute job is retrieved from a job management data base 4 and the presence or absence of a non-restored state is retrieved from a restoration situation management data base 5 before a job processing is executed. When the external storage file in the non-restored state exists, a message that the job processing is not to be executed is displayed. When the external storage file in the non-restored state does not exist, the minute job is executed and an executed result is recorded in the job management data base 4. When the execution of the job is re- execution for restoration after abnormality occurs, and the job normally executes the processing, external storage file information which is set to be the non-restored state when abnormality occurs is eliminated from the restoration situation management data base 5. Consequently, the external storage file can be used from other jobs.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to execution of a job (job) for referencing / updating an external storage such as a database or a file, performing a quick and smooth operation of a recovery operation when an abnormality occurs, a recovery means and a recovery state. It is applied to the operational management of the computer system that manages.

[0002]

2. Description of the Related Art In the operation management of a computer system, a system for performing an automated operation such as automatic start by designating a regular job (job) and monitoring the order between related jobs (jobs) is a conventional technique. However, when an abnormality occurs in a job, a recovery process is manually performed based on the recovery operation procedure manual prepared for each job. As a job (job) execution management method, a job end state notification method is known in Japanese Patent Publication No. 5-33407.

[0003]

The above-mentioned prior art is an operation management system centering on the management of the execution of jobs (jobs). For example, a regular operation of a regular job (job) or a preceding job (job) is performed. The purpose of this is to reduce the amount of operation operations by automating the start-up of subsequent jobs when the (job) ends. However, if any abnormality occurs in the job,
The fact that an abnormality has occurred is displayed on the display device, and it is only a warning to the observer.When recovering the database or file used in the job in which the abnormality occurred,
The recovery operation method differs depending on the job and the time of occurrence of an abnormality.Therefore, the supervisor and the operator should recover which database or file by what procedure based on the recovery operation procedure manual for each job. It was necessary to investigate the time, and the load on the observer and the operator was very high. In addition, until recovery is completed, it is necessary to suppress the unrecovered databases and files used in the job (job) in which the error occurred so that they will not be used in other jobs (jobs). However, in order to suppress, it is necessary to investigate the databases and files used by all other jobs. If the job (job) that is started at a fixed time is the target, an error will occur if the load on the supervisor and the operator is extremely high, such as when performing an operation to stop the automatic start, and if the suppression operation is missed. There was a risk of adversely affecting other than the job (job) in which the error occurred. For this reason, there is a need for a means for reducing the burden on the monitor and the operator when an abnormality occurs in a job.

An object of the present invention is to manage the names of external storage files such as databases and files used in jobs and recovery means when an abnormality occurs, so that when an abnormality occurs, an external storage that needs recovery Provide a method for displaying the storage file name and recovery method immediately, and a method for reducing the load on the monitor or operator by automating the suppression of execution of jobs (jobs) that use an external storage file that has not been recovered. Especially.

[0005]

In order to achieve the above object, the present invention provides an external storage file when an abnormality occurs in the execution of a job (job) that uses an external storage file such as a database or a file. Uses an external storage file with a storage unit that stores information necessary for recovery (external storage file name, recovery method, recovery processing name) to report to the operator or operator that recovery of There is provided means for referencing information necessary for recovery when executing a job (job) to be performed, and means for displaying information necessary for recovery when an abnormality occurs in the job.

According to the present invention, in executing a job (job) using an external storage file, if there is an external storage file in an unrecovered state and the external storage file is used, the job cannot be executed. A means for automatically judging whether or not there is a state and a means for reporting the reason why it cannot be executed to a supervisor or an operator are provided.

[0007]

According to the present invention, for each business (job) that uses an external storage file such as a database or a file, a business (job) is created based on the storage unit that stores the external storage file name to be used, the recovery means, and the recovery processing name. By reporting the information necessary for the recovery of the external storage file used when the job) occurred abnormally to the monitor or operator, the monitor or operator can be notified of the recovery operation immediately. it can.
Furthermore, based on the storage unit that stores the information on the external storage files that are in the unrecovered state, it is automatically determined whether or not the work that uses the unstored external storage files can be executed, and the reason why it cannot be executed is monitored Report to the administrator, the effect that the external storage file in the unrecovered state has on other jobs (jobs) will be clarified, and the effect of the external storage file in the unrecovered state on the monitor or operator needs to be investigated. Can be devoted to recovery processing.

[0008]

Embodiments of the database recovery management system of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram of an embodiment of a recovery management system. Reference numeral 1 is a display device for the recovery management system to display a message to a supervisor and an operator.
Is a console for activating the recovery process, 3 is a processing unit for controlling the system, and 4 is a business management database (hard magnetic disk) for recording and storing information of external storage files such as databases and files used by business. , Optical disk or floppy disk, etc.), 5
Records the recovery status of external storage files that need recovery.
It is a recovery status management database to be stored.

FIG. 2 is a block diagram showing an example of the business management database shown in FIG. In this example, the name of the external storage file to be used, the recovery means, and the execution status are configured for each job (job and job step). The recovery means, which is an item of the business management database, describes whether the external storage file used is recovered by any one of the following means when an abnormality occurs in the business. “AUTO”: Indicates that the database management system and the file management system are automatically restored when an abnormality occurs, and thus manual restoration is not necessary.
"BKUP": indicates that, when an abnormality occurs, it is necessary to recover from the latest backup obtained recently. “BKOUT”: Indicates that when an abnormality occurs, it is necessary to recover based on the history information that records the contents updated in the job in which the abnormality occurred.

FIG. 3 is a block diagram showing an example of the recovery status management database of FIG. In this example, the recovery-waiting external storage file name, recovery means, recovery status, and used business (job) name are used. This recovery status management database records the information of the external storage file that needs to be recovered when an error occurs in the business. The recovery status, which is one of the items, indicates the recovery status of the external storage file. The “RCV” task is in a waiting state for recovery processing from the time when an abnormality occurs until the recovery operation is performed. “RUN” represents a re-execution waiting state from the completion of the recovery process to the re-execution of the job in which the abnormality has occurred.

Database recovery management will be described below with reference to the flowchart of FIG.

A job (job) that uses an external storage file such as a database or a file stores information on the external storage file used in all detailed jobs (job steps) of the job from the job management database before executing the job process. The recovery status management database is searched for whether or not all the external storage files necessary for executing the processing are in the unrecovered state (step 101). Based on the retrieved information, it is investigated whether the task can be executed (step 102). If an unrecovered external storage file exists,
A message indicating that the job is not executed is displayed on the display device, and the job is ended (step 103). As a display example, when "DB-D" and "FILE-E" used in the detailed work "STEP3" of the work "JOB-1" are in the unrecovered state as in the embodiment of FIG. 3, "DB-" When a job "JOB-2" using "D" is to be executed, a message as shown in FIG. 5 is displayed, and it is necessary for the monitor or the operator to recover the external storage file that has not been recovered yet. Encourages you to be. If no unrecovered external storage file exists, job details (job step)
Is executed (step 104), and the status of the execution result is recorded in the business management database. For example, as shown in the example of FIG. 2, it is recorded that the detailed jobs “STEP-1” and “STEP-2” of the job “JOB-1” have been completed normally,
The fact that an abnormality has occurred is recorded in "STEP-3" (step 105). Also, when the execution of the relevant job is re-execution for recovery after an abnormality occurs and the relevant transaction has been processed normally, the external storage file information that was in the unrecovered state when the abnormality occurred is deleted from the recovery status management database. I do. As a result, the external storage file recovered from another job can be used. Then, the end of the job details (job step) is determined (step 106). If the job ends normally, execution of the subsequent job details is repeated until the final job details (step 107).

If an error occurs in the execution of the job details (job step), the external storage file information that needs to be recovered and the recovery means are displayed on the display device to terminate the job (step 108). ).

As a display example, for example, the job "JOB-1"
If an error occurs in the detailed work of "STEP-3" of
As in the embodiment shown in FIG. 5, "DB-D" and "FIL"
“EE” is an external storage file required for recovery, and prompts the administrator and the operator to perform recovery by “restore processing from backup” as a recovery means.

Further, the database recovery management system of the present invention is applied to the recovery processing. An example of the recovery management system in the recovery process is shown below.

External storage file recovery (step 11)
0) After completion, the fact that the external storage file to be recovered has changed from the waiting state for recovery to the waiting state for re-execution of the job in which the recovery process is completed and an error has occurred is reflected in the recovery status management database (step 111). Further, the restart position for re-execution of the job in which the abnormality has occurred is displayed on the display device (step 113), and the necessity of re-execution is urged to the supervisor or operator.

[0018]

As described above, according to the present invention, this system is used when managing the state of external storage files such as databases and files that are important in managing the execution of jobs. By doing so, it is possible to perform collective management, and it is possible to perform recovery without looking at the operating procedure manual for the types of external storage files and the means of recovery used in the work in which the abnormality occurred.
It becomes possible to systemize most of the work that supervisors and operators need to do, such as eliminating the need to investigate whether unstored external storage files will adversely affect other jobs. The effect is that efficient operation operations can be performed. Further, by displaying the recovery processing and re-execution means, an operation error can be prevented and the recovery processing time can be shortened.

[Brief description of drawings]

FIG. 1 is a block configuration diagram of an embodiment of a database recovery management system of the present invention.

FIG. 2 is a block diagram of an embodiment of a business management database.

FIG. 3 is a block diagram of an embodiment of a recovery status management database.

FIG. 4 is a flowchart showing a database recovery management process according to an embodiment of the present invention.

FIG. 5 is an example of information display of a job (job) in an unexecutable status.

FIG. 6 is an example of information display of a recovery external storage file.

[Explanation of symbols]

 1 ... Display device, 2 ... Operation console, 3 ... Processing device, 4 ... Business management database, 5 ... Recovery status management database.

Claims (3)

[Claims] Claim: What is claimed is: 1. In business (job) processing for referencing / updating an external storage file such as a database or a file, a type of the external storage file to be used and means for recovering the external storage file when an abnormality occurs in the business (job). A database recovery management system having a storage unit for accommodating. 2. In business (job) processing for referencing and updating external storage files such as databases and files, the type of external storage file to be recovered and recovery means and business (job) when an abnormality occurs in the business (job) ) The database recovery management system characterized by having a restart position display function. 3. In a job (job) process for referencing / updating an external storage file such as a database or a file, an abnormality occurs in another preceding job (job), and recovery of the external storage such as the database or file is completed. A database recovery management system characterized by having a storage unit that stores the recovery status of an external storage and an automatic determination function of whether or not a job can be executed depending on the recovery status.