JPH0816370A - Managing list preparing device - Google Patents

Abstract

PURPOSE:To prepare a managing list in a short time so as to manage how respective programs use records and the items of records or the like as the components of common resources such as a data base to be commonly used by plural programs. CONSTITUTION:A name extracting means 12 extracts the names of records and the items of records as the components of the data base to be commonly used by the respective programs from a schemer file 4, registers those names on a name table 13, extracts the names of the items of a control table to be commonly used by the respective programs from a definition macro-file 5 and registers them on the name table 13. A source program analyzing means 15 analyzes which of plural source programs stored in a source file 6 refers to and updates the components corresponding to the names registered on the name table 13, and a registering means 16 registers the analyzed results on a managing list storage part 7 as the managing list.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to the maintenance of a computer system, and more particularly, to a database such as a record of a database, a record item, a control table item, etc., which is commonly referred to and updated by a plurality of source programs constituting the computer system. The present invention relates to a management list creation device that creates a management list for managing which source program refers to and updates a component of a common resource.

[0002]

2. Description of the Related Art In a computer system including a plurality of source programs, resources such as a database and various control tables are used as common resources for the plurality of source programs. Each source program does not always refer to and update all records in the database and all items in each record, but often refers to only a limited record or record items. Therefore, when there is a change or an error in a component of the database, it is necessary to promptly recognize the source program that refers to and updates the component, and to take measures such as correction. Therefore, conventionally, which source program refers to and updates the components of the common resource, such as records in the database, record items, and control table items, is registered in a management list.

For example, when a new record item is added to a database record, it is necessary to modify the source program that refers to and updates the above record, and in such a case, refer to the management list. By doing so, it is possible to immediately know the source program that needs to be corrected, referring to or updating the record to which the item of the record is added, so that the source program can be corrected promptly. Also, when the attribute (for example, the number of characters, etc.) of the item of the record is changed, similarly, the source program can be promptly corrected.

Further, for example, if an error is found in a form printed by a form printing source program and the cause is an error in the contents of a record in a database,
Of course, it is necessary to collect the incorrect form,
In addition, collect the printed matter printed by another source program that prints the erroneous record contents, or output the erroneous record contents to the disk device. Invalid the data output by the source program. It is necessary to do something like this. In such a case, by referring to the management book, the source program that refers to the record with the above error can be immediately known, what kind of printed matter should be collected, and what data on the disk device should be invalidated. Since it is possible to know whether or not to do so, if an error in the database is discovered, it can be immediately dealt with.

Conventionally, such a management book has been manually created based on a document in which a program is described.

[0006]

As described above, conventionally, a management book is manually created based on a document that describes a program, and it takes a lot of time to create the management book. However, there is a problem that it takes time for the contents of the management book to match the state of the latest computer system, when the contents of the database have changed (such as the contents of the database or the contents of the source program have changed). At the same time, there was a problem that the contents of the management book might be incorrect.

SUMMARY OF THE INVENTION It is an object of the present invention to provide a management book creating apparatus capable of creating a management book suitable for the latest computer system without errors in a short time.

[0008]

In order to achieve the above object, the present invention defines, in a computer system including a plurality of source programs, components of a common resource that the source programs commonly refer to and update. A name extracting means for extracting the name of the component of the common resource from a file in which information including the name of the component is registered, and a component corresponding to the name extracted by the name extracting means. ,
Source program analysis means for analyzing which of the plurality of source programs is referenced or updated,
A management book storage unit and a registration unit for registering the analysis result of the source program analysis unit in the management book storage unit are provided.

[0009]

The file defines the components (records, record items, etc.) of common resources (databases, control tables, etc.) that are commonly referred to and updated by a plurality of source programs constituting the computer system. Information including name tags (schema, original text for redefinition, definition table definition macros, etc.) is stored.

The name extracting means extracts the names of the constituent elements of the common resource, such as the names of the records in the database, the names of the items in the records, and the names of the items in the control table, from the above-mentioned file, and the source program analyzing means. Analyze by which source program the constituent element corresponding to the name extracted by the name extracting means is referenced and updated, and the registration means registers the analysis result of the source program analysis means in the management book storage unit. .

