JP2000076198A - On-line processing fault information notifying method and system therefor - Google Patents

Abstract

PROBLEM TO BE SOLVED: To segment fault occurrence in an application server or a data base server, to notify it to a client user and to quickly specify a fault occurrence part on the occurrence of fault. SOLUTION: The fault occurrence of the application server 2 or the data base server 3 in an on-line system composed of a client 1, the application server 2 and the data base server 3 is segmented and notified (reported). First, incoming information is transmitted from the client 1 and the application server 2 receives the incoming information. The application server 2 prepares fault information from a fault log on the occurrence of the fault and further, transmits the fault information to the client 1 as outgoing information. The client 1 receives the fault information of the outgoing information and the fault occurrence in the application server 2 is transferred to an external device, displayed on a screen, outputted by synthetic voice, sound outputted and reported.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to an on-line system including a client, an application server, and a database server, which isolates and notifies (reports) the occurrence of a failure in an application server or a database server.
The present invention relates to a method and a system for notifying online processing failure information.

[0002]

2. Description of the Related Art Conventionally, aircraft ticketing systems,
Dedicated lines such as N / B-ISDN (Integrated Services Digital Network) and PSTN (Analog Public Switched Telephone Network) for the host computer (center device), such as a cash dispenser (CD) and a banking system centered on exchange processing, etc. Alternatively, an online system that accommodates terminals by a public communication line accommodates an Ethernet LAN or an FDDI LAN constructed in a branch or the like. This LAN is constructed as a so-called client / server system, and performs data processing centered on online real-time processing.

In this LAN, a network protocol standard (OS
I: Open Systen Interconnection) is often applied. Such an online system has three layers of a presentation layer, a function layer, and a data layer, and has a network configuration in which a client, an application server, and a database server are physically connected to a LAN transmission line together with a general-purpose small computer. . The client / server system executes an execution program of the server by a remote procedure call (RPC) process and a data link control procedure access known to the client.

That is, a server calls various application programs from a client (RP
C), various data processes are performed on the data stored in the database. For this reason, the application server and the database server output a large amount of logs. Therefore, in online real-time processing, occurrence of a system failure is particularly problematic. For this reason, multiple servers and databases are distributed, and
In order to establish clock synchronization and enable higher-level data processing to be performed, and to increase processing speed, a distributed file system that stores the same data to protect processing data in the event of a failure is used. I have.

When a system failure occurs in such a client / server system, the server notifies the client of the failure. This notification is sent from the client user to the server monitor (system monitor). Further, the occurrence of a system failure is notified from a server monitoring device to a monitoring terminal or the like, and the notification is performed. In this case, the location of the failure is detected from the processing data that caused the system failure, that is, the log output from the server in large quantities. In this case, since the failure analyst makes a manual determination visually, a long time is required for the detection. In particular, in online real-time processing, an instantaneous failure detection is required, which is a serious problem.
For this reason, an improvement measure for automatically / mechanically detecting a failure occurrence location is required.

For example, in the conventional example of Japanese Patent Application Laid-Open No. 3-196351, "server multiplexing method", an address used by another server is assigned to a server in advance, and when a failure occurs in another server, another server is added. Server operates at the address assigned to the server, and continues operation of the server when a failure occurs. Further, in the conventional example of Japanese Patent Application Laid-Open No. 9-293059, "Distributed system and its operation management method", when a failure occurs in a service of a certain server node, another service in which the failure occurs to operate on this server node is waited. Only the failed service is continued without switching to the system server.

In this conventional example as well, in order to recover a system failure, a failure notification is sent from a server to a client or the like, and then a location where a system failure has occurred is detected. Time-consuming detection work is required.

[0008]

As described above, in the above-mentioned conventional example, there is a disadvantage that it takes a lot of time to detect a system failure location from processing data.

[0009] The present invention is to solve such a problem in the prior art, and isolates the occurrence of a failure in an application server or a database server when a failure occurs in an online system including a client, an application server, and a database server. Online processing fault information that allows the client user to be notified (notified) and the date and time of the fault occurrence to be notified to the client user. The purpose is to provide a notification method and a system thereof.

