JPH11353214A - On-line transaction processing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To smoothly execute an in-operation command by making it possible to clearly and speedily judge whether or not the in-operation command normally ends and disconnecting the on-line transaction processing system from a user's batch job system. SOLUTION: An in-operation command interface process part 4 gives an identification number to the in-operation command which is inputted. According to the identification number, a client program part 5 receives a report on whether or not the in-operation command was executed together with the identification number or finds the said report according to the identification number. The on-line transaction system and user's batch job system are connected through standard protocol communication.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an online transaction processing system, and more particularly, to an online transaction processing system that assigns an identification number to an input operation command and monitors the execution of the operation command.

[0002]

2. Description of the Related Art As online transactions have become faster and larger in scale, operation commands input to an online transaction processing system may not be executed normally. To cope with such a deadlock, for example, Japanese Patent Application Laid-Open No. 9-269913 discloses an "online transaction processing system" in which a system administrator can control whether or not to re-execute a deadlocked transaction. Have been.

According to this publication, as shown in FIG. 7, when the occurrence of a deadlock is notified, the transaction execution control means requests a transaction re-execution. When the number of times of re-execution has reached the predetermined number of times in response to the re-execution request, the transaction control means puts the state of the transaction on hold and outputs a warning message to the master terminal device. Based on this, the system administrator determines the importance of the transaction, and issues a command that supports re-execution or abnormal termination to the online transaction processing system.

[0004]

However, in the above-mentioned prior art, the processing content is limited in that the number of re-executions is set. When it takes time to execute a command, the user must wait until the predetermined number of re-executions is reached, which wastes time.

Further, in the prior art, when a command is input from a batch job created by a user, in order to confirm whether or not the command has been executed normally, another command is used to check the current transaction status. I had to do it. Also, the batch job has to be executed in the system where the transaction is running.

Accordingly, the present invention is to customize a client program freely when inputting an operation command to an online transaction processing system so that it can be quickly and clearly determined whether or not the operation command has been completed normally. Is an issue.

It is another object of the present invention to execute an operation command smoothly by separating a user's batch job system from an online transaction processing system.

[0008]

According to the present invention, there is provided a client program unit for inputting an operation command, and an operation command interface process unit for receiving and analyzing the operation command from the client program unit. An online transaction processing system having an operation command execution process unit that receives and executes the operation command from the operation command interface process unit, wherein the operation command interface unit assigns an identification number to the operation command, The client command unit reports whether the operation command has been issued to the operation command execution process unit together with the identification number, and the operation command execution process unit determines whether the operation command has been executed together with the identification number. Reported compliant program interface section, the client program portion, a notification of whether the operation command is executed receives together with the identification number, or so that obtaining the notification on the basis of the identification number.

[0009]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an online transaction processing (OLTP) system of the present invention. As shown in FIG. 1, the OLTP operation command input system according to the present invention has a TP operating under program control.
It comprises an OLTP 1 comprising a monitor 2, an operation command execution process 3, an operation command interface process 4, a communication listener 6, and a transaction processing process 7, and a client program 5.

The operation command interface process 4 includes a command analysis unit 41, a command issuing unit 42, and a command result collection unit 43. The operation command execution process 3 includes a command execution unit 31, a command execution result analysis unit 32.
And

Next, the operation of the online transaction processing (OLTP) system of the present invention shown in FIG. 1 will be described.

The command analysis unit 41 analyzes an operation command received from the client program 5 by communication according to the standard protocol, and notifies the command issuing unit of the command. If the command issuing means has issued the command normally, the fact that the command was issued normally is returned to the client program.

The command issuing unit 42 notifies the command received from the command analysis unit to the command execution unit 31 in the operation command execution process 3 by adding a command identification number.

The command executing means 31 notifies the necessary process in accordance with the content of the command received from the command issuing means 42 and executes the command.

The command execution analysis unit monitors whether the command issued by the command execution unit 31 has been normally completed. If the command has been completed, it receives the result and the state of the OLPT. Then, when there is a request from the command result collecting means 43 in the operation command interface process 4, a notification is made.