[0011]

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 present invention, in which a management book making device 1, an input device 2, and a display device 3 are provided.
And a schema file 4 storing a schema that defines components of a database (not shown) provided in the computer system, and a definition defining components of a control table (not shown) provided in the computer system A definition macro file 5 in which macros are stored, a source file 6 in which source programs constituting the computer system are registered, a management list storage unit 7, and a management list storage unit 7
And a reference means 8 which enables a user to refer to the management book stored in the management book.

The management book creator 1 includes a control means 11, a name extraction means 12, a name table 13, a source file reading means 14, and a source program analysis means 15.
And registration means 16.

The name tag extracting means 12 extracts a name of a record and an item of the record which are components of the database from the schema file 4 and registers it in the name table 13 and a control which is a component of the control table. It has a function of extracting a name of a table item from the definition macro file 5 and registering it in the name table 13.

The source file reading means 14 has a function of reading a source program from the source file 6.

The source program analyzing means 15 analyzes the source program read by the source file reading means 14 and refers to the component corresponding to the name registered in the name table 13 to update the source program. It has the required function.

The registration unit 16 has a function of registering the analysis result of the source program analysis unit 15 in the management book storage unit 7.

FIG. 2 is a flowchart showing an example of processing by the control means 11, FIG. 3 is a flowchart showing an example of processing by the name extraction means 12, FIG. 4 is a flowchart showing an example of processing by the source file reading means 14, and FIG. FIG. 6 is a flow chart showing a processing example of the program analysis means 15, and FIG. 6 is a flow chart showing a processing example of the registration means 16, and the operation of this embodiment will be described below with reference to the drawings.

When constructing the computer system or when it is necessary to adjust the contents of the management book to the latest state of the computer system, the administrator of the computer system sends the information from the input device 2 to the management book creation device 1. Enter the management list creation instruction.

The management book creation instruction is sent to the management book creation device 1
When the control unit 11 receives the management list creation instruction, the control unit 11 instructs the name extraction unit 12 to extract the name tag, as shown in the flowchart of FIG.
(Step S1).

Upon receiving this instruction, the name tag extracting means 12
Extracts the name of one record or record item from the schema file 4 as shown in the flowchart of FIG.
It is registered in the name table 13 (step S11,
S12). The name extracting means 12 extracts the name of the record and the name of the item of the record in the schema file 4 (step S13: YES), and returns to steps S11 and S11.
The processes of S12 and S13 are repeatedly performed.

Now, for example, if the contents of the schema file 4 are as shown in FIG.
Names BU-REC, BU-CODE, and BU of the record and record items set in the record entry
-NAME, KA-REC, KA-CODE, KA-N
AME,... Are sequentially extracted and registered in the name table 13 (steps S11, S12).

The name-mark extraction means 12 is a schema file 4
When all the records and the names of the items of the records registered in are extracted (YES in step S13), the control table items are defined from the definition macro file 5 that defines the control table items that are the constituent elements of the control table. One name tag is extracted and registered in the name tag table 13 (steps S14 and S1).
5). The name extracting means 12 extracts all the names of the items of the control table in the definition macro file 5 (step S1).
6 is YES), the processing of steps S14, S15, S16 is repeated.

FIG. 9 is a diagram showing an example of a control table provided in the computer system. This control table is a control table for managing the status (normal, fault, etc.) of the terminal connected to the computer system, and includes TERMINAL-TABLE, TERMINAL as names of items in the control table.
-ID and JYOTAI.

FIG. 10 is a diagram showing an example of the contents of the definition macro file 5, and the portion A in FIG. 10 is a definition macro corresponding to the control table of FIG. There are various control tables other than those shown in FIG. 9, such as control tables for managing the status of tasks operating on the computer system. The definition macro file 5 is provided in the computer system. Definition macros for all control tables are registered.

Now, for example, if the contents of the definition macro file 5 are as shown in FIG.
Is TERMINAL-TABLE, TERMINAL
-ID, JYOTAI ... are sequentially extracted from the definition macro file 5 and registered in the name table 13. As a result, the contents of the name table 13 are as shown in FIG.

When the name extraction means 12 extracts all the names of the items of the control table in the definition macro file 5 and registers them in the name table 13, it notifies the control means 11 of the end of extraction (step S17). ).