[0010]

In order to achieve the above object, an on-line processing fault information notification method according to the present invention separates the occurrence of a server fault in an on-line system comprising a client and an application and database server. The client transmits upstream information, the application server receives the upstream information, the application server creates fault information from a fault log at the time of the fault occurrence, and further transmits the fault information to the client. The information is transmitted as downlink information, and the client receives the failure information of the downlink information and reports the occurrence of a failure in the application server.

The online processing fault information notifying method according to the present invention is to separate and notify the occurrence of a server fault in an online system including a client and an application and database server. The application server receives this upstream information and transmits it to the database server as upstream information. The database server creates fault information from a fault log at the time of the fault occurrence, and further sends the fault information to the application server. And the application server receives this data, and
The information is transmitted to the client as downlink information, and the client receives the fault information of the notified downlink information and reports the occurrence of a fault in the database server.

Along with the failure log, failure information storing a failure occurrence date and time is created and transmitted, the client notifies the failure log and the failure information of the failure occurrence date and time, and the client transmits the received failure information to the failure log. The data is transferred to an external device via a communication line.

The online processing fault information notification system according to the present invention separates and notifies the occurrence of a server fault in an online system including a client and an application / database server. And, the failure information which is the downlink information from the application server is received and the occurrence of the failure is notified, and the application server receives the uplink information and creates the failure information from the failure log when the failure occurs. Is transmitted to the client as downlink information.

The online processing fault information notification system according to the present invention separates and notifies the occurrence of a server fault in an online system including a client and an application / database server. The client transmits upstream information. And receives the failure information of the database server, which is the downlink information through the application server, and reports the occurrence of the failure. The application server receives the uplink information from the client, transmits the information to the database server, and transmits the information from the database server. The database server receives the uplink information from the application server, and creates failure information from a failure log when a failure occurs, and transmits the failure information to the client through the application server. Kula In Ant as configured to transmit a downlink information.

[0015] As the client, an upstream information transmitting unit for transmitting upstream information, a downstream information receiving unit for receiving downstream information, and notification of fault information of a server when a fault occurs as the downstream information received by the downstream information receiving unit. And a failure information notifying unit.

Also, as the application server, an upstream information receiving unit for receiving upstream information, an upstream information transmitting unit for transmitting upstream information received by the upstream information receiving unit as upstream information, and a downstream for receiving downstream information. An information receiving unit, a downlink information transmitting unit that further transmits downlink information received by the downlink information receiving unit, a failure log output unit that outputs a failure log together with information of a failure occurrence location, and a failure log that is output by the failure log output unit And a failure information creation unit that generates failure information from the server.

Further, as the database server, an upstream information receiving unit for receiving upstream information, a downstream information transmitting unit for transmitting fault information when a fault occurs as downstream information, and outputting a fault log together with information of a fault occurrence location. The configuration includes a failure log output unit and a failure information creation unit that generates failure information from the failure log output by the failure log output unit.

The application server or the database server is further provided with a calendar unit for storing the date and time of occurrence of the failure in the failure information.

The fault information notifying section of the client includes a communication transfer device for transferring the received fault information to an external device through a communication line, and the screen for displaying the received fault information on the screen of the fault information notifying section of the client. A display device is provided, and the failure information notification unit of the client is provided with a synthesized speech device for notifying the received failure information by synthesized speech. Further, the fault information notifying section of the client includes a sound output device for notifying the received fault information by sound output, and the sound output device detects occurrence of a fault in the application server or the database server by different types of sounds. It is configured to perform output.

In the online processing fault information notification method and system according to the present invention, the client receives and notifies fault information including the fault date and time created by the application server when the fault occurs. In addition, the client receives and reports the failure information including the failure date and time created by the database server when the failure occurs, through the application server.

As a result, when a failure occurs in the online system including the client, the application server, and the database server, the failure in the application server or the database server can be separated and notified (notified) to the client user. The time can be notified to the client user, the location of the failure occurrence can be quickly identified, and its early recovery can be performed.

