JP2743786B2 - Online subsystem execution system - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION This invention is, the main system smell
Terminates online transaction processing abnormally
In the subsystem connected to the main system,
To execute a part of the online transaction processing .

[0002]

2. Description of the Related Art The technique disclosed in Japanese Patent Application Laid-Open No. 1-147727 is related to recovery of a failure of an online program in which reserve of an online program is held and the effect of the online down is reduced by immediately switching to a spare system when the online goes down. Technology.

[0003] The technology disclosed in Japanese Patent Application Laid-Open No.
When a database failure occurs in a large-scale online system, by specifying the transaction that becomes a failure due to the database failure, the failure is localized,
This is a technology that facilitates failure recovery processing.

[0004]

Problems to be Solved by the Invention
In the technique disclosed in Japanese Patent Application Publication No. 7-127, it is necessary to keep a standby program in a state where a program of the same size can be immediately executed only in the event of a failure, and resources for the standby system must always be secured. There is a problem that it must not be.

In the technique disclosed in Japanese Patent Application Laid-Open No. 1-28737, only a failure with respect to a part of resources such as a database is dealt with, and the localization of the failure is achieved under the control of an online program. If an abnormality occurs in the online program itself, it cannot be dealt with, and there is a problem that it is not possible to execute any transaction until restarting.

[0006] It is an object of the present invention in a main system.
When online transaction processing ends abnormally
In the subsystem connected to the main system,
By executing a part of the online transaction processing, the abnormal termination of the online transaction processing is performed.
To minimize the impact of completion, as much as possible online tiger
Be able to execute transaction processing
And there.

[0007]

According to a first aspect of the present invention, there is provided an online subsystem execution system in which, when an online transaction process is abnormally terminated in a main system, the online transaction process is executed in a subsystem connected to the main system. An online subsystem execution system that executes a section, wherein the subsystem includes information indicating an operation state of online transaction processing of the main system and information indicating whether a main database of the main system is being updated. An online information table to be held, information of the partial online transaction processing executable in the own subsystem, and information of whether or not the online transaction processing updates data of the main database. Start the table, the batch input file to register online transaction processing for data update of the main database in its own subsystem, a self subsystem in response to the activation request by the user,
Refers to the online information table in response to the execution request of the partial online transaction processing, if the online transaction processing of the main system is abnormally terminated and the main database is not being updated, the business table A sub-start-up means for executing online transaction processing for not updating the main database with reference to the above, and registering the online transaction processing for updating the main database in the batch input file; And a sub-termination means for terminating the own subsystem in response to the request from the main system. In response to the activation request from the main system, the main database is being updated to another subsystem by the online information table of the other subsystem. Emotion And a batch input means for executing online transaction processing registered in the batch input file, wherein the main system starts its own main system in response to a start request by a user, wherein activating the collective input unit of the subsystem when the online transaction processing in the bulk input file subsystem is registered
Online list registered in the batch input file
Executes transaction processing and starts the main system.
After the completion of the startup process, accept all transactions
The main start-up means for starting and executing the requested online transaction processing until the end of the own main system, and terminating the own main system in response to an end request from the user, and abnormally terminating the online transaction processing in the own main system And a main ending means for storing information to that effect in the online information table of the subsystem.

The online subsystem execution system according to a second aspect of the present invention is the online subsystem execution system according to the first aspect, wherein the main activating means activates the sub-activating means, and the main ending means activates the sub-ending means. It has a configuration for activating the means.

A third line subsystem execution system of the present invention is directed to the line subsystem execution system of the first aspect of the invention, online in the main system
The abend in-transaction processing, has a structure in which the main termination means the start sub raising means, the previous SL collective input unit for activating the sub ending means.

[0010]

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below in detail with reference to the drawings.

