JPH0659964A - Management system for distributed operation of dictionary - Google Patents

Abstract

PURPOSE:To eliminate the necessity of managing the distributed destinations of definition information at the time of updating/registering the definition information and to distribute a relating definition member to a relating distributed operation system. CONSTITUTION:In order to execute operation based upon up-to-date definition information, a DB/DC system 3B in a production machine B is required to copy member records SCM1A, SUB1A, UAP1A from a testing/developing machine to a production machine side dictionary 2B as dictionary members SCM1B, SUB1B, 6UAP1B through a testing/developing side definition member transfer processing part 7-1A and a production machine side definition member transfer processing part 7-1B. In this case, a dictionary management system part 1A previously registers information relating to a management item name, a member's name and a distributed system name in a dictionary management table 7A stored in a dictionary 2, refers the table 7A at the time of distributing the definition members and executes distribution control based upon the contents of the table 7A.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a distributed operation management system for dictionaries, and more particularly, from a test / development system.
The present invention relates to a dictionary distributed operation management method suitable for use in a business of distributing and operating a database and system configuration information as system environment definition information to a production system or another distributed online system.

[0002]

2. Description of the Related Art As a conventional technique relating to a dictionary distributed operation management system, for example, the technique described in Japanese Patent Laid-Open No. 60-15752 is known.

In this conventional technique, one dictionary management book is provided for each of a plurality of systems each having a dictionary, and the dictionary management book is immediately updated when a member or the like in the dictionary is updated in each system. Instead, the DD / D (Data Dictionary / Director) that updates the dictionary management list when a request to refer to the dictionary management list occurs in the local system.
y) It uses the management information synchronization method.

[0004]

The above-mentioned prior art has a problem that definition information registered in a dictionary is centrally managed at one location, and all dictionary accesses are concentrated at one location. Moreover, since there is no means for automatically managing the distribution destination of the dictionary, there is a problem that the dictionary management information must be the same in all systems.

That is, the above-mentioned prior art does not take into consideration the management of distribution to the required parts of the dictionary members, and there is a problem that a human must manage the definition information between the systems. have.

Further, the above-mentioned prior art only considers the point of synchronization management of the dictionary management list, and considers the point of distribution transfer of dictionary members focusing on the relationship between the management items members of the update dictionary. However, there is a problem that the system operator must manually take responsibility for synchronous distribution of members related to the updated dictionary member.

Further, in the above-mentioned conventional technique, since the update to the DD / D management list is made at the time of referring to the next DD / D management list, it is difficult to know the timing of the update to the DD / D, and the reference update is performed by another system. The relationship with the time of occurrence becomes unclear, and it is difficult to troubleshoot when a failure occurs, and the recovery process becomes complicated. The object of the present invention is to solve the above-mentioned problems of the prior art and to define the arrangement information of the definition members in advance,
When registering and updating definition information, there is no need to manage the distribution destination of definition information at all, reducing the management cost of the system operation department, and related definition operations, related definition members can be distributed together. An object of the present invention is to provide a dictionary distributed operation management method that can be distributed to an operation system, does not require operation of management information for each member, and can reduce the operation time required for definition operation operation.

[0008]

According to the present invention, the object is to provide a dictionary management information section for holding management item information having distribution destination information and distribution date and time of the dictionary, and also to distribute the dictionary. This is achieved by managing the destination information by the own dictionary management function of recording and updating the dictionary management information section of the own dictionary, and managing the distributed distribution of the management item information by this function.

[0009] Further, the above object is to, when a change occurs in management item information in the dictionary, determine whether or not distribution of the management item member related to the changed management item member information and the management item member is required. By controlling by referring to the distribution destination management information of the dictionary management information section, it is possible to further perform the distribution process of the member information of the changed management item and the management item member related to the member of the management item. This is achieved by referring to the distribution management information in the dictionary management information section to determine whether distribution to other distributed sites has been completed.

Further, the above object is to control whether or not a dictionary member is distributed from a system on which this operation is performed to a system at another related distributed site in accordance with the dictionary definition operation. Achieved by

[0011]

[Function] The dictionary management information section, which holds the distribution destination information and distribution date and time of the dictionary, records in advance information about the distributed distribution destination system and the distribution status. When updating the definition information, the dictionary management information section stores the information in the distribution information. Based on this, the destination of the target system is determined. As a result, the definition information distribution management process can perform distributed operation management of the definition information without making the definition operator aware of the distribution destination each time, and prevent the operation error and facilitate the definition operation. You can