Further, the method and system for notifying on-line processing fault information of the present invention transfer the received fault information to an external device through a communication line, further display the received fault information on a screen, and notify the synthesized voice. Further, the occurrence of a failure for each application server or database server is reported by different types of sound outputs.

As a result, the occurrence of a failure occurs at the client,
As well as being found more quickly, the degree of freedom of the configuration is improved.

[0024]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, an embodiment of a method and system for notifying on-line processing fault information of the present invention will be described in detail with reference to the drawings. FIG. 1 is a block diagram showing a schematic configuration of an online processing fault information notification method and system according to an embodiment of the present invention. In FIG. 1, this example is an online system, such as an airline ticketing system or a cash dispenser (C
N / B in host computer (center device) such as D) or banking system centered on currency exchange
-Terminals connected to a LAN are accommodated by a dedicated line such as ISDN (Integrated Services Digital Network) or PSTN (Analog Public Switched Telephone Network) or a public line.

In this LAN, a network protocol standard (OS
I) is applied, and the OSI has three layers: a presentation layer, a function layer, and a data layer.
Each has a network configuration in which a client 1, an application server 2, and a database server 3 are physically connected to a LAN transmission path. In the client / server system, the execution program of the server is executed by a client by a well-known remote procedure call (RPC) process and data link control procedure access.

For example, the network topology is constructed by a bus-type Ethernet LAN or the like. In this case, the data link control procedure is performed by CSMA / CD (Carrier Sense Multilink).
tiple Access / Collision Detection). Further, as the LAN transmission line, a connection method of an Ethernet LAN having a transmission speed of 10 Mb / s according to the IEEE LAN standard is applied.

The client 1 includes a general-purpose small-sized computer provided with a LAN communication adapter for executing Ethernet LAN communication control. That is, a CPU, a ROM storing a control program, a working RAM,
From a hard disk drive (HDD) / floppy disk drive (FDD), an input operation device for transmitting character / symbol and coordinate input information, a display device such as a CRT / LCD, and a communication control device for transferring fault information to an external device. It is configured.

The application server 2 has a configuration similar to that of a small general-purpose computer.
M, RAM, a hard disk drive (HDD) / floppy disk drive (FDD), a LAN communication adapter, and the like. The database server 3 also has a configuration similar to a small general-purpose computer, and a relational database device is frequently used. CPU, R
It comprises an OM, a RAM, a hard disk device (HDD) / floppy disk device (FDD), a LAN communication adapter, and a calendar device for measuring the date and time. The application server 2 and the database server 3 may be provided with a display device and an input operation device for maintenance.

FIG. 2 is a block diagram showing the functional configuration of the client 1, application server 2, and database server 3 shown in FIG. The client 1 transmits the user (user) ID and the terminal ID of the client 1 together with the business process items processed here to the application server 2 as information, and the information transmitted from the application server 2 The information received by the downlink information receiving unit 12 and the information received by the downlink information receiving unit 12 are checked. If a failure occurs, the server (the application server 2 or the database server 3) in which the failure has occurred and detailed failure information And a communication transfer unit 14 for transferring the received fault information to an external device via a communication line.

The fault information notifying unit 13 includes a screen display unit 13a for displaying the received fault information on a screen, a synthesized voice unit 13b for notifying the received fault information by a synthesized voice, and a fault occurrence for each application server or database server. And a sound output unit 13c for outputting different types of sounds.

The application server 2 includes an upstream information receiving unit 21 for receiving information transmitted from the client 1.
An upstream information transmitting unit 22 that transmits the user ID and the terminal ID transmitted from the client 1 together with the business process item to the database server 3 as information, and a downstream information reception that receives the information transmitted from the database server 3 Unit 23, and transmits the business process item to the client 1,
In addition, when a failure occurs in the application server 2, there is provided a downstream information transmission unit 24 that transmits the failure information generated by the failure information creation unit 26 to the client 1.

The application server 2 has a failure log output unit 25 for outputting a failure log having the user ID and the terminal ID sent from the client 1 together with information on the failure occurrence location. A failure information creation unit 26 that generates information indicating that a failure has occurred in the application server 2 together with the above information, and a calendar unit 27 that counts the date and time of the failure occurrence.

