JPH08241279A - Dbms control system - Google Patents

Abstract

PURPOSE: To reduce the operation load of the start/termination of an on-line system by making only a TP monitor (transaction processing program) have a function controlling a DBMS (data base processing program), without providing a special function by the DBMS. CONSTITUTION: A TP monitor 17 determines the process name of a DBMS 16 from a definition file 13 after the DBMS 16 is started and determines the identification data of the process based on the process information operating on a machine. A DBMS control program prepares the correspondence table composed of the process name and process identification data. Further, the TP monitor 17 monitors the existence of each process composing the DBMS16 at a fixed time interval while the DBMS is working based on the correspondence table of the process name and the process identification data, till a termination instruction is detected. When the process composing the DBMS 16 designated as the definition is abnormally terminated due to a fault, the DBMS 16 is started again after the DBMS 16 is temporarily and compulsorily stopped.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a DBMS control system, and more particularly to a transaction processing program (hereinafter,
"TP monitor") and database processing program
In an online system with (DBMS), D
A DB that reduces the burden on the DBMS user by enabling BMS activation / termination and survival (presence) monitoring.
Related to MS control system.

[0002]

2. Description of the Related Art Conventional general TP monitor and DBMS
In an online system having the following, for example, as described in Nikkei Computer Supplement “Towards Business System Construction in UNIX Environment” (published on July 30, 1993), pages 135 to 139, regarding the cooperation between the TP monitor and the DBMS, X / Ope
n TP monitor to DBM such as XA interface
There was only an interface that could control the direction to S.

[0003]

The above prior art does not consider that the system operator operates such that the TP monitor and the DBMS are started and terminated as one online system, and the system is not considered. It lacked consideration for simplifying and improving the efficiency of operator operations. The present invention has been made in view of the above circumstances,
The purpose is to solve the above-mentioned problems in the prior art, and in an online system having a TP monitor and a DBMS, the system operator can start and end the TP monitor and the DBMS as one online system. It is to provide a DBMS control system capable of operating.

[0004]

The above-mentioned object of the present invention is to
In an online system having a P monitor and a DBMS, the TP monitor starts the DBMS, waits for completion of the start of the DBMS and completes the start of the DBMS, and ends the DBMS. DB
Obtaining the names of a plurality of processes configuring the MS from the definition file, and means for monitoring the existence of these processes and detecting that at least one of the processes configuring the DBMS is abnormally terminated using the monitoring means If you do
A DBMS having means for restarting the DBMS, wherein the DBMS is controlled by the respective means.
This is achieved by the S control system.

[0005]

In the DBMS control system according to the present invention, the DBMS does not provide a special function, and only the TP monitor has the function of controlling the DBMS, so that the online system including the TP monitor and the general DBMS is provided. It is possible to reduce the operation load of starting and ending.

[0006]

Embodiments of the present invention will now be described in detail with reference to the drawings. FIG. 1 is a configuration diagram of an online system including a TP monitor and a DBMS according to an embodiment of the present invention. In the online system according to the present embodiment, the computer system 11 is connected to the terminal systems 14 and 15 and the database 111. Computer system 1
1, the TP monitor 17, the DBMS 16, and the application programs 112, 113, 114 operate.

DBMS which is a program in the TP monitor
The control program 12 includes DBMS starting means 12a and D
BMS termination means 12b, DBMS monitoring means 12c,
When the monitoring means 12c detects at least one abnormal end of the processes constituting the DBMS, the DBMS
12d for restarting the system, based on the contents of the definition file 13 created by the user of the system based on the configuration of his / her own DB (database), which is the feature of this embodiment, the starting of the DBMS. -End and confirm the existence of the DBMS process.

Data inputted from the terminal system 14 or 15 activates one application program and executes a transaction. If the reference / update of the database is involved, the corresponding application program accesses the database 111 via the DBMS 16. FIG. 2 shows the T according to the present embodiment.
FIG. 3 is a flow chart showing the procedure for starting the DBMS by the P monitor, and FIG. 3 shows the DBMS by the TP monitor according to this embodiment.
A flow chart showing the procedure for stopping the process, FIG.
FIG. 5 is a flowchart showing the procedure of restarting when a BMS failure occurs, and FIG. 5 is a diagram showing an example of the contents of the definition file 13 described above.