When the command result collecting means 43 receives a command result request from the client program 5 which has issued the command by standard protocol communication based on the command identification number, the command execution result analyzing means 32 in the operation command execution process 3 sends the command to the command execution result analyzing means 32. The result is returned to the client program 5.

In FIG. 1, a client program 5
The OLTP1 operation command input from the server is transmitted to the command analysis means 41 in the operation command interface process 4.
To analyze the command input from the client.

The analysis result is passed to the command issuing means 42, which passes the command input by the client to the command execution means 31 in the operation command execution process 3. At this time, a command identification number is added. If the command analyzing means 41 and the command issuing means 42 can normally process the command input from the client, the command analyzing means 41 notifies the client that the command has been normally issued, together with the command identification number.

The command executing means 31 executes a command to the TP monitor 2 and the communication listener 6 according to the received command content. Then, the result is collected by the command execution result analysis means 32, and whether the command was executed normally is monitored based on the command identification number. Further, the client program notified that the command issuance has been performed normally, instructs the command result collection means 43 in the operation command interface process 4 from the command identification number whether the issued command result has been executed normally. Make an inquiry.

The command result collection unit 43 that has received the inquiry inquires the command execution result analysis unit in the operation command execution process 3 about the result of the command. At this time, if the command has been completed, the result is notified, and if not, the command result collection means 43 is notified that the command is being executed.

The command result collecting means 43 returns the received result to the client program 5. Here, the operation command interface process 4 only needs to open the interface of the command analysis unit 41 and the command result collection unit 43 to the client program 5. Further, by performing communication between the operation command interface process 4 and the client program 5 by a standard protocol, the operation command interface process 4 and the client program 5 need not be on the same machine.
It doesn't even have to be on the same platform.

In this way, the user can freely customize the client program 5 using the open interface when creating the client program 5. The created client program can be executed on a machine connected to the network, and the operation command can be executed. When the command is input, the result of the command can be obtained later from the command identification number, so that the client program can perform other processing during that time.

Next, the operation of the system of the present invention will be described in detail with reference to the flowchart of FIG.

First, a command input from the client program 5 by communication according to the standard protocol is received by the command analysis means 21 (step S1 in FIG. 2). Next, the command analysis unit 21 checks the grammar of the received command. Here, if there is a command error or a syntax error, an error is returned to the client 5 (step S2). Further, the command analysis unit checks the current state of the OLTP to determine whether the input command is executable, and notifies the command issuing unit 42 of the command if there is no problem. If the command cannot be executed, an error is returned to the client 5 (step S3). If the command issuing means determines that the command can be issued, it adds an identification number to the command (step S4).

Then, the command issuing means 42 issues a command to the command executing means 31 (step S5).

The command analysis means 42 passes the command identification number to the command analysis means 41 when the command is issued normally. If it cannot be issued normally, an error is returned to the command analysis means 41. Command analysis means 4
1 notifies the client program of the received command identification number or error (step S6).

Next, the command executing means 31 having received the command executes the command according to the contents of the command (step S8). Then, when the command execution means has successfully notified the command execution to the target process, the command execution means notifies the command execution result analyzing means 32 together with the command identification number. If it has failed, the failure is notified (step S9). The command result analysis means 32 notified of the command identification number monitors whether or not the command execution has been completed normally (process S10). Then, when the execution of the command ends normally, the result is collected (process S11).

The client program requests the command result collection means 43 for the command result based on the command identification number received from the command analysis means 41. The requested command result collecting means 3 requests the command result to the command execution result analyzing means 32 based on the command identification number, and receives the result. At this time, if the command execution has not been completed, a notification that the command is being executed is received (step S12, process 12).

Finally, the command result collecting means 43 which has received the command result notifies the client program of the result (step S13).

