JPH08235034A - Data base monitoring system - Google Patents

Abstract

PURPOSE: To attain the reference to a screen for the relevant information by collecting the using states of a data base (DB) and measuring the activity ratio and the estimated capacity shortage date of the DB. CONSTITUTION: A monitor DB initializing means 1 produces a monitor management record and registers it to a monitor DB 7, and a monitor DB maintenance means 2 registers and updates a monitoring area definition record and a monitoring range definition record to the DB 7 to define a monitoring area and a monitoring range of a monitor object DB 9 respectively. A monitor data collection means 4 calculates the activity ratio and the estimated capacity shortage date of the DB 9 and registers them to a collected data file 8 as the collected data records. A monitor data register means 5 registers the collected data records of the file 8 to the DB 7 as the monitor collected data records. Then a monitor data reference means 6 refers to the contents of the monitor collected data records of the DB 7 in response to a picture.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database monitoring system, and more particularly to a database monitoring system for monitoring the usage status of a database (hereinafter abbreviated as DB).

[0002]

2. Description of the Related Art In the prior art, the system administrator or the like collects the usage status such as the usage rate of the database and considers the maintenance time of the database based on the information.

[0003]

In the above-mentioned conventional technique, the system administrator or the like has to collect the usage status and consider the maintenance time of the database based on the information. However, there is a problem that the reliability of database maintenance decreases with the increase of the load such as.

In view of the above points, an object of the present invention is to collect the usage status of a database, retain the history information thereof, automatically measure the usage rate and the estimated date of capacity shortage, and make a screen inquiry of the information. It is to provide a database monitoring system that makes it possible.

[0005]

A database monitoring system of the present invention is a database monitoring system for monitoring a monitoring target DB, and a monitoring DB initial setting means for creating and registering a monitoring management record in the monitoring DB, and the monitoring DB.
A monitoring DB maintenance unit that registers and updates a monitoring area definition record that defines the monitoring area of the monitoring target DB and a monitoring range definition record that defines the monitoring range of the monitoring target DB, and the usage rate and capacity of the monitoring target DB A monitoring data collection means for obtaining the estimated shortage date and registering it in a collection data file as a collection data record,
Monitoring data registration means for registering the collection data record of the collection data file as a monitoring collection data record in the monitoring DB, and monitoring data inquiry means for inquiring the contents of each monitoring collection data record of the monitoring DB in correspondence with the screen. .

[0006]

In the database monitoring system of the present invention, the monitoring DB initial setting means creates and registers the monitoring management record in the monitoring DB, and the monitoring DB maintenance means defines the monitoring area of the monitored DB in the monitoring DB. A record and a monitoring range definition record that defines the monitoring range of the monitoring target DB are registered and updated, and the monitoring data collection unit obtains the usage rate of the monitoring target DB and the estimated capacity shortage date and registers it as a collection data record in the collection data file, The monitoring data registration means uses the collected data record of the collected data file as a monitored collected data record to monitor
, And the monitoring data inquiring means inquires the contents of each monitoring collection data record of the monitoring DB in correspondence with the screen.

[0007]

The present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a database monitoring system according to an embodiment of the present invention. The database monitoring system of this embodiment includes a monitoring DB initial setting unit 1, a monitoring DB maintenance unit 2, a monitoring data deleting unit 3, a monitoring data collecting unit 4, a monitoring data registration unit 5, and a monitoring data inquiry unit 6. And monitoring DB7,
It is composed of a collection data file 8, a monitoring target DB 9, a display 10, a monitoring report 11, and a monitoring data inquiry list 12.

