JPH08202586A - Connection monitoring system - Google Patents

Abstract

PURPOSE: To obtain a connection monitoring system which gives the information of the stoppage or the restoration of a data base management system(DBMS) to an application program at the time of the stoppage of the DBMS. CONSTITUTION: The connection monitoring system 12 is provided with a recognizing means, 14 to recognize the DBMS 30 to be a connected object, a monitoring means 15 to monitor the DBMS 30 to be the connected object at every definite period of time, an operating state informing means 16 to inform of the occurrence of the fault of the DBMS 30 to be the connected object, an acquiring and preserving means 17 to preserve the history of an accessing command from the application program 20 in a data file 40, and a restoration informing means 18 to inform of the restoration of the DBMS 30.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a connection between an application program (hereinafter abbreviated as AP) and a database management system (hereinafter abbreviated as DBMS), and particularly to a DBMS.
The present invention relates to a connection monitoring system that notifies a stoppage or restart notice to an AP when a stoppage occurs, and causes the AP to control its own operation based on the notification.

[0002]

2. Description of the Related Art Conventionally, the restoration of a DBMS is performed by a requester recording a request itself in a series of data processing units in a separate file and leaving a history when registering and updating database data with respect to the DBMS. When a failure occurs, a process other than the request side restores the DBMS using the history up to the state immediately before the failure. (For example, JP-A-6
3-089944). On the other hand, the requesting AP
Has forcibly terminated its own operation by stopping the DBMS. And when the DBMS is restored, A
P is restarted, it is reconnected to the DBMS, and the process is restarted immediately before the failure occurs.

[0003]

The above-mentioned conventional recovery / restart processing requires a function of creating a history file for recovery in the AP and the DBMS, and after the recovery of the DBMS by another process based on the history file, AP and DBMS must be restarted respectively. .

[0004]

The object of the present invention is to provide a DB
It is a provision of a connection monitoring system that notifies the AP of stoppage of the MS, the AP disconnects the connection of the DBMS, and terminates its own operation, or controls the AP itself to suspend its response waiting state.

Therefore, there is provided a connection monitoring system comprising an application program of the present invention, a database management system, and a connection monitoring means for monitoring the operation status of the database management system and notifying the application program of the operation status. The application program is based on the operation status notification, access means for connecting the database management system to obtain database data, communication means for receiving the operation status notification of the database management system from the connection monitoring means, Control means for controlling the operation of the application program itself, the connection monitoring means recognizing means for recognizing the name of the database management system to which the application program connects, and the data monitoring means. A monitoring means for monitoring the operating status of the base management system, an operating status notifying means for notifying the application program of the operating status of the database management system detected by the monitoring means, and the database management system issued by the application program An access saving means for acquiring the history of access commands and saving it in a data file; and a recovery notifying means for accepting the recovery of the operation status of the database management system from the monitoring means and notifying the application program, The connection between the application program and the database management system is controlled according to the operating status of the database management system.

[0006]

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

Referring to FIG. 1 showing the configuration of an embodiment of the present invention, the connection monitoring system 12 has an AP 20 for executing business processing in information processing, a DBMS 30 for storing data processed by the AP 20, and an operation of the DBMS 30. Connection monitoring means 13 for monitoring the situation and notifying the AP 20;
Is provided. The AP 20 is an access unit 2 that connects to the DBMS 30 and acquires or stores database data.
1, a communication means 22 for sending and receiving a notification of the name of the DBMS 30 and the operation status to the connection monitoring means 13, and a control means 23 for controlling the operation of the AP 20 itself based on the notification of the operation status. The DBMS 30 itself includes a connection and a database data transfer function for access from the AP 20 (not shown).

The connection monitoring means 30 recognizes the name of the DBMS 30 to which the AP 20 is connected, and the DBM.
The monitoring means 15 for monitoring the operation status of S30, the operation status notification means 16 for notifying the AP 20 of the failure of the DBMS 30 to be notified from the monitoring means 15, and the AP 20 to the DBMS
The storage unit 17 includes an acquisition / storing unit 17 that acquires a history of accesses to the data file 40 and stores it in the data file 40, and a recovery notification unit 18 that notifies the AP 20 of the recovery of the DBMS 30.

Next, the operation of this embodiment will be described with reference to FIGS. 2 to 12 for explaining the operating conditions.

The AP 20 has a DB
DBM when requesting database data to MS30
Connection processing is performed for S30 (step 1 in FIG. 2).
When this connection is successful, the AP 20 simultaneously activates the connection monitoring means 13 corresponding to the DBMS 30. The connection monitoring means 13 receives the name of the DBMS 30 and recognizes it.
Pass the name of the DBMS to 4 (step 2 in FIG. 3). The recognition unit 14 receives the DBMS received from the connection monitoring unit 13.
Based on the name of 30, management data is created and held. Next, the recognition unit 14 monitors the name of the DBMS 30 by the monitoring unit 1.
5 (step 3 in FIG. 4). Based on the name of the DBMS 30 received from the recognizing unit 14, the monitoring unit 15 starts monitoring the operation status of the DBMS 30 having the name at regular intervals (step 4 in FIG. 5). Under the supervision of the connection supervision means 13, the AP 20 accesses the DBMS 30 and starts acquisition and storage of database data.

