JPH096655A - System management device - Google Patents

Abstract

PURPOSE: To facilitate the system management for a data base. CONSTITUTION: A protocol such as an internet protocol, etc., that is similar to a network management protocol is available through a data base management control part 1 of a management device 11 for a system manager to control a data base 16. In other words, for instance, it is possible to recognize whether the communication message including an identifier is equal to the data base access information or another by registering the identifier of the data base 16 in a MIB(management information base) tree of an SNMP(simple network management protocol). Furthermore, a transaction control part 3 is added to operate a TP monitor 17 by means of a similar protocol. As a result, the centralized control is possible from a remote place for the data base 16 and monitor 17 by a user interface similar to a network management object 15 via a network 10.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system management device capable of centrally managing a database, a transaction monitor, and a network with the same user interface.

[0002]

2. Description of the Related Art At present, as computer hardware prices have become lower, computer systems distributed and connected via networks such as LANs (local area networks) have become mainstream. In such a situation, the operation of the database provided in the system is conventionally performed.
It was done as follows. Each host computer connected via a network has a database and a transaction monitor (hereinafter referred to as TP monitor). Here, the TP monitor is a device that executes and controls a series of processes such as updating information stored in a database requested by many computer users (users) in units of "transaction".

On the other hand, in the database management device,
The database management software manages the database by obtaining or setting information in the database. In this case, the information obtained from the database is indicated by numbers or characters on the display of the terminal or the like. Also,
In the network management device, a manager existing in the management device issues a request for acquisition or setting of information to an agent existing in the managed device by using a network management protocol. When this request is for network management, the agent has acquired or set information for the target of network management by using the device for acquiring and setting management target information. For example, if this request is for TP monitor management, the agent has acquired or set information for the TP monitor using a device for acquiring and setting TP monitor information. The agent was sending the result of this request to the manager using a network management protocol.

[0004]

However, the above-mentioned prior art has the following problems. That is, even when the database management device and the network management device or the TP monitor management device are both present in the distributed system, the user interfaces are different when they operate independently. Therefore, the operation burden on the system administrator has been heavy.

In the case where databases are provided in a distributed manner in a distributed system, the system administrator must log in to the device on which each database operates and start up the database management software. Couldn't manage. Therefore, the operation of the database has become complicated. On the other hand, in a system environment where the terminal operated by the system administrator cannot log in to the device on which the database operates,
The database could not be managed.

Further, when a failure occurs, it is necessary to use the database management apparatus and the TP management apparatus of each device in order to isolate the failure. In each device, the information about the database is displayed in numerical values or characters, which is very difficult to understand. Therefore, the operation at the time of failure recovery is complicated and requires skill. still,
In a system having only a database management device, network management and TP monitor management were impossible. Further, in a system having only a network management device and a TP monitor management device, database management was impossible.

[0007]

In order to solve the above-mentioned problems, a system management device of the present invention comprises a manager and at least one or more agents that perform processing in response to a request from the manager, and a network The system managed by using the management protocol is characterized by the following points. (1) 1. A database management control unit for performing database management including acquisition and setting of database information using a network management protocol is provided. 2. When the network management protocol sent from the database management control unit is for database management, a database control unit for performing control including acquisition and setting of information for the database is provided.

(2) 1. A database management control unit for performing database management including acquisition and setting of database information using a network management protocol is provided. 2. When the network management protocol sent from the manager is for database management, a database control unit for performing control including acquisition and setting of information for the database is provided. 3. When the network management protocol sent from the manager is for transaction management, it has a transaction control unit for performing control including acquisition and setting of information for the transaction monitor.

(3) In (1) or (2), the l or more databases and transaction monitors operating in a distributed manner are centrally managed by the same user interface from l or more managers. Characterize. (4) In (1) or (2), a screen display device for displaying the state of the database by an icon is provided.

[0010]

[Action]