Referring to FIG. 2, the monitoring DB 7 stores a monitoring management record, a monitoring area definition record, a monitoring range definition record, and a monitoring collection data record. The monitoring management record includes common control information and a record name that is a calc key. The monitoring area definition record includes common control information, an area name that is a calc key, a monitoring type, a reference value, a warning value, and a creation date. The monitoring range definition record includes common control information, an area name and a range number that are calc keys, a start number and an end number of the overflow area, and a creation date. The monitoring and collection data record includes the common control information, the collection date and time, and the total number of pages (hereinafter, all CIs).
It includes a number), a page size (hereinafter, referred to as a CI size), a usage rate, an average change rate, and a capacity shortage prediction date. In FIG. 2, C indicates a calc record whose storage position is determined by the value obtained by key-converting the calc key value, and V is a bi-asset record stored under the parent record without a key. Indicates that there is. The line connecting the records indicates that they are connected by bi-asset.

Referring to FIG. 3, the collected data file 8
Is the area name, range number, collection date and time, total number of CIs,
Stores collected data records including the CI size, usage rate, average change rate, and estimated capacity shortage date.

The monitoring DB initial setting means 1 creates a monitoring management record by using the record name as a calc key and creates a monitoring DB.
It is a means to register to 7.

The monitoring DB maintenance means 2 is means for registering and updating a monitoring area definition record defining a monitoring area of the monitoring target DB 9 and a monitoring range definition record defining a monitoring range of the monitoring target DB 9 in the monitoring DB 7.

The monitoring data deleting means 3 is means for deleting each record in the monitoring DB 7.

The monitoring data collection means 4 is a monitoring target DB 9
This is a means for collecting the total number of CIs and the number of CIs used in the collection target range, obtaining the usage rate and the estimated date of capacity shortage, and registering the collected data record in the collected data file 8.

Referring to FIG. 6, the monitoring data collecting means 4
The collection process of the monitoring area definition record search step S
101 and monitoring range definition record search step S10
2 and monitoring collection data record search step S103
A usage rate calculation step S104, an average change rate calculation step S105, and a capacity shortage prediction date calculation step S10.
6, a usage rate / reference value comparison step S107, a monitoring report output step S108, and a collected data registration step S109.

The monitoring data registration means 5 is means for registering the collection data record of the collection data file 8 as a monitoring collection data record in the monitoring DB 7.

The monitoring data inquiry means 6 is means for inquiring and updating each record of the monitoring DB 7 in a conversational manner on the screen of the display 10 and outputting to the monitoring data inquiry list 12.

Referring to FIG. 7, monitoring data inquiry means 6
Inquiry processing of the latest situation inquiry determination step S201,
Monitoring collection data record search step S202 and monitoring record data record final record search step S20
3, display output step S204, and monitoring data inquiry list output step S205.

The monitoring target DB 9 is a database in which there are areas to be monitored. The area is 1
It may consist of one range or may be divided into multiple ranges. Further, it is assumed that the range is divided into a plurality of pages.

The display 10 is means for setting the reference value and warning value of the usage rate by the monitoring data inquiry means 6 and for inquiring monitoring data.

The monitoring report 11 is output when the data collected by the monitoring data collecting means 4 exceeds the reference value of the usage rate.

With reference to FIG. 4, the print layout of the monitoring report 11 includes an area name, a monitoring type, and a CI.
The size, the range number, the total number of CIs, the reference value, the warning value, and the usage rate.

The monitoring data inquiry list 12 is one in which the monitoring data inquiry means 6 outputs the contents of the monitoring collection data record of the monitoring DB 7.

Referring to FIG. 5, the print layout of the monitoring data inquiry list 12 includes an area name, a monitoring type, a range number, a collection date and time, the total number of CIs, a usage rate, and a predicted capacity shortage date. Consists of.

Next, the operation of the database monitoring system of this embodiment having the above configuration will be described.

The system administrator or the like can monitor D in advance.
The B initial setting means 1 creates a monitoring management record having a record name as a calc key and registers it in the monitoring DB 7.

Further, the system administrator or the like registers the monitoring area definition record including the area name, monitoring type, creation date, etc. of the monitoring target DB 9 in the monitoring DB 7 by the monitoring DB maintenance means 2. Further, a monitoring range definition record consisting of the area name, range number, start number and end number of the overflow area, creation date, etc. of the monitored DB 9 is registered in the monitoring DB 7.