An access command is issued from the AP 20 to the DBMS 30, and the access command is recorded by the acquisition / storing means 17 of the connection monitoring means 13 (step 5 in FIG. 6) and stored as a history in the data file 40. (Step 6 in FIG. 6). In the process, if the DBMS 30 stops for some reason, the AP
20 is in a state of waiting for a response from the DBMS 30 (state of FIG. 7).

Next, the monitoring means 15 detects the stop of the DBMS 30 and notifies the operation status notifying means 16 of the stop occurrence (step 7 in FIG. 8). The operation status notification means 16 notifies the AP 20 of the notification received from the monitoring means 15 (step 8 in FIG. 9). After receiving the notification from the operation status notifying means 16, the AP 20 waits for the recovery notification from the connection monitoring means 13 (step 9 in FIG. 10). After notifying the operating status notifying means 16 of the operating status, the monitoring means 15 monitors whether or not the DBMS 30 is restored at regular intervals and notifies the operating status notifying means 16 of the operating status. When the DBMS 30 is restored, the monitoring means 15
The restoration notification means 18 is notified of the restoration of the BMS 30 (see FIG. 1).
1 step 10). The recovery notifying means 18 is the monitoring means 1.
5, the name of the DBMS 30 created by the acquisition / storing means 17 is acquired from the data file 40 (step 11 in FIG. 11), and the AP 20 is notified of the recovery and the name (step 12 in FIG. 11). ).

Based on the recovery notification received from the recovery notification means 18 and the name of the DBMS 30, the AP 20 uses the DBMS 3
The contents of 0 can be transmitted again to the DBMS 30 one data unit at a time, and the state immediately before the failure can be restored (step 13 in FIG. 12).

According to the above description, in this embodiment, the AP 20 can disconnect the connection with the DBMS 30 and stop its own operation by receiving the stop notification from the operation status notifying means 16. Also, AP2
When 0 is in the response waiting state, the waiting state can be interrupted.

[0015]

As described above, according to the present invention, by interposing the connection monitoring means between the AP and the DBMS, the operation of the AP can be terminated or stopped by the control of the AP itself after the DBMS is stopped. Therefore, there is no need for the AP to restart after recovery, and the response waiting state can be avoided.

[Brief description of drawings]

FIG. 1 is a diagram showing a configuration of an embodiment of the present invention.

FIG. 2 is a diagram for explaining a state in which an AP and a DBMS have started a connection in the embodiment of FIG.

FIG. 3 is a DBMS in which the AP of FIG. 1 is connected to connection monitoring means.
It is a figure explaining the state which notifies the name of.

FIG. 4 is a diagram illustrating a state in which the recognition unit in FIG. 1 passes the name of the connection destination DBMS to the monitoring unit.

5 is a diagram illustrating a state in which the monitoring unit in FIG. 1 monitors the state of the DBMS at regular intervals based on the name of the designated DBMS.

FIG. 6 is a diagram illustrating a state in which the acquisition / storing means in FIG. 1 records a command from the AP to the DBMS and stores the command in a data file.

FIG. 7 is a diagram illustrating a state in which the DBMS of FIG. 1 has failed and the DBMS has stopped.

FIG. 8 is a diagram illustrating a state in which the monitoring unit in FIG. 1 notifies the operation status notifying unit of a failure occurrence due to the stop of the DBMS.

FIG. 9 is a diagram illustrating a state in which the operation status notification unit of FIG. 1 notifies the AP that a failure has occurred in the DBMS.

10 is a diagram illustrating a state in which the DBMS of FIG. 1 inquires about a recovery state until the fault is recovered by the operation status notifying means and the AP while the fault occurs.

FIG. 11: The DBMS of FIG. 1 is restored and the monitoring means is a DBM.
The recovery notifying means notifies the recovery notifying means that S has been recovered, and the recovery notifying means obtains the name of the DBMS from the acquisition storing means, and D
It is a figure explaining the state which has notified that BMS was restored.

FIG. 12 is a diagram illustrating a state in which the AP of FIG. 1 receives a restoration notification from the restoration notification unit and restores the DBMS to the state before the failure occurrence based on the data file.

[Explanation of symbols]

 12 connection monitoring system 13 connection monitoring means 14 recognition means 15 monitoring means 16 operating status notification means 17 acquisition and storage means 18 recovery notification means 20 application program (AP) 21 access means 22 communication means 23 control means 30 database management system (DBMS) 31 Recovery method

─────────────────────────────────────────────────── ─── Continuation of the front page (51) Int.Cl. ⁶ Identification code Internal reference number FI technical display location G06F 13/00 301 K

Claims (1)

[Claims] 1. A connection monitoring system comprising: an application program; a database management system; and a connection monitoring means for monitoring the operation status of the database management system and notifying the application program of the operation status. The program is an access unit that connects the database management system to obtain database data, a communication unit that receives an operation status notification of the database management system from the connection monitoring unit, and based on the operation status notification, Control means for controlling the operation of the application program itself, wherein the connection monitoring means recognizes the name of the database management system to which the application program connects, and the database management system. Monitoring means for monitoring the operating status of the system, operating status notifying means for notifying the application program of the operating status of the database management system detected by the monitoring means, and an access command for the database management system issued by the application program And a recovery notification unit that receives the recovery of the operating status of the database management system from the monitoring unit and notifies the application program of the recovery status of the database management system. A connection monitoring system, wherein the connection between a program and the database management system is controlled according to the operating status of the database management system.