Referring to FIG. 1, in an online subsystem execution system according to a first embodiment of the present invention, a main system determines whether each subsystem is operating, a reference database, and whether or not batch input is performed at the time of online recovery. A subsystem information table 1 to be managed, a main database 2 that performs reference and update processing by online transaction processing , a main start-up means 7 that performs processing from start-up processing to transaction processing of the main system, and performs end processing of the main system. It comprises a main ending means 9 and a data copying means 11 which is started by the main ending means 9 when an abnormality occurs in the online transaction and copies data from the main database 2 to the sub database 6.

Further, each subsystem is a main system.
Online transaction online information table 3 for holding the health and the main database updating information processing, de <br/> over data update portion of an executable online transactor <br/> transfection process and the online transaction processing in a job table 4 for holding the presence information, the batch input file 5 for storing the data update transaction collectively input image, a sub-database 6 to be referred to during subsystem operation, and launch subsystem, main
Online transaction processing in system
When an error occurs , a sub-startup unit 8 that performs from the start-up of the subsystem to processing of a partial transaction, and a sub-end unit 10 that performs a process of terminating the subsystem
And a batch input means 12 which is started by the main boot means 7 at the time of online restart and receives online transaction processing from the batch input file 5 of each subsystem, and establishes a terminal connection with the main system by the online operation state. It comprises terminal connection means 13 for distributing to the system.

The main structure of the embodiment will be described below.

The main system is a large-scale online system, can execute all transaction tasks, and can be operated only by this system unless a failure occurs. The difference from the conventional online system is that it holds the subsystem information table 1.

[0016] The subsystem is a main system.
Other than online transaction processing in which an error occurred
This is an online system that extracts online transaction processing .

The execution of a transaction in a subsystem is partly different from that of the main system. In the case of performing only data reference, the reference database is merely the sub-database 6, but in the case of performing data update, the content of the update processing is described in a batch input file. 5 to execute the transaction.

The subsystem information table 1 shown in FIG.
Manages each subsystem by a serial number, and at the same time, information on whether the subsystems are currently operating, terminated normally or abnormally, file code information of files constituting the sub-database 6, and a batch input file 5 Holds information on whether there is a batch transaction to be executed at the time of online startup.

The main database 2 is a database for referring and updating in an online transaction system.

The online information table 3 held by each subsystem shown in FIG.
It holds information on whether the transaction process is currently running, has been completed normally, or has been completed abnormally, and information on whether the main database 2 is being updated.

The business table 4 shown in FIG. 4 is a table for determining a transaction that can be executed in a corresponding subsystem. Executable transaction The name of the transaction and information on whether the transaction updates the database are stored. The user sets in advance a transaction that allows the user to refer to and update the data even while the information is online.

The batch input file 5 is stored in the main system.
Online transaction processing error occurs
Of some running in the subsystem online Toranzakushi <br/> tio emission process, a file that stores the necessary updating of main database 2 collectively input format, with the same structure as the conventional batch input file is there.

The sub database 6 is stored in the main system.
Online transaction processing error occurs
Some online transactions running in subsystems
A database tio down process makes reference, holds copied from the database Nomiome in database 2 to take advantage in each subsystem. Referenced and updated always follow the data file as required freshness of data can not be saved. The file codes of the files in this database are synchronized with the main database 2 so that it can be confirmed which file corresponds.

The data copying means 11 is connected to the main system.
In a state where the recovery of the file has been completed when an error occurs in the online transaction processing in the subsystem transaction table, it is checked which subsystem should be copied in the subsystem information table 1, and the contents of the main database 2 are copied to the corresponding sub database 6.

The batch input unit 12 receives a batch input from the subsystem that holds the batch input transaction and updates the main database 2. Batch input means 12
At the time of execution, the updating information of the main database 2 is notified to each subsystem, and when the batch input is completed, the batch input file 5 and the information that there is a batch input of the corresponding subsystem in the subsystem information table 1 are cleared. Finally, the sub system is notified that the updating information in the main database 2 has been cleared.