(1) When the system administrator operates the database, the database management control unit of the management apparatus can use a protocol similar to the network management protocol (for example, the Internet protocol). That is, for example,
MI of SNMP (Simple Network Management Protocol)
By registering an identifier for database management in a B (Management Information Base) tree, it is possible to distinguish whether a communication message having the identifier is database access information or other information. As a result, it is possible to add a database management device to the network management device and perform centralized management of the database from a remote location via the network with a user interface similar to that of the network management device.

(2) In (1), as a result of adding a TP monitor management device and operating with a similar protocol, a database and a database are operated from a remote place via a network with a user interface similar to that of the network management device. Centralized management of the TP monitor can be performed. (3) In (1) or (2), as for the distributed database, each database can be operated by the communication information sent from the manager at one place. As a result, each database can be centrally managed and it is easy to deal with a failure Becomes (4) In (1) or (2), as a result of displaying the operation status of the database using various icons, the operation status can be recognized much more easily than the display by numbers or characters.

[0012]

Embodiments of the present invention will now be described in detail with reference to the drawings. FIG. 1 is a block diagram of an embodiment of the system management apparatus of the present invention. The illustrated apparatus includes a management apparatus 11 and a managed apparatus 12 connected via a network 10.
And the like, and includes a database management control unit 1, a database control unit 2, a transaction control unit 3, and a screen display device 4.
Etc. are provided. The management device 11 and the managed device 12 are
Each consists of workstations. Management device 11
Has a manager 13, and the managed device 12 has
There is an agent 14.

The database management control unit 1 is provided in the manager 13 and manages the database 16 using a network management protocol. For example, the information in the database 16 is acquired and set. The database control unit 2 is provided in the agent 14,
When the network management protocol sent from the manager is for database management, control including acquisition and setting of information on the database 16 is performed. The transaction control unit 3 uses the agent 1
If the network management protocol sent from the manager is for managing transactions, the TP monitor (transaction monitor) 17 performs control including acquisition and setting of information.

The network control unit 5 provided in the agent 14 also receives the network management target 15 when the network management protocol sent from the manager is for the original network management.
Is controlled. For example, various messages are transmitted and displayed on a display (not shown) of the managed device 12 or the like. On the other hand, other managed devices 18, 19 and the like are also connected to the network 10. Each managed device is composed of a workstation and has a database and a TP monitor. Transactions processed by these TP monitors use an appropriate database of databases in the managed device in which the transaction monitor exists or databases in other managed devices connected via the network 10. It is processed.

Next, the operation of the above-mentioned system management device will be described. In FIG. 1, the manager 13 existing in the management device 11 issues a request 101 for acquisition or setting of database information to the agent 14 existing in the managed device 12 using a network management protocol. For example, a database identifier or the like is input using the MIB tree of SNMP. In this case, it is possible to distinguish between a communication message, database access information, and other information by a predetermined identifier in the MIB tree. In response to this request, the agent 14 uses the database control unit 2 to acquire or set 103 information in the database 16.
After this, the agent 14 returns the request result 102 to the manager 13. Then, the manager 13 returns the result 1
In order to display 02, the database management control unit 1 is used to display the status of the database on the screen display device 4 in the form of an icon. In this way, the database can be managed by the manager 13 for network management.

On the other hand, when the request 101 is for network management, the network control unit 5 acquires or sets information 104 for the network management target 15. If the request 101 is for TP monitor management, the transaction control unit 3 acquires or sets information for the TP monitor 17. In these cases as well, the agent 14 sends the request result 102 to the manager 13 using the network management protocol. And
The manager 13 performs a predetermined display on the screen display device 4. The specific content of this display is the same as the conventional one.

Further, in the present invention, the information of the database, which was conventionally difficult to understand with numbers and characters, can be displayed as an easy-to-understand icon as shown in FIGS. Specific examples of these display methods are shown below. (1) Like the icon 21 in FIG. 2, the state of the session of the database is represented by a moving image of turning wings. This is because a moving image more accurately shows the operating state to the system administrator, but a still image may be used.