The dictionary distribution destination information is managed by the own dictionary management function for recording and updating the dictionary management information section of the own dictionary, and
Since the distributed management of the management item information is managed by this function, the definition management of the dictionary management information section can be performed using its own definition information management processing section, and a new control function is created. You don't have to.

Since it is possible to judge whether or not the dictionary management information section needs to be distributed to the distribution destination and whether or not it has been distributed, the distribution destination management information and the distribution management information can be referred to. Therefore, the distribution of the related dictionary members can be performed. Leakage can be prevented, and definition information that has been confirmed by the test / development system can be transferred to the production machine side without omission. Therefore, it is possible to ensure that the distribution destination system has consistency. Further, this makes it possible to minimize the amount of dictionary definition members to be distributed to other systems by changing the definition and reduce the distribution time of the definition members.

In addition, in a series of operations related to registration of definition members, confirmation of consistency, and generation of directories necessary for execution by the DB / DC system, related members are distributed to the distribution destination system at each operation stage. Since it is possible to perform the control for this, it is possible to explicitly give the time to reflect the distribution destination definition information, and it becomes possible to easily troubleshoot when a failure occurs,
The recovery process can be easily executed.

[0015]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a dictionary distributed operation management system according to the present invention will be described in detail below with reference to the drawings.

FIG. 1 is a block diagram showing a system configuration of a distributed dictionary operating environment for explaining an embodiment of the present invention, FIG. 2 is a view for explaining a data format of a dictionary distributed management table, and FIG. 3 is a dictionary distributed management table. FIG. 4 is a flow chart for explaining the operation of definition change and definition transfer processing related to definition member registration and definition information distribution processing, and FIG. 5 is a flow chart for explaining definition member distribution from a source system to a destination system. It is a figure explaining the operation | movement of the definition member definition registration distribution process which shows a mode that it performs. In FIG. 1, 1 is a dictionary management system unit, 2 is a dictionary, 3 is a DB / DC system, 4 to 6 are member records, 7 is a dictionary management information unit, and 7-1 is a definition member transfer processing unit.

In FIG. 1, which shows the dictionary distributed operation management system of one embodiment of the present invention in the relationship of each distributed site, the dictionary management system unit 1 controls input / output to / from the dictionary, and the dictionary 2 defines Member records 4 to 6 as information and a dictionary management information unit 7 in which the distributed distribution control information of the dictionary are stored are stored. DB / DC system 3
Executes various processes based on the definition information registered in the dictionary 2, and the definition member transfer processing unit 7-1 transfers the dictionary member storing the definition information in units of members. And, FIG. 1 illustrates the present invention as applied to three systems, namely a test / development machine and a system in which multiple production machines are interconnected. Each of these systems includes a dictionary management system unit 1, a dictionary 2, a DB / DC, respectively.
The system 3 and the definition member transfer processing unit 7-1 are provided, and in the figure, the symbols A, B, and C are given to distinguish these systems.

In the distributed dictionary operating environment shown in FIG. 1, the definition is registered and updated by accessing the dictionary 2 via the dictionary management system unit 1. Then, the definition management items as member records registered in the dictionary 2 are the schema definition information 4, the subschema definition information 5, and the UAP environment definition information 6, which have a reference relationship with each other.

Therefore, for example, when a new record type needs to be added and the schema definition information 4 changes, the related sub-schema definition information 5 also changes. Similarly, related UAP environment definition information 6
May change. These changes are made by the side using the definition information whether or not it is necessary to update the related definition information according to the content of the information to be changed.

Further, in the distributed development environment, as shown in FIG. 1, the dictionary management system unit 1A is a test / development system, and the dictionary management system 1B and the dictionary management system unit 1C are on the production machine side. The development machine side needs to distribute the definition information for which the test confirmation is completed to the production machine side. Therefore, in the embodiment of the present invention, only in the test / development system,
A dictionary management information section 7A for controlling distribution of this definition information is provided.

Now, the DB / DC system 3B of the production machine B
However, since the operation is performed based on the latest definition information, the member records SCM1A and SUB1 are sent from the test / development machine A.
A, UAP1A is the definition member transfer processing unit 7-1A on the test / development machine side and the definition member transfer processing unit 7-on the production machine side.
It is assumed that these member records are received via 1B. In this case, the dictionary management system unit 1B on the production machine side stores these member records in the dictionary 2B on the production machine side.
B, SUB1B, and 6UAP1B are copied.