Further, the system administrator or the like sets the reference value and the warning value of the usage rate in the collection target area unit of the monitoring target DB 9 interactively through the display 10 by the monitoring data inquiry means 6, and the monitoring area of the monitoring DB 7 is set. Register in the definition record.

From the state where the monitoring management record, the monitoring area definition record and the monitoring range definition record are registered in the monitoring DB 7 and the standard value and the warning value of the usage rate are set, the system administrator or the like assigns the area name and range number. When the monitoring data collecting means 4 is activated by designating, the monitoring data collecting means 4 first searches the monitoring area definition record from the monitoring DB 7 using the designated area name as a key (step S101), and the searched monitoring area definition is searched. A monitoring range definition record that is linked to the record by a bi-asset and that corresponds to the specified area name and range number is searched (step S102), and the last record of the monitoring collection data records under the searched monitoring range definition record (previous record) The record at the time of collection) is searched (step S103).

Next, the monitoring data collecting means 4 acquires the total number of CIs and the number of used CIs in the range of the designated area name and range number from the monitoring target DB 9, and the monitoring target D
Usage rate of collection target range unit of B9 = number of used CIs / total C
The I number is calculated (step S104).

Subsequently, the monitoring data collection means 4 collects the total number of CIs and the number of used CIs in step S104, this date (hereinafter referred to as the current collection date) and step S.
The usage rate obtained in 104 (hereinafter, this time usage rate),
From the collection date (hereinafter referred to as the previous collection date) and the usage rate (hereinafter referred to as the previous usage rate) in the monitoring collection data record searched in step S103, the average change rate of the usage rate = (current usage rate−previous usage) Rate) / (Current collection date −
The previous collection date) is calculated (step S105).

Next, the monitoring data collection means 4 calculates the capacity shortage prediction date = current collection date + (100−current usage rate) / average change rate from the current usage rate, the average change rate, and the current collection date (step). S106).

Subsequently, the monitoring data collection means 4 judges whether the usage rate (current usage rate) exceeds the reference value in the monitoring area definition record retrieved in step S101 (step S107), and exceeds it. If so, the area name, monitoring type, reference value, and warning value in the monitoring area definition record retrieved in step S101, the range number in the monitoring range definition record retrieved in step S102, and the collection in step S104 The calculated total number of CIs and the usage rate (current usage rate) calculated in step S104 are output to the monitoring report 11 (step S10).
8) If it does not exceed, it is not output to the monitoring report 11.

Finally, the monitoring data collecting means 4 collects the collected data including the area name, range number, collection date and time, total CI number, CI size, usage rate (current usage rate), average change rate and estimated capacity shortage date. A record is created and registered in the collected data file 8 (step S109).

The monitoring data registration means 5 defines a monitoring area in which the area name and range number of the collected data record registered in the collected data file 8 by the monitoring data collection means 4 is used as a calc key for the area name of the monitoring DB 7. Register it as a monitored data record under the monitoring range definition record that uses the record and area name and range number as the calc key.

When the system administrator or the like activates the monitoring data inquiring means 6 by designating the area name and range number and whether or not it is an inquiry of the latest status, the monitoring data inquiry means 6 causes the monitoring data inquiry means 6 to make an inquiry of the latest status. If so (step S20
If the answer is 1), the monitoring DB 7 is searched for the monitoring area definition record having the area name as the calc key and the final record of the monitoring data records under the monitoring range definition record having the area name and the range number as the calc key (step S203). If it is not the latest status inquiry (NO in step S201), the monitoring area definition record having the area name as the calc key and all the monitoring data records under the monitoring range definition record having the area name and the range number as the calc key are searched from the monitoring DB 7. A search is performed (step S202).

The monitoring data inquiry means 6 outputs the contents of the searched monitoring range definition record to the display 10 (step S204) and outputs the monitoring data inquiry list 12 (step S205). As a result, the system administrator or the like can easily know the latest usage rate and predicted capacity shortage date for each collection target range unit of the monitoring target DB 9.

