JPH04175865A - Data base state monitor system - Google Patents

Abstract

PURPOSE:To minimize the gathered data volume by limiting monitor object items and displaying only information exceeding a preliminarily set and indicated reference at the time of issue of an editing and display request of gathered information. CONSTITUTION:When a preliminarily determined event occurs, a monitor information gathering means 30 is called from a data base management system 20 with a monitor item number and data as the parameter and gathers information only with respect to monitor object items registered in a data base directory 2 by a monitor information indicating means 10 and outputs a monitor information gathering file 3. A monitor information display means 40 is started by the request from a user and edits and displays only information satisfying the display reference of monitor object items registered in the data base directory 2 by the monitor information indicating means 10. Thus, the gathered data volume is minimized.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to a database status monitoring method, and in particular, the access status is This invention relates to a database status monitoring method for collecting information on the database.

[Summary of the invention]

The present invention enables monitoring of the usage status of the database.
To provide a means for accurately displaying only useful usage status at any time upon request from a user by determining information to be collected in advance and its processing method.

[Conventional technology]

In conventional database status monitoring methods, the usage status of a database is generally represented by dynamic information and static information. Dynamic information collection is performed when database access is executed, and is output all at once in the form of an execution file or statistical information collection file at the end of a job or task. . In addition, static information is collected by rereading the database each time, and the required information is edited and output.

[Problem that the invention attempts to solve]

Collecting Information Indicating Database Usage Status 1 In the conventional butterbase status monitoring method described above, dynamic information collection is performed every time a database access is executed, so the amount of information becomes enormous. However, when the need to use that information arises, it has to be searched from a huge pile of output, so it has the disadvantage that it takes time to search for the necessary information3. Static information collection has the disadvantage that it takes time to output the collection because the database is searched again each time collection is requested.

[Means to solve the problem]

The database status monitoring power formula of the present invention is a database status monitoring method that dynamically displays the usage status of a database. In the monitoring information to be registered by a monitoring information collecting means for recording the occurrence of an event in a monitoring information collecting file; and a monitoring information instructing means that registers the occurrence of an event in the monitoring information collected by the monitoring information collecting means when a display request command is input from the user. A monitoring information table (J< means) for displaying in a database usage status report those items that match the monitoring criteria by performing the processing instructed by the monitoring criteria and checking whether or not they match the monitoring criteria.

〔Example〕

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

FIG. 1 is a block diagram illustrating an embodiment of the database status monitoring system of the present invention.

As shown in FIG. 1, this embodiment includes a database monitoring harassment meter 1, a database directory 2, a monitoring information collection file 3, a display request command 4, a database usage status report 5, and a monitoring information instruction means 10. ,
Database management system 20 and monitoring information collection means 3
0, and monitoring information display means 40.

The operation of this embodiment will be described below in the order of monitoring information registration processing, monitoring information collection processing, and monitoring information display processing.

The engineering monitoring information registration process monitoring information instruction means 10 includes a database management system 2.
From among the events caused by 0, monitoring information collection means 3
Input the database monitoring parameter 1 that describes the monitoring target item that selects the event to be the target of information collection by 0, and the monitoring criteria that determines the display criteria when displaying the collected information on the monitoring information display means 40, The items to be monitored and the criteria for display are registered in the database Eye Leftry 2.

FIG. 2 is a diagram showing an example of database monitoring parameters 1 of this embodiment.

Referring to FIG. 2, the TYPE parameter 201 specifies the item to be monitored. In this example, the number of page WRITEs per file (monitoring item number 2), the number of page WRITEs per transaction (monitoring item number 4), the number of table references (monitoring item number 5), and the number of overflows per file (monitoring item number 4). Number 8)
, instructs to collect the number of deadlock occurrences (monitoring item number 10), and when a request to display monitoring information is issued in the RPT parameter 202, 1 is set for page WRITE.
1noDronk specifies that files that have exceeded 00 times and transactions that have exceeded 10 times will be output only, table references will be output when the number of table references exceeds 20 times, and overflows will be output unconditionally. Regarding the number of times, it is written that it will be output if it is fired 10 times or more.

FIG. 3 is a four-piece flowchart showing an example of the processing flow of the monitoring information index/J<'J" stage 10 of this embodiment.

Referring to FIG. 3, the monitoring information instructing stage 10 inputs database monitoring parameter 1 (step 301) L;
When the end of the parameters is confirmed (step 302), the monitoring target item table is output to the database directory 2, and the process ends (step 308).

If a parameter is input, check whether it is a TYPE parameter that describes the item to be monitored (step 303).
, describes the display criteria of the monitored item specified by the TYPE parameter, and determines whether it is an RPT parameter (step 304).