The above process can be summarized according to a specific example. For example, when a client program sends a command to a command analysis means by standard protocol communication, the command analysis means determines the grammar of the command and whether the command is executable. If there is no problem, the received command is transferred to the command issuing means. The command issuing unit that receives the command assigns a command identification number, issues the command, and returns the command identification number to the command analysis unit. The command analysis means returns the received command identification number to the client program and ends the processing. The client program receives the command identification number and the command issuing process is completed.

Next, when it becomes necessary to know the result of the command, the client program makes an inquiry to the command result collecting means by standard protocol communication based on the command identification number. The command result collection unit that has received this makes an inquiry to the command execution result analysis unit, has the result returned, and notifies the client program of the command result. The client program that has received the command result completes the command inquiry.

FIG. 3 is a block diagram showing the configuration of an online transaction processing system provided with the client management means 44 in the operation command interface process 4. Referring to FIG. 3, this online transaction processing system includes a client information management unit 44, a server information management unit 91, a client program 5, and a client program 6 in addition to the configuration of the operation command interface process 4 shown in FIG. The client 9 to which it belongs, the server information management means 91 and the client program 7 and the client 10 to which it belongs,
The difference is that the client program 8 has a download server 12.

When a command from a client program is received, the client information management means 44 acquires the information of the client, and manages a client that returns a return value and information for determining which command is the result inquiry. The acquired information is discarded when returning a response to the result inquiry from the client or when the client program instructs to discard it.

The server information management means 91 issues a command from a client or inquires the result,
Acquire / manage information of the issuing server. When the client program issues a command and ends before inquiring about the result, the client program notifies the client information management means 44 to discard its client information.

Next, the operation of the online transaction processing system having the client management means 44 will be described in detail with reference to the flowchart of FIG.

First, the client 9 downloads the client program 5 from the download server (Step S101). Next, an operation command is issued from the client 9 using the downloaded client program (step S102). When a command is issued from the client program, the server information management means 9
1 obtains information of a server to which a command is to be notified, and notifies the command (step S103). The operation command interface process 4 that has received the command (step S104) acquires information on the client that issued the command (step S105). After that, the received command is checked by the command analysis unit 41 to check the grammar and whether the environment is executable. At this time, if there is an error, an error is returned to the client, and the client information management means 44 discards the client information. If there is no error, the command is issued to the command issuing means (steps S106 and S107). The command issuing unit 42 that has received the command issues the command to the command executing unit 31 (Step S108). The command issuing unit 42 acquires the client information from the client information management unit 44 and issues a notification of the normal end of the command if the command is issued normally, or a failure notification if the command is issued unsuccessfully, and notifies the client. In the case of failure, the information of the client is discarded from the client information management means (step S109). Upon receiving the command, the command executing means 31 executes the command (step S111). If the execution of the command can be notified normally, the command execution unit 31 notifies the command execution result analysis unit 32 that the execution notification has been normally performed. If the notification fails, the command execution unit 31 notifies the command execution result analysis unit 32 of an error. (Step S1
12). The command execution result analysis unit 32 that has received the notification monitors the command execution end (step 113). When the execution of the command ends or the execution notification fails, the command execution result analysis unit 32 acquires the result.

On the other hand, the client program 5, which has been notified that the command has been issued normally, obtains a server for inquiring the result from the server information management means 91 and inquires the result. The command result collection unit 43 that has received the command result inquiry request determines which command result is to be received from the client information management unit 44, and obtains the result from the command execution result analysis unit 32 (S115). The command result collection unit 43 that has received the command result acquires a client program for notifying the result from the client division management unit 44 and notifies the client program.

At this time, the client information management means discards the client information (step S115).

Finally, the client program receives the command result and ends the processing (step S11).
6).

The above process will be summarized according to a specific example. For example, as shown in FIGS. 5 and 6, when a command is issued from a client program downloaded from a download server, the server information management means in the client issues a command. The server to which the command should be notified is acquired, and the command is notified to the server. The operation command interface process of the server receiving the command registers the client information in the client information management means and notifies the command analysis means of the command. The command analysis means checks the syntax of the command and the execution environment, and if there is no problem, notifies the command issuing means of the command. Upon receipt of the command, the command issuing means issues the command, and returns to the command analysis means that the command has been issued normally, and the notification is returned to the client obtained from the client information to be returned from the client information management means.