The control means 11 is notified of the end of the extraction from the name mark extraction means 12 (FIG. 2, step S2 is YE).
S), instruct the source file reading means 14 to read one source program (step S)
3).

When the reading of the source program is instructed from the control means 11, the source file reading means 14 reads one unread source program from the source file 6, as shown in the flowchart of FIG.
(Step S21). If one unread source program (for example, the source program having the source program name SOU1) can be read (YES in step S22), the control unit 11 is notified of the end of reading the source program (step S23). If there is no source program which has not been read (NO in step S22), the control unit 11 is notified of the end of the source program (step S24).

When notified of the end of the reading of the source program from the source file reading means 14 (FIG. 2, step S4 is YES), the control means 11 operates the source program analyzing means 15 (step S5).

Thus, the source program analyzing means 1
5 focuses on one mark (for example, BU-REC) registered in the mark table 13 as shown in the flowchart of FIG. 5 (step S31). After that, the source program analysis unit 15 searches for the source program of the source program name SOU1 read by the source file reading unit 14, and finds the name BU-R focused on in step S31.
Search for EC (step S33).

When the target mark BU-REC of interest cannot be found even after searching until the end of the source program of the source program name SOU1 (step S3).
4, S35 is NO, YES) is the name table 1
3 (for example, BU-C
Focus on ODE) (step S31).

In addition, the name mark BU-REC which is currently focused on
Is found (YES in step S34), it is analyzed whether the use type for the component of the name label BU-REC is reference or update (step S3).
6, S37). For example, when the source program with the source program name SOU1 is described in COVER and is referenced and updated by a database operation instruction, the target label BU-REC is STORE BU-RE.
C, MODIFY BU-REC, if it appears, the usage type is determined to be updated, and the FIND BU-R
When it appears in the form of EC ~, GETBU-REC ~, it is determined that the usage type is reference.

Thereafter, the source program analyzing means 15
Already indicates that the source program having the source program name SOU1 read by the source file reading means 14 uses the constituent element of the name tag BU-REC which is currently focused on in the usage type analyzed in step S36. If the data is being analyzed (YES in step S37), the process returns to step S33. In addition, when the source program with the source program name SOU1 analyzes for the first time that the constituent element of the name tag BU-REC currently focused on is used in the usage type analyzed in step S36, the analysis result is Then, the registration means 16 is notified of the usage type, the name tag BU-REC that is currently focused, and the source program name SOU1 (step S38).

The registration means 16 receives the name BU-REC and the source program name S from the source program analysis means 15.
When OU1 and the use type are notified, as shown in FIG.
Searches the management list storage unit 7 and analyzes the source program
If the name tag BU-REC notified from 5 is not registered in the management list storage unit 7 (NO in step S51), the name tag BU-REC, the source program name SOU1, and the use type are stored in the management list storage unit 7. New registration (step S52),
Otherwise (step S51 is YES), the name B
The source program name SOU1 and type of use are additionally registered in U-REC (step S53).

The management list storage unit 7 has, for example, the configuration shown in FIG. 11, and the registration unit 16 sends the name BU-REC, the source program name SOU1, and the use type “reference” from the source program analysis unit 15. If the name BU-REC is not registered in the management list storage unit 7 at that time, as shown in FIG. 11, the name BU-REC, the source program name SOU1, and the use type “reference” are stored in the management list. New registration is performed in the storage unit 7. The registration means 16
From the source program analysis means 15 to the name mark BU-REC,
The source program name SOU1 and the usage type "update" are notified, and at that time, the name book BU-RE has already been stored in the management book storage unit 7.
If C is registered, as shown in FIG. 11, the source program name SOU2 and the usage type "update" are changed to the name label BU-R.
Additional registration for EC.

When the registration means 16 is notified of the analysis result and the like,
(FIG. 5, step S38), the source program analysis means 15 has already analyzed that the source program having the source program name SOU1 refers to or updates the constituent element of the name tag BU-REC which is currently focused. It is determined whether or not (step S39), and if the determination result is YES, the next name tag registered in the name tag table 13 (for example,
Focusing on (BU-CODE) (step S31), if the determination result is NO, the process returns to step S33.

The source program analysis means 15 performs the same processing as described above on all the names registered in the name table 13, and performs the same processing on all the names registered in the name table 13. When the processing described above is performed, the control means 11 is notified of the end of operation (step S4).
0).