[0033] The database server 3 transmits the business process items to the application server 2 and the upstream information receiving unit 31 for receiving the information transmitted from the application server 2. If a failure occurs in the database server 3, Downlink information transmission unit 32 that transmits the failure information generated by the failure information creation unit 34 to the application server 2
And a failure log output unit 33 that outputs a failure log having the user ID and the terminal ID sent from the application server 2 together with the information on the failure occurrence location, and the failure on the database server 3 along with the failure occurrence location information. Fault information creation unit 34 that generates information indicating that a fault has occurred
And a calendar unit 35 for measuring the date and time of occurrence of the failure.

Next, the operation of this embodiment will be described. FIG. 3 is a diagram for explaining a processing state in a normal operation in which no failure has occurred. 1 to 3, when the processing is executed by the client 1, the upstream information transmitting unit 11 transmits information A to the application server 2. In the application server 2, the upstream information receiving unit 2
1 receives the information A, and transmits the information B to the database server 3 by the upstream information receiving unit 21. In the database server 3, the upstream information receiving unit 31 receives the information B, updates the database, and transmits the information C to the application server 2 by the downstream information transmitting unit 32. In the application server 2, the downstream information receiving unit 23 receives the information C, and the downstream information transmitting unit 24 transmits the information D to the client 1. In the client 1, the information D is received by the downlink information receiving unit 12. In this case, the fault notification flag in the information D is “OFF” indicating that no fault has occurred.

FIG. 4 is a diagram for explaining a processing state in which a failure has occurred in the application server 2. In FIG. 4, when a failure occurs in the application server 2, the failure log output unit 25 and the failure information creation unit 26 operate. The failure log output unit 25 outputs information indicating a failure occurrence location, a user ID, and a terminal ID as a failure log. The failure information creation unit 26 sets the failure notification flag in the information D to “ON” and sets the application server failure flag to “ON”. Thereafter, the downlink information transmitting unit 24 transmits the information D to the client 1. In the client 1, the information D is received by the downlink information receiving unit 12,
Since the failure notification flag in the information D is “ON” and the application server failure flag is set to “ON”, the failure information notification unit 13 has caused a failure in the application server 2. This is notified to the user of the client 1.

FIG. 5 is a diagram for explaining a processing state in which a failure has occurred in the database server 3. In FIG. 5, when a failure occurs in the database server 3, a failure log output unit 33 and a failure information creation unit 34 operate. The failure log output unit 33 outputs information indicating the location of the failure, the user ID, and the terminal ID as a failure log. The failure information creation unit 34 sets the failure notification flag in the information C to “O
N "and the database server failure flag is set to" ON ". After that, the downlink information transmitting unit 32 transmits the information C to the application server 2.

The application server 2 receives the information C from the database server 3 and transmits the information D to the client 1 in the same manner as in the normal operation shown in FIG. In the client 1, the information D is received by the downlink information receiving unit 12, and the failure notification flag in the information D is “ON” and the database server failure flag is set to “ON”. The information notification unit 13 notifies the user of the client 1 that a failure has occurred in the database server 3. The occurrence of the failure is transferred from the communication transfer unit 14 shown in FIG. 2 to an external device, for example, a center device (host device) that collectively monitors the failure. This communication transfer unit 14 is, for example, I
It executes a communication protocol with SDN or PSTN.

As described above, in this embodiment, when a failure occurs in the online system including the client 1, the application server 2, and the database server 3,
The occurrence of a failure in the application server 2 or the database server 3 can be identified and notified to the client user, so that the failure occurrence location can be quickly specified, and early recovery can be performed. Further, since the occurrence of a failure in the application server 2 or the database server 3 can be identified by a remote center device (host device), the occurrence of a failure in the entire network accommodating a plurality of online systems can be quickly identified.

Next, another embodiment will be described. In this other embodiment, as shown in FIG. 2, the application server 2 is additionally provided with a calendar unit 27 for measuring date and time. Similarly, the database server 3 is additionally provided with a calendar section 35 for measuring the date and time. Here, the application server 2 and the database server 3 for specifying the date and time of the occurrence of the failure always keep time with the date and time.

