JPS62226236A - Intermission and restart processing system for state waiting resources in transaction processing system - Google Patents

Abstract

PURPOSE:To prevent deterioration of the processing capacity by interrupting a transaction whose forcible intermission is decided to release its resources and carrying on other transaction processing set under a resources waiting state. CONSTITUTION:A batch job A occupies a page (a) on a data base 23, for example, for a long period of time and a transaction (x) requests the page (a) while securing a page (b) to be set under a waiting state. While a transaction (y) requests the page (b) and set under a waiting state. Under such conditions an intermission propriety deciding means decides whether the waiting state of the transaction (x) should be intermitted or not. If the intermission is decided, the request of the transaction (x) for the page (a) is rejected and the page (b) is released. Thus the transaction (y) secures the page (b) and carries on its processing.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a transaction processing system, and particularly to a transaction processing system that prevents a decline in processing capacity due to resource waiting caused by a job that occupies resources for a long time. Processing method for reducing response time [Prior art] In an online transaction processing system that shares resources such as the same data cache with other batch jobs, there are batch jobs that occupy resources for a long time. In this case, conventionally, transaction processing that requests the resource is made to wait until the batch job releases the resource.

[Problem that the invention seeks to solve]

As mentioned above, in the conventional method of waiting for resources in transaction processing, if there is a batch job that occupies resources for a long time, the transaction processing that requests that resource continues to wait, so the resources held by that transaction processing are further used. A phenomenon may occur in which another user makes a request and continues to wait. For this reason, there is a drawback that multiple transactions are stalled due to the influence of batch jobs that occupy resources for a long time, the processing capacity of the transaction processing system is reduced, and transaction response time is also delayed.

The present invention solves these conventional drawbacks, and its purpose is to reduce the deterioration in the processing capacity of a transaction processing system caused by a transaction that attempts to secure resources occupied by a batch job continuing to hold the resources. The purpose is to prevent it.

[Means for solving problems]

In order to achieve the above object, the method of the present invention provides an online transaction processing system in which the same resources are shared with other batch jobs. If there is a transaction that waits for the release of resources occupied by the transaction, an interruptability determining means for determining whether or not the transaction should be forcibly interrupted; and forcing the transaction based on the result of the interruptability determining means. a forced suspension means that suspends the transaction automatically; a resource release means that releases the resources held by the transaction interrupted by the forced suspension means; The present invention comprises a processing progressing means for proceeding with the processing of another transaction that has been waiting by releasing resources, and a restarting means for restarting the transaction processing interrupted by the forcible interruption means.

[Effect]

If a transaction is waiting to release resources occupied by a batch job, the interruptability determining means determines whether or not the transaction should be forcibly interrupted, and if it is determined that the transaction should be interrupted, the forcibly interrupting means The transaction is forcibly interrupted, and the resources held by the transaction are released by the resource release means.

Then, if there is another transaction that was in charge of securing the resources held by the interrupted transaction, that processing is allowed to proceed by the processing progressing means, and the transaction processing that was interrupted by the forced interruption means is subsequently , restarted by the restart means.

〔Example〕

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

FIG. 1 is a block diagram of an embodiment of the present invention. Referring to FIG. 1, the resource waiting state in an online transaction processing system that shares resources such as the same data cache with other batch jobs can be seen. If there is a batch job that occupies resources for a long time, and there is a transaction that waits for the resource to be released, and continues to wait for a certain period of time, the transaction processing execution management unit 10, which performs the suspension and restart processing of Interruption possibility determination means 1 for determining whether or not to forcibly interrupt the process;
A forced interruption means 2 for forcibly interrupting the transaction, a resource release means 3 for releasing the resources held by the transaction, and a resource release means 3 for releasing the resources held by the transaction. a processing progressing means 5 that progresses transaction processing;
and restart means 4 for restarting the transaction processing.

Figure 2 shows the transaction processing execution management unit 10 in Figure 1.
This figure shows a situation in which a transaction processing system 20 including a batch job 21 uses a logical resource management unit 22 to share the same database 23.

Normally, some batch jobs 21 take a long time to complete, and transaction processing requires immediate processing. Here, the logical resource management unit 22 is used to manage exclusive control of the database 23.

FIG. 3 simply shows the page waiting state in the transaction processing system when batch job A occupies page a on database 23 for a long time. In FIG. 3, batch job A is running for a long time with page a on database 23 secured, and transaction X is running on page b on database 23.
Because page a of batch job A was requested while page a was secured, the page is in a waiting state. Furthermore, transaction y requests page b and is in a waiting state.

In such a situation, if transaction This embodiment attempts to avoid such a situation.

FIG. 4 shows the transaction processing execution management unit 10 in FIG.
This is a flowchart showing an overview of the interruption and restart processing from the page waiting state of the database 23 performed in the process, and the operation of this embodiment will be described below with reference to each figure.