The system administrator or the like can delete each record in the monitoring DB 7 at any time by using the monitoring data deleting means 3.

By the way, in the description of the operation of the above embodiment,
The case where the monitoring data collection means 4 and the monitoring data inquiry means 6 are activated by designating the area name and range number has been described. However, by omitting the area name and range number, the monitoring management record with the record name as a calc key is displayed. It is possible to perform the same operation collectively for all ranges of all areas defined by the subordinate monitoring area definition records and monitoring range definition records.

[0040]

As described above, according to the present invention, the monitoring DB
Initial setting means, monitoring DB maintenance means, monitoring data collection means, monitoring data registration means and monitoring data inquiry means are provided to collect the usage status of the monitoring target database,
By keeping the history information, automatically measuring the usage rate and the estimated capacity shortage date, and making it possible to display the information on the screen, it is possible to reduce the load on the database maintenance of system administrators and to maintain the database. There is an effect that the certainty of can be improved.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of a database monitoring system according to an embodiment of the present invention.

FIG. 2 is a diagram showing a record layout of a monitoring DB in FIG.

FIG. 3 is a diagram showing a record layout of a collected data file in FIG.

FIG. 4 is a diagram showing a print layout of a monitoring report in FIG.

5 is a diagram showing a print layout of a monitoring data inquiry list in FIG.

FIG. 6 is a flow chart showing a collection process of monitoring data collection means in FIG.

7 is a flow chart showing an inquiry process of the monitoring data inquiry means in FIG. 1. FIG.

[Explanation of symbols]

 1 Monitoring DB Initial Setting Means 2 Monitoring DB Maintenance Means 3 Monitoring Data Deleting Means 4 Monitoring Data Collecting Means 5 Monitoring Data Registering Means 6 Monitoring Data Inquiring Means 7 Monitoring DBs 8 Collected Data Files 9 Monitoring Target DBs 10 Displays 11 Monitoring Reports 12 Monitoring Data Inquiry list

Claims (6)

[Claims] 1. A database monitoring system for monitoring a monitored DB, a monitoring D for creating and registering a monitoring management record in the monitoring DB.
B initial setting means, monitoring DB maintenance means for registering and updating a monitoring area definition record defining a monitoring area of the monitoring target DB and a monitoring range definition record defining a monitoring range of the monitoring target DB in the monitoring DB, Monitoring data collection means for obtaining the usage rate and estimated capacity shortage date of the monitored DB and registering it in a collected data file as a collected data record; and collecting data record of the collected data file as a monitored collected data record in the monitoring DB. A database monitoring system, comprising: monitoring data registration means; and monitoring data inquiring means for inquiring the contents of each monitored and collected data record of the monitoring DB in correspondence with the screen. 2. The monitoring data collection unit acquires the number of used CIs from the monitoring target DB, and based on the number of used CIs and the number of CIs of monitoring collection data records in the monitoring DB, the collection target range of the monitoring target DB. The usage rate of the unit is calculated, the average change rate of the usage rate is calculated from the collection date of the number of used CIs and the usage rate obtained this time, and the collection date and the usage rate in the monitoring collection data record, and the usage rate obtained this time. The database monitoring system according to claim 1, wherein a predicted capacity shortage date is predicted from the average change rate and the collection date of the number of used CIs, and a collected data record including the usage rate and the predicted capacity shortage date is registered in the collected data file. 3. The database monitoring system according to claim 1, wherein the monitoring data collection unit outputs a monitoring report when the usage rate exceeds a reference value. 4. The database monitoring system according to claim 1, wherein the monitoring data inquiry unit outputs a monitoring data inquiry list. 5. The monitoring data inquiry means is configured to monitor the monitoring D.
2. The database monitoring system according to claim 1, wherein the reference value of the usage rate is set in the monitoring area definition record of B for each screen. 6. The database monitoring system according to claim 1, further comprising monitoring data deleting means for deleting each record of the monitoring DB.