The operation of the TP monitor in the online system according to this embodiment will be described below with reference to the drawings. When the system is started, the TP monitor 17 displays the TP
Whether or not there is a DBMS to be used by the monitor is recognized from the definition file 13, and if there is a DBMS to be used, there is a start request (step 21). DBMS1 based on the start command (53 in FIG. 5) described in the definition
6 is activated (step 22). TP monitor 17 is a DB
After starting MS16, confirm that the startup of DBMS16 is complete.
(Step 25), it goes online.

Further, the TP monitor 17 starts the DBMS 16 and then executes the process name of the DBMS 16 (5 in FIG. 5).
1) is obtained from the definition file 13 and the process identifier is obtained based on the process information operating on the machine.
Then, the DBMS control program creates a correspondence table composed of the process name (61 in FIG. 6) and the process identifier (62) (step 23). Then, the TP monitor 17
Until the end instruction is detected (step 41), based on the correspondence table of process names and process identifiers (see FIG. 6), D
During the operation of the BMS, the existence of each process constituting the DBMS is monitored at regular time intervals (step 42).

The TP monitor 17 is the DBM specified in the definition.
When the process (51 in FIG. 5) that constitutes S is abnormally terminated due to a failure, once the DBMS is forcibly stopped based on the forced stop command (54 in FIG. 5) described in the definition (step 43), Start the DBMS again (Step 4)
4). The DBMS control program creates a correspondence table composed of process names and process identifiers as in the first activation (step 45). When the TP monitor ends, it is recognized whether or not the DBMS is activated (step 33). When the DBMS is activated, the stop command (52 in FIG. 5) described in the definition is used. In the DBMS
Is stopped (step 34).

According to the present embodiment, the TP monitor having the above-mentioned function and the general DBM having no special function are provided.
Even when S and S are configured as one online system, it is possible to reduce the operational load of the system user for starting and ending the system. Furthermore, the TP monitor can be automatically restarted even when the DBMS ends abnormally, and the load on the system user can be reduced. It is needless to say that the above embodiment shows one example of the present invention, and the present invention should not be limited to this.

[0013]

As described above in detail, according to the present invention, in the online system having the TP monitor and the DBMS, the system operator can operate the TP monitor and the DBMS.
It is possible to realize a DBMS control system in which S and S are used as one online system to perform start / end operations.

[Brief description of drawings]

FIG. 1 is a TP monitor and a DBMS according to an embodiment of the present invention.
It is a block diagram of an online system including.

FIG. 2 is a flowchart showing a procedure for starting a DBMS by a TP monitor according to an embodiment.

FIG. 3 is a flowchart showing a procedure for stopping a DBMS by a TP monitor according to an embodiment.

FIG. 4 is a flowchart showing a procedure of restarting at the time of a DBMS failure by the TP monitor according to the embodiment.

FIG. 5 is a diagram showing an example of contents of a definition file 13 according to the embodiment.

FIG. 6 is a table of control information for DBMS process monitoring by the TP monitor according to the embodiment F.

[Explanation of symbols]

 11 Computer System 12 DBMS Control Process 12a DBMS Starting Means 12b DBMS Ending Means 12c DBMS Monitoring Means 12d Means for Reactivating DBMS at Abnormal Termination 13 Definition File 14, 15 Terminal System 16 DBMS 17 TP Monitor 111 Data Base 112 , 113,114 Application programs

Claims (1)

[Claims] 1. Transaction processing program (TP
Monitor) and a database processing program (DBMS), the TP monitor has means for starting the DBMS, means for waiting for completion of the start of the DBMS to complete its own start, and the DBMS.
At least the means for terminating S, the means for obtaining the names of a plurality of processes configuring the DBMS from the definition file, and monitoring the existence of these processes, and the process for configuring the DBMS using the monitoring means. A DBMS control system comprising: means for restarting the DBMS when one of the terminals is detected to be abnormally terminated, and the DBMS is controlled by the respective means.