In this case, the dictionary management system unit 1A registers, in the dictionary management information unit 7A, information about management item names, member names and distribution destination system names as a dictionary distributed management table, as shown in FIG. The definition member is referred to at the time of distribution, and distribution control of the member is performed based on the contents of the dictionary distribution management table.

In the dictionary distribution management table, as shown in FIG. 2, the management item name, member name, and distribution destination system name are registered as records for the dictionary members to be distributed, and further, as distribution destination management information. The distribution target flag 8, the distributable flag 9 as distribution management information, and the distribution date and time can be set. Then, for the members to be distributed, the distribution target flag 8 of the target distribution destination system is turned on,
The distributable flag 9 is turned on for the distributable members, the distributable flag 9 is turned off when the distribution is completed, and the distribution date / time 10 is set.

Then, the dictionary 2A of the dictionary distribution management table for storing the above-mentioned records.
The data is stored in the memory with a structure as shown in FIG. That is, each dictionary member record 13 of the member records 4 to 6 is stored as a parent record of the structural database, and the distribution destination system information 14 is stored in the dictionary data section 11 of the dictionary 2 as a child record of the structural database. Is stored. Further, each distribution destination system information 14 is a record 1 of the secondary index part indicating a child record regarding each system stored in the secondary index part 12 of the dictionary 2.
Managed by 5. As a result, information retrieval by distribution destination can be performed at high speed.

Next, the operations of the definition information change processing 41 and the definition information transfer processing 42 will be described with reference to the flow shown in FIG.

First, the operation of the definition information change processing 41 will be described.

(1) In the test / development machine, the dictionary management system section 1A uses the FET of the parent record 13.
By issuing a CH request to the DB / DC system 3A, the dictionary member that has been changed is read from the dictionary 2 and necessary definition information is updated (steps 411 and 412).

(2) Next, whether or not the corresponding dictionary member holds the distribution destination system information, the FETCH request of the child record 14 which is the distribution destination system information is issued to the DB / DC system 3A. Then check.
As a result, a not found is returned from the DB / DC system 3A, and if it is found that there is no child record subordinate to the parent record, this dictionary member considers it is not the target record for distributed distribution and ends the definition update process. (Step 413).

(3) If the dictionary member holds a child record in step 413, the distributed management table in which the child record is stored is read (step 414).

(4) Next, it is checked whether or not the distribution target flag 8 in the distributed management table read in step 414 is ON, and if it is ON, the distribution possible flag 9 is checked.
Is turned on, the update date of the member in the distributed management table is updated, and a STORE request for storing the child record in the dictionary 2A is issued again to the DB / DC system 3A to update the distributed management table. (Steps 415, 416, 417).

(5) If the distribution destination flag 8 is off in step 415, the distributable flag 9 and the member update date 10 are left unchanged, and the next child subordinate to the parent record in which the dictionary member information is stored. The record is read out via the 3DB / DC system, and then the same processing as described above is performed, and the processing for all the child records subordinate to the parent record of the dictionary member is repeatedly executed.

Next, the operation of the definition transfer process will be described.

(1) The distributed management table is read and it is checked whether or not a record having a distribution destination system is registered. If a record having a distribution destination system is not registered, the operation of this definition transfer process is terminated. (Step 4
21, 422).

(2) The parent record 13 related to the dictionary member as the operation target is searched, all the child records subordinate to the parent record 13 are searched, all the distribution destination system names are extracted, and the distribution destination is determined. For example, register the device distribution destination system name in the distribution destination list (step 4).
23, 424).

(3) For all distributed management tables,
After checking the steps 423 and 424, regarding the distribution destination system registered in the distribution destination list, the secondary index 1
5 to search all members related to the distribution destination system, register the searched members in the distribution member list, and collectively distribute those members to the distribution destination based on the created distribution member list. Then, the distribution necessity bit is turned off (steps 425 to 427).

(4) Step 4 for all distribution destinations
After repeatedly executing the processings 26 and 427, the processing ends (step 428).

Next, a method of processing the definition operation and the distribution of related members will be described with reference to FIG.

(1) When the definition is registered by the system as the transmission source, for example, the test / development machine A shown in FIG. 1, the operation is performed by the operate entry dictionary operation statement 51. In this case, the dictionary management system unit 1A can operate the schema definition member S by one operation.
CM01 and sub-schema definition member SUB01 definition registration processing is performed. This makes the sender dictionary 5
4, the schema definition member SCM01 and the subschema definition member SUB01 are registered as definition members.