The terminal connection means 13 is constructed for each subsystem. When there is a terminal connection request, the operation status of the main system is checked from the online information table 3 of each subsystem. Connect to the system, connect to the subsystem if the corresponding subsystem is operating in the online end state, and reject the connection request if both are in the end state. The reconnection process when the terminal connected to the subsystem receives the forced disconnection request is also performed in the same manner. If the startup of the main system has been completed, the terminal is reconnected to the main system. Due to the presence of the terminal connection means 13, the terminal is newly connected to the subsystem only at the time of abnormal termination of the online operation.

Next, the operation of the first embodiment of the present invention will be described with reference to FIGS.

The start-up of the online system is performed by the main start-up means 7.

The main start-up means 7 searches the subsystem information table 1 before accepting a job when the online is started (step 5-1). If there is an input from the batch input file 5, the batch startup is performed. Means 12
Is started, the data of the main database 2 is updated by the transaction received by each subsystem, and all the batch input files 5 are cleared (step 5-2).

After the step 5-2 is completed, the main start-up means 7 notifies the online information table 3 of each subsystem of the completion of the main start-up (step 5-3).

After the end of step 5-3, the main start-up means 7 starts accepting a transaction, and performs transaction processing until the end (step 5-5).

When a request for normal termination of the online system is received and when an abnormality occurs in the online transaction , the main termination means 9 is activated.

The main ending means 9 outputs the online information table 3 of each subsystem if the online ends normally.
To the normal termination of the main system, and performs an online system normal termination process (step 6-1).

[0034] In the case of online transaction processing is abnormally terminated, or not a database recovery process, including the rollback processing, additional online information main system in table 3 abnormal termination information and database updating information of each sub-system, and The terminal disconnecting process of the connected terminal is performed (step 6-3).

After the end of step 6-3, the main ending means 9 activates the data copying means 11 (step 6--6).
4).

After the end of step 6-4, the main ending means 9 notifies that the updating information of the main database 2 has been cleared (step 6-5).

When the sub-starting means 8 is started by the user, the sub-system is started. When the startup of the subsystem is completed, the startup completion information is notified to the subsystem information table 1 of the main system (step 7-1).

The subsystem start-up means 8 executes step 7
After -1 completion of the input of the online transaction processing <br/> wait, from an online information table 3 if it is entered
Online transaction processing in the main system
Examine whether or not an abnormality sense has occurred (step 7
2) if 稼働中, forcibly cutting the terminal rejects the execution of the online <br/> transaction processing (Step 7
3).

Abnormality in online transaction processing
If you are generated, from the online information table 3 examines whether the update in the main database 2 (step 7-4), online transaction if updating
The execution of the process is rejected (step 7-5).

If the main database 2 is not being updated, a search is made as to whether a transaction exists in the business table 4 (step 7-6). If not, the execution of the transaction is refused (step 7-7). .

If a transaction exists in the business table 4, it is checked whether or not the transaction updates the database (step 7-8), and the transaction that only performs reference without updating the data is executed as it is. (Step 7-9).

The transaction for updating the data is executed by outputting the contents of the update processing to the batch input file 5 (step 7-10).

The subsystem start-up means 8 executes step 7
After -10, the online transaction processing
Transaction processing is continued during normal occurrence .

If there is an end request from the subsystem, the subsystem start-up means 8 starts the sub-end means 10 (step 7-11).

The sub-termination means 10 notifies the main subsystem information table 1 of information of normal termination or abnormal termination (step 7-12), and terminates the online system.

The main start-up means 7 is also used when the online transaction processing ends abnormally and is restarted.
Start

An error has occurred in online transaction processing.
During the occurrence, if there is no output in the batch input file 5 in the subsystem, a main startup completion notification is made in the online information table 3 of each subsystem in step 5-3, and a transaction is accepted in step 5-5. Is started and transaction processing is performed until the end.

When there is an input transaction in the batch input file 5, the batch input means 12 is started.
The processing of the batch input unit 12 when the online transaction processing is abnormally terminated and restarted is shown below.