As shown in the flow chart of FIG. 2, when the control unit 11 is notified of the end of the operation from the source program analysis unit 15 (step S6: YES), the control unit 11 transmits the next source program to the source file reading unit 14. One is read (step S3), and the same processing as described above is performed until the source file reading means 14 notifies the end of the source program (until step S7 becomes YES).
When the end of the source program is notified from step 4 (YES in step S7), the process ends. As described above, the management book 7 as shown in FIG.
1 is created.

Next, the operation when the manager uses the management book 71 registered in the management book storage 7 will be described.

When a change is made to a component of the database or control table provided in the computer system, or when an error is found, the administrator can change the name of the changed component or the configuration in which the error was found. A reference instruction including the name of the element is input from the input device 2.

When a reference instruction is input from the input device 2, the reference means 8 searches the management book 71 registered in the management book storage unit 7 using the name included in the reference instruction as a key. The display unit 3 displays the source program name and the type of use registered in the management book 71 in combination with the target. The administrator can immediately see the changed component and the source program that is referring to and updating the changed component or the component in which the error was found. Necessary measures such as invalidating the processing performed by referring to the constituent elements can be performed promptly.

In the above-described embodiment, the name of the record in the database provided in the computer system and the name of the item of the record are extracted from the schema file 4. The name of a record and the name of a record item may be extracted from a redefined text file in which only the redefined text to be registered is registered. Although not described in the above-described embodiment, the management book storage unit 7 may be formed as a database.

[0044]

As described above, according to the present invention, components (records, items) of a common resource such as a database and a control table commonly used by a plurality of source programs.
The name extraction means for extracting the name tag of the component from the schema file, the definition macro file, the redefinition text file, etc., in which the information defining the Since a source program analysis means for analyzing which of a plurality of source programs has been referred to or updated is provided, comparison with the conventional technique in which a management list is created based on a document describing the program Then, there is an effect that a management book suitable for the latest computer system state without error can be created in a short time.

[Brief description of drawings]

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

FIG. 2 is a flowchart showing a processing example of a control means 11;

FIG. 3 is a flowchart showing a processing example of a name tag extracting means 12.

FIG. 4 is a flowchart showing a processing example of a source file reading means 14;

FIG. 5 is a flowchart showing a processing example of a source program analysis means 15;

FIG. 6 is a flowchart showing a processing example of a registration unit 16;

FIG. 7 is a diagram showing an example of the contents of a schema file 4;

FIG. 8 is a diagram showing an example of contents of a name tag table 13.

FIG. 9 is a diagram illustrating an example of a control table.

FIG. 10 is a diagram showing an example of the contents of a definition macro file 5;

FIG. 11 is a diagram showing an example of the contents of a management book storage unit 7;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Management book preparation apparatus 11 ... Control means 12 ... Name mark extraction means 13 ... Name mark table 14 ... Source file reading means 15 ... Source program analysis means 16 ... Registration means 2 ... Input device 3 ... Display device 4 ... Schema file 5 ... Definition macro file 6 ... Source file 7 ... Management book storage unit 71 ... Management book 8 ... Reference means

Claims (4)

[Claims] 1. In a computer system including a plurality of source programs, a file in which information including a name tag of the component is defined, which defines a component of a common resource that the source programs commonly refer to and update. A name extracting means for extracting the name of the constituent element of the common resource from the above, and a constituent element corresponding to the name extracted by the name extracting means is referred to or updated in any of the plurality of source programs. Management program creation means for analyzing whether or not the management program is stored, a management book storage unit, and a registration unit for registering the analysis result of the source program analysis unit in the management book storage unit. apparatus. 2. The common resource is a database, the components of the common resource are records and record items of the database, and the information registered in the file is a schema or redefinition original text. The management book creation device according to claim 1. 3. The common resource is a control table, the components of the common resource are items of the control table, and the information registered in the file is a definition macro of the control table. The management book creating apparatus according to claim 1. 4. The management book creation device according to claim 2, further comprising a display device, and a reference unit that outputs the contents of the management book storage unit to the display device.