In this defining operation, specification of SEND parameter is allowed as an option specification of the operation entry dictionary operation statement 51. When SEND is specified, the dictionary management system section 1A is specified.
Executes not only the registration of the definition members in the source dictionary 54, but also the operation of distributing these definition members to the receiving side dictionary 55.

(2) After all the definition members related to the schema SCM01 are registered in the dictionary 54 of the transmission source, the operation check dictionary operation statement 52 is issued by the user to ensure consistency as the next definition operation. Suppose

In this case, the dictionary management system unit 1A checks all the members related to the schema definition member SCM01 in the source dictionary 54 in order to ensure the consistency with respect to the designated member schema SCM01. Performs the process of taking sexuality.

The contents of consistency include the inconsistency detection of each definition contents and the associating process of related information. Even in this definition operation, specification of the SEND parameter is allowed as an option specification of the operation check dictionary operation statement. When SEND is specified, the dictionary management system unit 1A matches the definition member with the source dictionary 54. Not only to ensure sex
Members specified in the recipient dictionary 55, member storage schema definition member STR01 related to schema SCM01, and database environment definition member SDB01
Is also executed based on the definition change and definition transfer processing of FIG. 4 described above.

(3) Next, it is assumed that the user issues the operate entry directory operation statement 53 in order to generate a directory necessary for the execution operation of the DB / DC system 3A.

In this case, the dictionary management system unit 1A executes the related directory generation process for the designated member and the schema SCM01 as the source dictionary 5
Database schema directory DB from the storage schema definition member STR01 and physical area definition member PHA01 related to the schema definition member SCM01 in FIG.
A member S of S, SCM01, is generated as the directory 56 of the transmission source system. Even in this definition operation,
Specification of the SEND parameter is allowed as an option specification of the operate entry directory operation statement 53, and when the SEND specification is performed, the dictionary management system unit 1A creates the source directory 56 from the definition member for the source dictionary 54. Not only the members specified in the recipient dictionary 55, the members related to the schema SCM01, the storage schema definition member STR01 and the physical area definition member PH
The operation of distributing A01 based on the definition change and definition transfer processing shown in FIG. 4 is also executed.

According to the above-described embodiment of the present invention, a dictionary for integrated management of database information and system environment information, and a DB managed by the dictionary
/ DC system tests the dictionary definition members in a distributed operating environment consisting of multiple systems.
Even if the definition is changed in the definition distribution operation that is transferred from the development system to the production system, it is not necessary to be aware of the system to be distributed each time, and the cost for the definition distribution operation can be reduced.

Further, according to the above-described embodiment of the present invention, it becomes possible to distribute the related definition members at the same time, and in order to distribute the definition member information which has been tested once with the consistency guaranteed, It is possible to eliminate the need to redefine and retest on the production system side, which is the distribution destination, and to eliminate the need to perform test confirmation work on the production machine side. It is possible to reduce the number and to secure the reliability.

[0047]

As described above, according to the present invention, the distribution process of the definition member relating to the definition operation for the plurality of distributed production systems from the test / development system can be performed without paying attention to the distribution destination every time. In addition, it is possible to distribute the definition members while maintaining the consistency of the related definition members, and it is possible to reduce the maintenance man-hours in the distributed development operation work of the definition members.

[Brief description of drawings]

FIG. 1 is a block diagram showing a system configuration of a distributed dictionary operating environment for explaining an embodiment of the present invention.

FIG. 2 is a diagram illustrating a data format of a dictionary distribution management table.

FIG. 3 is a diagram illustrating a storage structure of a dictionary distribution management table.

FIG. 4 is a flowchart illustrating the operation of definition change and definition transfer processing related to definition member registration and definition information distribution processing.

FIG. 5 is a diagram for explaining the operation of a definition member definition registration / distribution process showing how a definition member is distributed from a source system to a destination system.

[Explanation of symbols]

 1 dictionary management system section 2 dictionary 3 DB / DC system 4 to 6 member record 7 dictionary management information section 7-1 definition member transfer processing section

Claims (2)

[Claims] 1. A dictionary decentralized operation management method for a system comprising a plurality of dictionaries for integrated management of database information and system configuration information, and a DB / DC system managed by the dictionaries. One of the systems described above is provided with a dictionary management information section that stores the distribution destination information of the dictionary and the distribution date and time, and is a dictionary distributed operation management method. 2. The distribution destination information of the dictionary is managed by an own dictionary management function for recording and updating the dictionary management information section of the own dictionary, and the distributed distribution management of the dictionary is managed by the function. The dictionary distributed operation management method according to claim 1.