From the main start-up means 7 to the collective input means 1
When the server 2 is activated, the batch input unit 12 notifies each subsystem of the updating information of the main database 2 (step 8-1). Since the subsystem that has been operating rejects transaction input based on this updating information, the subsystem is not added to the batch input file 5.

After the completion of step 8-1, the batch input means 12 checks from the subsystem information table 1 whether there is information indicating that there is a batch input transaction for each subsystem (step 8-2). If there is, the operation status of the subsystem is checked (step 8-3).

If the subsystem is abnormally terminated in step 8-3, the batch input unit 12 activates the sub-startup unit 8 (step 8-4). Then, it waits until the start of the subsystem is completed and the batch input file 5 becomes usable (step 8-6).

When the batch input file 5 becomes usable after the completion of step 8-6, the batch input means 12 accepts a transaction of the batch input file 5 as batch processing and updates the main database 2 (step 8-6). 7).

After the end of step 8-7, the batch input means 12 clears information indicating that there is a batch input transaction on the subsystem information table 1 and the batch input file 5 (step 8-8).

After the completion of step 8-8, the batch input means 12 proceeds to step 8-2 if there is an unexamined subsystem.
Returning to step 8-9, when the investigation has been completed for all the subsystems, the main system operating information and the updating of the main database 2 are cleared and each subsystem is notified of the clearing, and the online operation is started (step 8-9). Step 8-10).

As described above, the restoration of the main database 2 and the switching from the subsystem are completed, and the continuous execution of the online system can be realized. Further, if the disconnection and reconnection of the terminal are automatically performed, the user will not recognize the disconnection of the terminal or the interruption of online.

The processing of the online subsystem execution system, which is the operation of the first embodiment of the present invention, is completed.

[0057] line subsystem execution system according to a first embodiment of the present invention, o the main system
When online transaction processing ends abnormally,
In a subsystem connected to the main system,
Executing a part of online transaction processing minimizes the effects of abnormal termination of online transaction processing and minimizes online transaction processing.
Has the effect of being able to perform
ing.

Referring to FIG. 1, an online subsystem execution system according to a second embodiment of the present invention is the same as the online subsystem execution system according to the first invention.
The main starting means 7 starts the sub starting means 8,
The main ending means 9 activates the sub ending means 10.

Next, the operation of the second embodiment of the present invention will be described with reference to FIG. 1, FIG. 5, and FIG.

After the end of step 5-3, the main start-up means 7 requests each subsystem to start the sub-start-up means 8 before executing step 5-5 (step 5-4).

After the end of step 6-1, the main ending means 9 requests each subsystem to activate the sub ending means 10, and then ends the processing (step 6-2).

The online subsystem execution system according to the second embodiment of the present invention has an effect that the subsystem does not need to be aware of the activation and termination of the system as compared with the first embodiment.

Referring to FIG. 1, an online subsystem execution system according to a third embodiment of the present invention is different from the online subsystem execution system according to the first invention in that
Online transaction processing in the main system
The main termination unit 9 activates the sub-starting unit 8 when the processing ends abnormally, and the batch input unit 12 activates the sub-ending unit 10 when online restarting.

Next, the operation of the third embodiment of the present invention will be described with reference to FIGS. 1, 6, and 8.

After the end of step 6-5, the main ending means 9 activates the sub-starting means 8 of each subsystem (step 6-6).

After step 8-10, the batch input means 12 activates the sub-end means 10 for each subsystem (step 8-11).

The online subsystem execution system according to the third embodiment of the present invention is different from the first embodiment in that the subsystem is provided with an online transaction system in the main system.
By operating only at the time of abnormal termination of the action processing, it is possible to achieve an effective use of resources.

Referring to FIG. 1, an online subsystem execution system according to a fourth embodiment of the present invention is different from the online subsystem execution system according to the third invention in that
In the batch input unit 12, the sub-startup unit 8 is not activated when the subsystem abnormally ends.

Next, the operation of the fourth embodiment of the present invention will be described with reference to FIGS.

After the completion of step 8-3, the batch input means 12 proceeds to step 8-7 without executing steps 8-4 and 8-6.