When the TYPE parameter is input, a monitoring item number is obtained from the TYPE parameter (Step 309), and a monitoring target item table is created in memory (Step 3).
10) Transfer control to the database monitoring parameter input again. , When the RPT parameter is input, it checks whether the monitored item table has been created in the memory (step 305). If it has not been created yet, an error is returned and the process returns (step 305). 311) End the process. If created = fj, obtain the display reference value from the RPT parameter (Step 30B), set it in the corresponding area of the monitoring target item table (Step 307), and all monitoring target items input at one time. After completing the setting of display standard values in the table, it requests input of the next database monitoring parameter.

FIG. 4 is a diagram showing an example of a monitoring target item table corresponding to the database monitoring parameters shown in FIG. 2.

Referring to FIG. 2, the monitoring target item table is composed of a monitoring item [1 number field, which does not represent the number, and a reference value field, which represents the display reference value of the monitoring item, and each field (2, 2, 100), (4,10), (5,20),
Values of (8, 0) and (10, 10) are set.

■Monitoring information collection process The monitoring information collecting stage 30 monitors when a specified event occurs from the database management system 20 that executes database search and update processing according to user requests. It is called with the item number and data as parameters, and the monitoring information instruction means 10 collects information only about the monitoring target items registered in the database directory 2 and outputs it to the monitoring information collection file 3.

FIG. 5 is a flowchart showing an example of the processing flow of the monitoring information collection means 30 of this embodiment.

Referring to Figure 5, 1. The monitoring information collecting means 30 first checks whether information about the monitoring target items registered in the database directory 2 is expanded in the memory in step 501. ), if it has not been expanded, reads the monitoring target item table from database directory 2 (step 502).
. Next, check whether the critical item [] number passed from the database management system 20 is registered in the monitoring target item table (step 503), and the unregistered monitoring item [, 1 number] is checked. In some cases, the database management system controls the collection process without performing the collection process (T), 20
Return to If it is a registered monitoring item number, the input data passed from the database management system 20 is edited in a predetermined manner for each astigmatism target item (
Step 504), output to the monitoring information collection file 3,
(Step 505) Control is returned to the database management system 20 3. ■Monitoring information display processing The monitoring information display means 40 is activated in response to a request from the user, and is registered in the database directory 2 by the monitoring information indicating stage 10. Edit and display only the information that meets the display criteria for the monitored items.

FIG. 6 is a flowchart showing an example of the processing flow of the monitoring information display means 40 of this embodiment.

Referring to FIG. 6, the monitoring information display means 40 first:
Check whether the information about the monitoring target items registered in the database directory 2 is expanded to the memory 1 (step 601), and the information about the monitored items registered in the database directory 2 is expanded.
If not, the database directory 2
The monitoring target item 1-1 table is read from the table and expanded into the memory 7 (step 602). Next, input the monitoring information collection file 3 (Step 603), and input each monitoring item [1:1
Add a predetermined aggregation process to the first place and add monitoring items]
A file is created (steps 604, 605). After that, the oldness monitoring item 11 editing file is read (step 606), and only those that satisfy the display criteria specified in the monitoring target item table are selected (step 607).
808), edit the monitoring items to medium level and output a database status display report (step 609).

〔Effect of the invention〕

As explained below, the database status monitoring method of the present invention reduces the amount of information to be collected by limiting the items to be monitored, and also allows the database status monitoring method to reduce the amount of information to be collected by limiting the items to be monitored. Only those items that exceed the specified standards can be displayed. This has the effect of minimizing the amount of data collected in order to accurately understand the database situation, and the analysis of the collected data. It also has the effect of minimizing the amount of data handled.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing an embodiment of the database status monitoring method of the present invention, FIG. 2 is a diagram showing examples of database monitoring parameters of this embodiment, and FIG. 3 is a block diagram showing monitoring information of this embodiment. A flowchart showing an example of the processing flow of the instruction means 10, FIG. 4 is a diagram showing an example of a monitoring target item table corresponding to the database monitoring parameters shown in FIG. 2, and FIG. A flowchart showing an example of the processing flow of the means 30. FIG. 6 is a flowchart showing an example of the processing flow of the monitoring information display means 40 of this embodiment. 1...Database monitoring parameters, 2...Database directory 1.3...Monitoring information collection file, 4...Display request command, 5...Database usage status/port, 10...Monitoring information instruction means, 20
...Database management system l1.30...Monitoring information collection means, 40...Monitoring information display means.

Claims (1)

[Claims] In a database status monitoring method that dynamically displays the usage status of a database, there is a monitoring information instruction means that inputs database monitoring parameters that describe the monitored items and their monitoring criteria and registers them in the database directory, and a monitoring information collection means that is called from a database management system when an event corresponding to a monitoring target item registered by the monitoring information instruction means occurs and records the occurrence of the event in a monitoring information collection file; When the display request command is input, the monitoring information collected by the monitoring information collecting means is processed as instructed by the monitoring standard registered by the monitoring information instructing means, and it is checked whether or not it matches the monitoring standard. 1. A database status monitoring method characterized by comprising a monitoring information display means for displaying on a database usage status report information that is found to be consistent.