In FIG. 4, the application server 2
When a failure occurs, the failure information creation unit 26 fetches the date and time information from the calendar unit 27, sets the failure notification flag in the information D to “ON”, and sets the application server failure flag to “ON”. To "." Thereafter, the downlink information transmitting unit 24 transmits the information D to the client 1. The failure information notification unit 13 of the client 1 notifies the user of the client 1 of the occurrence of the failure in the application server 2 along with the date and time.

In FIG. 5, when a failure occurs in the database server 3, the failure information creation unit 34 fetches the date and time information from the calendar unit 35, and sets the failure notification flag in the information C to "ON". And sets the database server failure flag to “ON”. Thereafter, the downlink information transmitting unit 32 transmits the downlink information to the application server 2,
The information D is transmitted from the application server 2.
The failure information notification unit 13 of the client 1 notifies the user of the client 1 of the occurrence of the failure in the application server 2 along with the date and time.

As described above, in another embodiment, when a failure occurs in the online system including the client 1, the application server 2, and the database server 3,
The occurrence of a failure in the application server 2 or the database server 3 can be separated and notified to the client user, and the date and time of the occurrence of the failure can be notified to the client user. Since it can be specified, the location where the failure occurred can be specified more quickly, and the recovery can be made earlier.

Next, the failure information notification unit 1 of the client 1
The notification operation in 3 will be described in detail. As shown in FIG. 2, the failure information notification unit 13 has a screen display unit 13a,
A synthesized voice section 13b and a sound output section 13c are provided. The screen display unit 13a displays the received fault information on a screen. Further, the synthesized speech unit 13b notifies the received failure information by a synthesized speech. Further, in the sound output unit 13c,
Fault occurrence for each application server or database server is performed with different types of sound output. By such various kinds of notification, the occurrence of a failure can be found more quickly, and the degree of freedom of the configuration (design) can be obtained.

[0044]

As is apparent from the above description, according to the online processing fault information notifying method and system thereof, the present invention provides a method in which an application server transmits fault information including a fault date and time created when a fault occurs to a client. Received and notified. As a result, when a failure occurs in the online system including the client, the application server, and the database server, the failure occurrence in the application server or the database server can be separated and notified (notified) to the client user.

According to the method and system for notifying on-line processing fault information according to the present invention, a client receives fault information including a fault occurrence date and time created by a database server when a fault occurs, through an application server, and notifies the client. As a result, the date and time of occurrence of the failure can be notified to the client user, and the location of the failure can be specified more quickly, and the recovery can be made earlier.

The method and system for notifying on-line processing fault information of the present invention transfer the received fault information to an external device through a communication line, further display the received fault information on a screen, and notify the synthesized voice. Further, the occurrence of a failure for each application server or database server is reported by different types of sound outputs. As a result, the occurrence of a failure can be identified more quickly at the client, and the degree of freedom of the configuration is improved.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a schematic configuration of an online processing fault information notification method and system according to an embodiment of the present invention.

FIG. 2 is a block diagram illustrating a functional configuration of a client, an application server, and a database server illustrated in FIG. 1;

FIG. 3 is a diagram illustrating a processing state in a normal operation in which no failure has occurred in the embodiment.

FIG. 4 is a diagram illustrating a processing state in which a failure has occurred in an application server in the embodiment.

FIG. 5 is a diagram illustrating a processing state in which a failure has occurred in the database server according to the embodiment;

[Explanation of symbols]

 Reference Signs List 1 client 2 application server 3 database server 11, 22 upstream information transmitting unit 12, 23 downstream information receiving unit 13 failure information notifying unit 13a screen display unit 13b synthetic voice unit 13c sound output unit 14 communication transfer unit 21, 31 upstream information receiving unit 24, 32 Downlink information transmission unit 25, 33 Failure log output unit 26, 34 Failure information creation unit 27, 35 Calendar unit

Claims (15)