(2) Like the icon 22 in FIG. 2, the locked state of the session is represented by, for example, a picture of a key. (3) Like icons 23 and 24 in FIG. 3, the I / O status to the database file is represented by the picture color of the database, the color and size of the arrow. For example, the icon 23 is 10KB
The writing state of the data is shown. Also, the icon 24
Indicates the write state of 26 KB data and the read state of 34 KB data. (4) As shown by each icon in FIG. 4, the usage amount of the database space is indicated by the number and color of the parcels placed on the table picture.

As described above, in the present embodiment, the following effects can be obtained by the system management device in which the database management device, the TP monitor management device and the network management device are combined. (a) Since the information of the database and TP monitor can be displayed and set with the same user interface as that of the network management system, the burden on the system administrator can be reduced. (b) Since the database can be managed by the standard protocol in network management, it is possible to manage it from various managers using the standard protocol.

(C) Remote management and centralized management from the network management manager are possible for databases operating in a distributed manner on the network. (d) By combining TP monitor management and database management, information collection (performance management, statistical management) for setting to optimize the processing speed in transaction processing, and the location of failure when a failure occurs It is possible to easily perform switching (fault management) and grasping which device is operating (configuration management).

The present invention is not limited to the above-mentioned embodiments, and it goes without saying that various modifications can be made. For example, although the distributed system has been described in the above-described embodiments, the present invention is not limited to this and can be applied to a system in the same computer.
That is, when managing the database, the system administrator can manage the database without being aware of whether the database exists where it is connected by the network or in the same computer.

[0022]

As described above, according to the system management apparatus of the present invention, the network management protocol is used when accessing the database.
It has the following effects. That is, when both the database management device and the network management device or the TP monitor management device exist in the distributed system, their user interfaces can be unified. For this reason, it is possible to ease the database operation burden on the system administrator.
Even if the databases are distributed in the distributed system, the system administrator does not need to log in to the device on which each database operates and launch the database management software. Can be managed in a unified manner. on the other hand,
The database can be managed even in a system environment in which the terminal operated by the system administrator cannot log in to the device in which the database operates.

Further, even when a failure occurs, it is not necessary to use the database management apparatus or the TP management apparatus of each device in order to isolate the failure, and the recovery work can be performed by one management apparatus. You can In this case, in each device, the information regarding the database is displayed as a still image or a moving image with an icon, so that it is easy to understand the operation status of the database. Therefore, the operation at the time of failure recovery becomes easy, and no skill is required. It should be noted that a computer having only a database management device can perform network management and TP monitor management of other computers via the network, and a computer having only the network management device and the TP monitor management device can operate via the network. It is possible to manage the database in another computer.

[Brief description of drawings]

FIG. 1 is a block diagram of an embodiment of a system management apparatus of the present invention.

FIG. 2 is an explanatory diagram of a database information screen display example (No. 1).

FIG. 3 is an explanatory diagram of a database information screen display example (No. 2).

FIG. 4 is an explanatory diagram of a database information screen display example (No. 3).

[Explanation of symbols]

 1 database management control unit 2 database control unit 3 transaction control unit 4 screen display device 5 network control unit

Claims (4)

[Claims] 1. A system comprising a manager and at least one or more agents for performing processing in response to a request from the manager, wherein the system is managed using a network management protocol, wherein a database of the database is created using the network management protocol. When the database management control unit that performs database management including acquisition and setting of information and the network management protocol sent from the database management control unit performs database management, control including acquisition and setting of information for the database A system management device comprising: 2. A system comprising a manager and at least one or more agents for performing processing in response to a request from the manager, the system being managed using a network management protocol, wherein a database of a database is created using the network management protocol. When the database management control unit that performs database management including acquisition and setting of information and the network management protocol sent from the database management control unit performs database management, control including acquisition and setting of information for the database And a database control unit for performing transaction management when the network management protocol sent from the database management control unit performs transaction management, a transaction control for acquiring and setting information for the transaction monitor. A system management device comprising an operation control unit. 3. The method according to claim 1, wherein at least one database and transaction monitor operating in a distributed manner are centrally managed by at least one manager with the same user interface. System management device. 4. A screen display device for displaying the status of the database by an icon is provided.
Alternatively, the system management device according to claim 2.