Next, when the client makes a command result inquiry, the server information management means recognizes the server to be inquired and makes an inquiry. The server that has received the inquiry determines which client command is to be inquired from the client information management information means, and notifies the command result collection means to collect the result. The command result collection unit that has received the notification inquires the command execution result analysis unit about the result of the command. The command result analysis means receiving the inquiry acquires which command result from the client information management means and returns the command result to the command result collection means. The command result collection unit that receives the result obtains the client information to return the result from the client information management unit and notifies the client of the result. At this time, the client information management means discards the client information. Finally, the client receives the result and completes the processing of the command result inquiry.

In FIGS. 5 and 6, even if an operation command is issued from a plurality of clients, the result of the result inquiry is properly sent to the client process which issued the command because the client information management means manages the client. It has a new effect of returning. There is no problem even if two client programs issue commands on the same client.

Further, if the client program can be downloaded from the download server and the server / client can recognize each other on the network, the operation command can be issued without limiting the client machine.

[0045]

According to the present invention described above, the user can freely customize the command input client program. The reason is that the operation command interface process makes it possible to input a command only by exposing only two simple interfaces of command input and result acquisition.

Further, according to the present invention, when it takes a long time to execute a command, the client program can perform processing irrelevant to the command from issuance of the command until obtaining the result of the command. The reason is that the command input and the command result acquisition are asynchronous by managing the input command with a command identification number.

Further, according to the present invention, a command can be input from a system other than the system in which the OLTP is operating. The reason is that a standard communication protocol was used for command input and result inquiry.

[Brief description of the drawings]

FIG. 1 is an online transaction processing system of the present invention.

FIG. 2 is a flowchart illustrating the operation of the online transaction processing system of the present invention.

FIG. 3 is an online transaction processing system of the present invention for managing client information.

FIG. 4 is a flowchart for explaining the operation of the online transaction processing system of the present invention that performs client information management.

FIG. 5 is an operation example of the online transaction processing system of the present invention that performs client information management.

FIG. 6 shows another operation example of the online transaction processing system of the present invention for managing client information.

FIG. 7 shows a conventional online transaction processing system.

[Explanation of symbols]

1 Online transaction processing system (OLT
P) 2 TP monitor 3 Operation command execution process unit 4 Operation command interface process unit 5 Client program unit 6 Communication listener 44 Client information management means 91 Server information management means

Claims (5)

[Claims] A client program unit for inputting an operation command; an operation command interface process unit for receiving and analyzing the operation command from the client program unit; and receiving and executing the operation command from the operation command interface process unit. An online transaction processing system having an operation command execution process unit, wherein the operation command interface process unit assigns an identification number to the operation command, and determines whether the operation command has been issued to the operation command execution process unit. To the client program unit together with the identification number, and the operation command execution process unit notifies the operation command interface process unit whether the operation command has been executed together with the identification number. Tell city, the client program portion, a notification of whether the operation command is executed receives together with the identification number,
Alternatively, an online transaction processing system, wherein the notification is requested based on the identification number. 2. A download server which downloads a client program to each of a plurality of clients, wherein the client program unit obtains and manages server information of the server, and wherein the operation command interface process unit comprises: 2. The online transaction processing system according to claim 1, wherein the client information is acquired and managed. 3. The operation command interface according to claim 2, wherein the client program unit terminates the operation command after issuing the operation command and before requesting the notification of the execution result of the operation command. 3. The online transaction processing system according to claim 2, wherein a request is made to a process unit to discard the client information. 4. The online transaction processing system according to claim 2, wherein said operation command interface processing section discards said client information when responding to said notification from said client program section. 5. The online transaction processing system according to claim 1, wherein said client program section and said operation command interface processing section are connected by standard protocol communication.