[Claims] 1. An online processing failure information notification method for isolating and notifying the occurrence of a server failure in an online system comprising a client and an application and database server, wherein the client transmits upstream information and transmits the upstream information. The application server receives the information, the application server creates failure information from a failure log at the time of the failure occurrence, further transmits the failure information to the client as downlink information, and the client receives the failure information of the downlink information, An online processing failure information notification method characterized by reporting the occurrence of a failure in an application server. 2. An online processing fault information notification method for isolating and notifying the occurrence of a server fault in an online system including a client and an application and database server, wherein the client transmits upstream information and transmits the upstream information. The application server receives the data and sends it to the database server as upstream information. The database server creates fault information from a fault log at the time of the fault occurrence, and further transmits the fault information to the application server as downstream information. An on-line process wherein the server receives this data and transmits it to the client as downlink information, and the client receives the fault information of the notified downlink information and reports the occurrence of a fault in the database server. Failure information notification method . 3. The server according to claim 1, wherein together with the error log, error information storing the error occurrence date and time is created and transmitted, and the client notifies the error log and the error information on the error occurrence date and time. Online processing failure information notification method. 4. The online processing fault information notification system according to claim 1, wherein the client transfers the received fault information to an external device via a communication line. 5. An online processing failure information notification system for separating and notifying the occurrence of a failure of the server in an online system including a client and an application and database server, wherein the client transmits uplink information, and The application server receives the failure information that is the downlink information from the application server and notifies the occurrence of the failure, the application server receives the uplink information, and creates failure information from a failure log when the failure occurs, An online processing failure information notification system, wherein the information is transmitted to the client as downlink information. 6. An online processing failure information notification system for separating and notifying the occurrence of a server failure in an online system including a client and an application and database server, wherein the client transmits uplink information, and Receiving failure information of the database server, which is downlink information through an application server, and notifying the occurrence of a failure, the application server receiving uplink information from the client and transmitting the information to the database server, and Receives the failure information from the server and sends it to the client as downlink information.The database server receives the uplink information from the application server, and creates failure information from a failure log when a failure occurs. The app An on-line processing failure information notification system, wherein the information is transmitted as downlink information to the client through an application server. 7. As the client, an uplink information transmitting unit that transmits uplink information, a downlink information receiving unit that receives downlink information, and a server failure when a failure occurs as the downlink information received by the downlink information receiving unit. 7. The online processing failure information notification system according to claim 5, further comprising: a failure information notification unit that notifies information. 8. The application server, as an application server, an uplink information receiving unit that receives uplink information, an uplink information transmitting unit that further transmits uplink information received by the uplink information receiving unit as uplink information, and receives downlink information. A downlink information receiving unit; a downlink information transmitting unit that further transmits downlink information received by the downlink information receiving unit; a failure log output unit that outputs a failure log together with information on a location where a failure has occurred; 7. The online processing fault information notification system according to claim 5, further comprising: a fault information creating unit that generates fault information from the fault log obtained. 9. As the database server, an uplink information receiving unit that receives uplink information, a downlink information transmitting unit that transmits failure information when a failure occurs as downlink information, and outputs a failure log together with information of a failure occurrence location. 7. The online processing fault information notification system according to claim 5, further comprising: a fault log output unit; and a fault information creating unit that generates fault information from the fault log output by the fault log output unit. 10. The online processing failure information notification system according to claim 8, wherein the application server or the database server further includes a calendar unit for storing a failure occurrence date and time in the failure information. 11. The online processing failure information notification system according to claim 7, wherein the failure information notification unit of the client includes a communication transfer device that transfers the received failure information to an external device via a communication line. 12. The online processing failure information notification system according to claim 7, wherein the failure information notification unit of the client includes a screen display device that displays the received failure information on a screen. 13. The online processing fault information notification system according to claim 7, wherein the fault information notification unit of the client includes a synthesized voice device for notifying the received fault information by a synthesized voice. 14. The online processing fault information notification system according to claim 7, wherein the fault information notification unit of the client includes a sound output device that notifies the received fault information by sound output. 15. The online processing failure information notification system according to claim 14, wherein the sound output device performs a failure occurrence in the application server or the database server by using different types of sound outputs.