When transaction X in FIG. 3 requests page a on the database 23, since page a has been secured by batch job A, transaction X cannot secure page a and proceed to the next process. The interruption possibility determining means 1 in FIG. 1 executes steps 41 to 44 in FIG.
Every fixed period of time, for example every 5 seconds, it is checked whether the number of transactions currently in the resource waiting state is equal to the total number of existing transactions42), and other transactions in the resource waiting state are It is checked whether there are any waiting transactions due to the reserved resources, and it is checked whether the number of waiting transactions in question is larger than a certain percentage of the transaction processing system, for example, one half, and the waiting time of transaction X is also checked. It is checked whether a certain period of time, for example, 5 minutes or more has passed (44), and YES is returned at any step.
When it is determined as S, it is determined that the waiting state of transaction X should be interrupted. In addition, as another example,
Even if it is determined YES in step 44, if there is no other transaction waiting for the resource owned by the transaction, the process may proceed to step 49 without proceeding to step 45.

Next, the forced interruption means 2 of FIG. 1 performs step 4 of FIG.
5.46, and through this processing, the waiting state of transaction X is interrupted, the request for page a is canceled (45), and the updated database is role hacked (46).

Then, the resource release means 3 in FIG. 1 releases page b held by transaction X, as shown in step 47 in FIG. Further, in the processing proceeding means 5 of FIG. 1, by securing the released page b, transaction y is extracted from the waiting state and processing proceeds.

Thereafter, in step 48 of FIG. 4, the restart means 4 of FIG. 1 restarts the transaction X as a transaction to be restarted from the beginning of the process.

FIG. 5 shows the state of the transaction processing system in which transaction y has secured page b and processing has proceeded, and transaction X has restarted.

Further, at step 49 in FIG. 4, the resource name, transaction name, and partner job name that are being waited for are output as a warning message to, for example, a system console at fixed time intervals, for example, every 30 seconds, while the resource is being waited for. Therefore, the user can now manipulate the batch job to free the pages and
It is also possible to increase the efficiency of the entire transaction processing system by prioritizing transaction processing.

In the above embodiments, database pages were treated as resources, but the present invention can also be applied to other resources, such as real storage devices, management files, etc.

〔Effect of the invention〕

As explained above, the present invention provides a method for processing when a transaction is waiting for the release of resources occupied by a batch job, and when it is determined by the interruptability determining means that the transaction should be forcibly interrupted. The transaction is forcibly aborted by the forced abort means, and its resources are released by the resource release means, so if there is another transaction that has secured the resource, the processing progress means will allow that process to proceed. Therefore, it is possible to prevent a reduction in processing capacity due to resource waiting in a transaction processing system caused by a batch job that occupies resources for a long time, and it is possible to shorten transaction run response time.

[Brief explanation of drawings]

FIG. 1 is a block diagram of one embodiment of the present invention, and FIG. 2 is a block diagram of an embodiment of the present invention.
An operational explanatory diagram of an embodiment of the present invention showing a situation where a transaction processing system 20 including the transaction processing execution management section 10 shown in the figure and a batch job 21 share and use the same database 23 using the logical resource management section 22. , FIG. 3 is an operational explanatory diagram of the embodiment of the present invention that briefly shows the page waiting state in the transaction processing system when batch job A occupies page a for a long time. FIG. 5 is an operational explanatory diagram of an embodiment of the present invention that briefly shows the state in which the processing of the transaction processing system has progressed due to processing for suspending waiting for transaction X. In the figure, 1... Interruption possibility determining means, 2... Forced interrupting means, 3... Resource release means, 4... Restarting means, 5... Processing progressing means, 10... Transaction processing. Execution management department, 21... Batch job, 22...
Logical resource management department, 23...database. Fruit of the present invention #E block diagram of example 1st fruit of the present invention! fij movement 1'F = explanatory diagram 2nd figure

Claims (1)

[Claims] In an online transaction processing system that shares the same resources with other batch jobs, there is a batch job that occupies resources for a long time, and the resources occupied by the batch jobs are released. an interruption possibility determining means for determining whether or not the transaction should be forcibly interrupted if there is a transaction waiting for the transaction; and a forced interruption means for forcibly suspending the transaction based on the result of the interruption possibility determining means. , a resource release means for releasing resources held by the transaction interrupted by the forced interruption means, and a resource release means for releasing the resources held by the transaction interrupted by the forced interruption means, Waiting for resources in a transaction processing system characterized by comprising a processing progressing means for proceeding processing of another transaction that has been suspended, and a restarting means for restarting the transaction processing that has been interrupted by the forcibly interrupting means. state suspension and restart handling method.