In this embodiment, the batch input file 5
The sub-startup means 8 can be made accessible by others even when the file attribute of the
Need not be activated to make the batch input file 5 usable.

The online subsystem execution system according to the fourth embodiment of the present invention has the advantage that the main database can be updated without having to start up the abnormally terminated subsystem again, as compared with the third embodiment. have.

[0073]

As described above, the online subsystem execution system of the present invention can be implemented in the main system.
Terminates online transaction processing abnormally
In the subsystem connected to the main system,
By executing a part of the online transaction processing, the abnormal termination of the online transaction processing is performed.
To minimize the impact of completion, as much as possible online tiger
The effect of being able to execute transaction processing.
Have.

[Brief description of the drawings]

FIG. 1 illustrates first, second, third, and fourth embodiments of the present invention.
FIG. 3 is a block diagram showing an embodiment.

FIG. 2 illustrates first, second, third, and fourth embodiments of the present invention.
FIG. 5 is a diagram showing a configuration of a subsystem information table 1 according to the embodiment.

FIG. 3 illustrates first, second, third, and fourth embodiments of the present invention.
FIG. 8 is a diagram showing a configuration of an online information table 3 according to the embodiment.

FIG. 4 shows first, second, third, and fourth embodiments of the present invention.
It is a figure showing the composition of the business table 4 of an example.

FIG. 5 is a flowchart showing a process of a main start-up means 7 according to the first and second embodiments of the present invention.

FIG. 6 is a flowchart showing processing of a main ending means 9 according to the first, second, and third embodiments of the present invention.

FIG. 7 is a flowchart showing processing of a subsystem start-up means 8 and a sub-end means 11 according to the first embodiment of the present invention.

FIG. 8 is a flowchart showing processing of the batch input unit 12 according to the first, third, and fourth embodiments of the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Subsystem information table 2 Main database 3 Online information table 4 Business table 5 Batch input file 6 Subdatabase 7 Main start-up means 8 Sub-startup means 9 Main end means 10 Sub end means 11 Data copy means 12 Batch input means 13 Terminal Connection means

Claims (3)

(57) [Claims] 1. An online subsystem execution system for executing a part of the online transaction processing in a subsystem connected to the main system when the online transaction processing ends abnormally in the main system, the subsystem comprising: An online information table holding information indicating an operation state of online transaction processing of the main system and information indicating whether or not a main database of the main system is being updated; A business table holding information on the online transaction processing of the section and information on whether or not the online transaction processing updates the data in the main database; A batch input file for registering online transaction processing, and starting the own subsystem in response to a start request from a user, referring to the online information table in response to the partial online transaction processing execution request, If the online transaction processing of the main system has been terminated abnormally and the main database is not being updated, the online transaction processing which refers to the business table and does not update the main database is executed. For online transaction processing for updating a database, a sub-startup means for registering in the batch input file, a sub-end means for ending its own subsystem in response to an end request from a user, In response to the request, the other subsystem is notified to store information indicating that the main database is being updated in the online information table of the other subsystem, and the online registered in the batch input file is notified. Batch processing means for executing transaction processing, wherein the main system starts its own main system in response to a start request from a user, and online transaction processing is registered in the batch input file of the subsystem Activates the batch input means of the subsystem and
Online transactional cane that to force file has been registered
Execution process, and the startup process of the main system is completed.
After that, start accepting all transactions and
Main startup means for executing the requested online transaction processing until the in-system termination, and termination of the own main system in response to the termination request by the user, and when the online transaction processing in the own main system ends abnormally A main ending means for storing information to that effect in the online information table of the subsystem. 2. The online subsystem execution system according to claim 1, wherein said main activating means activates said sub-activating means, and said main ending means activates said sub-ending means. 3. Online in the main system
At abnormal termination of the transaction process, the main termination means starts the sub-raising means before Symbol line subsystem execution system of claim 1, collective input unit, characterized in that the start of the sub-ending means.