JPH096659A - Controlling system for data base journal recovery - Google Patents

Abstract

PURPOSE: To easily know the present progress state of the data base recovery processing. CONSTITUTION: A Journal file 4 stores the data base journal records. A journal record output means 3 writes the journal records in the file 4 and also stores in sequence the number of journal records written in the file 4 in a journal information storage part 9. A recovery means 6 recovers a data base file based on the journal records written in the file 4 and also stores in sequence the number of journal records and the time which are needed for storage of the data base file in a recovery information storage part 20. A recovery state output means 11 outputs the recovery state of the data base file to a console based on the total number of journal records stored in the part 9 and the number of journal records needed for the recovery and stored in the part 10.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database journal recovery control method for recovering a database file in which an error has occurred in an information processing system by using a journal record, and more particularly to a database journal recovery for displaying a status during database recovery on a screen. Regarding control method.

[0002]

2. Description of the Related Art A database file that has failed in an information processing system needs to be recovered using journal records. A simple message such as "" is displayed on the display, or information such as the recovery start time and the end time is output on the display as shown in Japanese Patent Laid-Open No. 5-114092.

[0003]

In the above-mentioned conventional method, although it is known that the recovery process is being performed during the database recovery process, it is possible to know when the process is completed and how far the process is progressing. For the operator, there is a drawback that the system management and the work plan cannot be sufficiently performed and the work efficiency is lowered.

[0004]

According to the present invention, there is provided a journal file for storing a database journal record for recovering a database file in which a failure has occurred, and a journal file to be written to the journal file and to be written each time the writing is performed. A journal record output unit that cumulatively stores the number of written journal records in a journal information storage unit that is provided in advance, and restores the database file by using the journal record written in the journal file and sets a predetermined first Recovery means for accumulatively storing the number of the journal records required for the recovery and the time required for the recovery in a recovery information storage unit for predicting the journal information in a predetermined cycle, and the journal information in a second predetermined cycle. The product stored in the storage unit Output to a console equipped beforehand with the recovery progress and the expected remaining processing time of recovery calculated from the number of journal records, the number of journal records required for the recovery stored in the recovery information storage unit, and the time required for the recovery. And a recovery status output means for performing the recovery.

[0005]

Next, the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the present invention.

According to the present invention, as shown in FIG. 1, a journal file 4 for storing a database journal record for recovering a failed database, and a journal record output means 3 for writing a journal record to the journal file 4, A journal information storage unit 9 for sequentially storing the number of journal records written in the journal file 4 by the journal record output unit 3, and a recovery unit 6 for recovering a database file using the journal records written in the journal file. A recovery information storage unit 10 for sequentially storing the number of journal records required for recovery and the time required for recovery during recovery of the database by the recovery means 6;
From the total number of journal records stored in the journal information storage unit 9 and the number of journal records required for recovery stored in the recovery information storage unit 10 and time, the progress and expected remaining processing time are sequentially calculated as the recovery status. And a recovery status output means 11 for outputting to the console.

Next, the operation of this embodiment will be described with reference to FIG.

First, in the application program 1, the database file 5 is passed through the database operating mechanism 2.
Is updated, the journal recovery operation mechanism 7 activates the journal record output means 3, the journal record output means 3 outputs the journal record to the journal file 4, and a valid journal record is output each time the journal record is output. The total number is stored in the journal information storage unit 9.

Next, when the database recovery process is performed by the database journal due to some failure, the recovery means 6 is activated from the database operation mechanism 2 via the journal recovery operation mechanism 7, and the journal file 4 is used. Recovery processing of the database file 5 is started. The recovery means 6 accumulates and stores the number of journal records required for recovery and the processing time thereof in the recovery information storage unit 10 in the first cycle at the same time when the recovery process starts.

On the other hand, the journal recovery operation mechanism 7 activates the recovery status output means 11, and in the second cycle,
The recovery unit 6 reads the number and time of the journal records stored in the recovery information storage unit 10 required for the recovery process, and the journal record output unit 3 reads the total number of journal records stored in the journal information storage unit 9 and restores them. The status is the progress ((number of journal records required for recovery processing / total number of journal records) x 100) and estimated remaining recovery processing time (time required for recovery / number of journal records required for recovery x
(Total number of journal records-number of journal records required for recovery processing) is calculated and displayed on the console 8. The first cycle and the second cycle may be the same, but generally, the second cycle is set to be larger than the first cycle in view of processing efficiency.

When the recovery processing is completed, the recovery means 6 notifies the journal recovery operation mechanism 7 of the end of the processing, and the journal recovery operation mechanism 7 notifies the recovery status output means 11 of the end of the recovery processing. The recovery status output means 11 stops the above recovery status output processing and displays a message of processing completion on the console 8.

FIG. 2 is a diagram showing an example of display information displayed on the console. This example shows the case where the degree of progress is 60% and the expected end time is 20 minutes, and the bar graph is highlighted in accordance with the degree of progress.

However, the display layout and the display items are not limited to the items shown in this embodiment, and in some cases, a recovery start time item is added or a journal other than the percentage of the progress degree It is also effective to display in the form of the number of records / total number of journal records), display by the estimated end time instead of the estimated remaining processing time, and further change these display colors.

[0015]

As described above, according to the database journal recovery control method of the present invention, how much recovery processing is currently performed during database recovery processing,
By displaying the degree of progress and the expected end time, the system management of the operator is facilitated, and there is an effect that the task planning and execution are facilitated.

[Brief description of drawings]

FIG. 1 is a block diagram showing one embodiment of the present invention.

FIG. 2 is a diagram showing a display example of a processing result according to the present invention.

[Explanation of symbols]

 1 Application Program 2 Database Operation Mechanism 3 Journal Recovery Operation Mechanism 4 Journal File 5 Database File 6 Recovery Means 7 Journal Recovery Operation Mechanism 8 Console 9 Journal Information Storage 10 Recovery Information Storage 11 Recovery Status Output Means

Claims (1)

[Claims] 1. A journal file for storing a database journal record for recovering a failed database file, a journal record to be written to the journal file, and the number of written journal records every time the writing is performed. A journal record output means for accumulating and storing in the journal information storage unit provided, and the journal file written in the journal file are used to restore the database file, and the restoration is required in a predetermined first cycle. Recovery means for accumulatively storing the number of the journal records and the time required for the recovery in a recovery information storage unit provided in advance, and the storage unit stored in the journal information storage unit at a second predetermined cycle. Cumulative number of journal records and previous The recovery status output which outputs the progress of recovery calculated from the number of journal records required for the recovery stored in the recovery information storage unit and the time required for the recovery and the estimated remaining processing time of the recovery to a console equipped in advance A database journal recovery control method characterized by comprising: