JPH0383148A - Transaction recovery system - Google Patents

Abstract

PURPOSE:To automatically relieve a transaction at the time of the occurrence of trouble in a data base and to restore and execute it by providing a transaction managing means, a transaction saving means, and a transaction restoring means. CONSTITUTION:A transaction managing means 11 uses a transaction management table to manage relations between transactions and data bases used by them and trouble information of each data base. If trouble occurs in a data base 3, a transaction saving means 12 refers to the transaction management table updated by the transaction managing means 11 to save a transaction to a relief file 4; and when trouble of the data base 3 used by the saved transaction is recovered, a transaction restoring means 13 restores the transaction from the relief file 4 to execute it. Thus, the transaction is automatically relieved and is restored and executed at the time of the occurrence of trouble in the data base 3.

Description

[Detailed Description of the Invention] [Field of Industrial Application] The present invention relates to a transaction recovery method, and more particularly to a transaction recovery method that automatically rescues transactions accessing a database when a database failure occurs in a transaction processing system. Regarding.

[Conventional technology]

Conventionally, in transaction processing systems, when a failure occurs in a database, a command is used to prohibit the submission of transactions that access the database, or the program corresponding to the transaction performs rescue processing itself.

[Problem to be solved by the invention]

In the conventional transaction processing system described above, when a database failure occurs, the submission of transactions accessing the database is prohibited using a command, or the program corresponding to the transaction performs rescue processing itself. The problem is that the card cannot be input until the fault is recovered, or the program must perform the rescue process itself.

In view of the above points, it is an object of the present invention to automatically rescue transactions when a database failure occurs, and to
An object of the present invention is to provide a transaction recovery method that enables transactions to be restored and executed after recovery from a database failure.

[Means to solve the problem]

In an online transaction processing system, the transaction recovery method of the present invention includes a transaction management means that uses a transaction management table to manage the relationship between transactions and databases used by transactions and failure information for each database, and transaction saving means for saving the transaction to a relief file when it is determined that execution of the transaction needs to be suppressed by referring to the transaction management table updated by the transaction management means; and transaction restoring means for restoring and executing the transaction from the relief file when a fault in the database used in the transaction saved by the saving means is recovered.

[Effect]

In the transaction recovery method of the present invention, the transaction management means uses a transaction management table to manage the relationship between a transaction and the database used by the transaction and failure information for each database, and the transaction saving means manages the relationship between a transaction and the database used by the transaction and failure information for each database. Refers to the transaction management table updated by the transaction management means and saves the transaction to a relief file when it is determined that it is necessary to suppress the execution of the transaction.
A transaction restoring means restores and executes a transaction from a relief file when a fault in a database used in a transaction saved by a transaction saving means is recovered.

〔Example〕

Next, the present invention will be explained in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a transaction recovery system according to an embodiment of the present invention. The transaction recovery system of this embodiment includes a transaction processing system 1 and a transaction recovery system. A terminal 2 into which commands etc. are input, a plurality of databases 3 (two shown) which are referenced and updated as transactions are executed, and a rescue file 4 which saves and rescues transactions. The department is made up of:

The transaction processing system 1 includes a transaction processing management section 5, a database management system 6,
It includes a plurality of (two shown in the figure) tasks #1 and #2 that execute transactions.

The transaction processing management unit 5 includes a transaction management means 11 that manages the relationship between a transaction and a database used (accessed) by the transaction and failure information for each database using a transaction management table 7 (see FIG. 5), and a database 3. transaction saving means 12 which refers to the transaction management table 7 updated by the transaction management means 11 and saves the transaction to the relief file 4 when it is determined that execution of the transaction needs to be suppressed when a failure occurs; and a transaction restoring means 13 for restoring the transaction from the relief file 4 and executing it when the fault in the database 3 used in the transaction saved by the transaction saving means 12 is recovered.

Referring to FIG. 2, the processing in the transaction management means 11 includes database failure/recovery determination step 2.
1, failure information setting step 22, transaction recovery request step 23, failure information clearing step 2
It consists of 4.

Referring to FIG. 3, the processing in the transaction saving means 12 includes the database failure occurrence determination step 31.
, transaction failure occurrence database use determination step 32 , transaction save processing step 3
3 and a normal transaction processing step 34.

Referring to FIG. 4, the processing in the transaction restoring means 13 consists of a step 41 of determining whether or not to save a transaction, and a step 42 of transaction restoring processing.

Referring to FIG. 5, the transaction management table 7 provided in the transaction processing management section 5 is as follows:
It is created statically by the system generation of the transaction processing system l, and has multiple transaction types (■~■).
Information indicating whether the database 3 (■ and ■) is used or not is stored for each. Furthermore, the transaction management table 7 stores failure information for each database 3.

Next, the operation of the transaction recovery system of this embodiment configured as described above will be explained.

Transaction management means 11 handles tasks #1 and #
When an access request is issued to the database 3 from a transaction-compatible program running on the Terminal 2, and the database management system 6 detects a failure in the database 3, and when the failure in the database 3 is recovered, a recovery notification is sent from the terminal 2 using a command. (Hereinafter, this command will be referred to as a transaction rescue command), control is transferred.

The transaction management means 11, which has been given control, determines whether a fault has occurred in the database 3 or whether the fault in the database 3 has been recovered and a Trump 3 recovery command has been input (step 21). If the error occurs, the error information is entered in the corresponding database 3 column of the transaction management table 7 (step 22). On the other hand, if the error in the database 3 is recovered and a transaction rescue command is input, the transaction The management means 11 issues a transaction restoration request to the transaction restoration means 13 (step 23), and clears the failure information in the corresponding database 3 column of the transaction management table 7 (
Step 24>.

The transaction saving means 12 saves the transaction management table 7 when a transaction is input.
Step 31) to determine whether a failure has occurred in database 3 (whether or not failure information has been set) by referring to If database 3 is used, the transaction is saved to relief file 4 without being executed (step 33). On the other hand, if database 3 has failed, If there is no failure, or if the transaction does not use the database 3 where the failure has occurred, the transaction is executed as is on task #1 or #2 where the corresponding program is running (step 34).

In order to restore and execute transactions from the relief file 4 when the failure of the database 3 is recovered,
When the operator inputs a transaction rescue command from the terminal 2, the transaction management means 1
1, a transaction restoration request occurs. In response to this transaction restoration request, the transaction restoration means 13 checks whether the transaction has been saved in the relief file 4 (step 41), and if the transaction has been saved in the relief file 4, the is restored from the rescue file 4 to the transaction processing system l and the transaction is executed by task #1 or # where the corresponding program runs.
2 (step 42).

By performing the above processing, when a failure occurs in the database 3, transactions that access the database 3 are automatically saved in the relief file 4, and when the failure in the database 3 is recovered, the saved transactions are saved. The transaction processing system 1 can be restored from the rescue file 4 and executed.

〔Effect of the invention〕

As explained above, the present invention provides a transaction processing system with a transaction management means, a transaction save means, and a transaction restore means, so that the database can be recovered from failures without having to perform transaction relief processing by the program itself. This has the advantage that the transaction can be automatically rescued when a database failure occurs, and the transaction can be restored and executed after the database failure has been recovered.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of a transaction recovery system according to an embodiment of the present invention, FIG. 2 is a flow chart showing the processing of the transaction run management means in FIG. 1, and FIG. FIG. 4 is a flowchart showing the processing of the transaction saving means in FIG. 1; FIG. 5 is an example of a transaction management table used by the transaction processing management section in FIG. 1. It is a diagram. In the figure, l...Transaction processing system, 2...Terminal, 3...Database, 4...Relief file, 5...Transaction processing management section, 6...Database management system, 7... -Transaction management table, 11...Transaction management means, 12...Trump Kushikun 1JAj1! Means, 13...
Tiger azalea 5 restoration means, #1. #2 - Task. Figure 2: Management means 11 Figure 3: Evacuation means 12

Claims (1)

[Claims] In an online transaction processing system, there is provided a transaction management means for managing the relationship between a transaction and a database used by the transaction and failure information for each database using a transaction management table; transaction saving means for saving a transaction to a relief file when it is determined that execution of a transaction needs to be suppressed by referring to the transaction management table updated by the transaction management means; 1. A transaction recovery method comprising: transaction recovery means for restoring and executing a transaction from the relief file when a failure in a database used in a transaction is recovered.