JP2019159870A - Influence examination system, influence examination method and influence examination program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an impact investigation system, an impact investigation method and an impact investigation program for predicting the influence range of information used in a system in which a plurality of information processing is executed. SOLUTION: A control unit 21 of an impact investigation system 20 identifies all programs and output files using the file to be investigated in a parameter file in which file identification information to be input to a program used for a job is recorded. Using the job report information storage unit that records the output information including the item information output in the specified program and the input information including the item information for deriving the output information, the input information is not recorded and is the subject of investigation. From the output information in which the items of are recorded, the input information for deriving this output information is sequentially searched, the output items in the output stage are specified, and the influence range including the output file and the specific information of the output items is output. [Selection diagram] Fig. 1

Description

  The present invention relates to an influence investigation system, an influence investigation method, and an influence investigation program for predicting the influence range of information used in a system in which a plurality of information processes are executed.

  There are cases where a plurality of batch jobs are continuously executed for business management in an enterprise. In this case, it is necessary to consider the prior relationship of each job, and job execution is managed by a job network (job net) indicating such prior relationship. A failure may occur in such a job net. In view of this, a job operation management system for searching for a predecessor / successor relationship and investigating an influence range when a schedule of a predecessor job is changed has been studied (for example, see Patent Document 1). The job operation management system described in this document reads a job definition database in which job definitions and preceding / following waiting conditions can be defined, and reads job definition information stored in the job definition database. Search means for searching for a preceding / following relationship between a job and a succeeding job is provided. Then, specify the preceding job as a search condition on the search screen provided by the search means, execute a job search having a subsequent relationship with the preceding job, hold the search result information, specify the search result, and perform a recursive search. The subsequent job having the subsequent relationship with the preceding job is displayed on the search screen.

  Further, a technique for specifying an influence range and an influence degree and calculating a recovery priority when a job failure occurs in a job management system has been studied (for example, see Patent Document 2). In the technique described in this document, the influence range and the influence degree are determined from the priority, the scheduled start time, the end deadline time, the parent job net, and the succeeding job net specified by the user held by the job net and the job. And prioritize recovery. The recovery priority and the expected time for disaster recovery are displayed and the impact is visually output.

JP 2013-257803 A Japanese Patent Laying-Open No. 2015-64723

  In the technique described in the above-mentioned patent document, the influence range can be evaluated by using the prior relationship of the job net. However, some items in the file used for the job may be deficient. In this case, an item included in an output file of a job net that uses a file including this item as an input file may be affected. In this case, it is difficult to determine an appropriate influence range only by examining the relationship between jobs.

  In order to solve the above problems, the influence investigation system includes a control unit that evaluates the influence of items in the file on the output file in a job execution environment in which a job is executed using the file. Then, the control unit acquires information on the file and item to be investigated, and in the parameter file in which the file specifying information to be input to the program used for the job is recorded, all the programs and outputs that use the file to be investigated are recorded. Input information is recorded using a job report that records output information including item information output in the specified program and input information including item information for deriving the output information. In addition, from the output information in which the item to be investigated is recorded, input information for deriving this output information is sequentially searched, the output item in the output stage is specified, and the output file and the output item specifying information are included. The affected range is output.

  ADVANTAGE OF THE INVENTION According to this invention, in the information utilized within the system in which several information processing is performed, the grasp of the influence range of investigation object information can be supported.

The system schematic of this embodiment. It is explanatory drawing of the information used in the process sequence of this embodiment, (a) is a definition information management table, (b) is a job report, (c) is a parameter file, (d) is a dictionary management record, e) Explanatory drawing of the impact investigation sheet. Explanatory drawing of the process sequence of this embodiment. Explanatory drawing of the relationship between the item contained in the file of this embodiment, and a job. Explanatory drawing of the process sequence of other embodiment. It is explanatory drawing of other embodiment, (a) is a tree display, (b) is a process sequence, (c) is explanatory drawing of another tree display. Explanatory drawing of the process sequence of other embodiment.

Hereinafter, an embodiment of the impact investigation system will be described with reference to FIGS.
As shown in FIG. 1, in this embodiment, a file transfer management system 11, a job operation management system 12, a data integration support system 13, and an impact investigation system 20 are used.

  The file transfer management system 11 is a computer system that manages file transfer (collection and distribution) between information processing systems connected via a network. In the present embodiment, for example, file transfer from the upstream first system (counterpart system S1) to the downstream second system (internal management system S2) or the final output destination (output stage) from the second system ) Manages the file transfer to the third system (user system S3). Here, the counter system S1 is a computer system that performs account management of customers of financial institutions and management of customer transactions in a transaction market. The internal management system S2 is a computer system that performs accounting processing of financial institutions and creation of reports. The user system S3 is a computer terminal in the user department that uses the output (accounting processing result and report) of the internal management system S2.

  The job operation management system 12 is a system that manages each information processing using the file received by the file transfer management system 11. Each information processing is executed by, for example, a job net in a job execution environment. In this embodiment, the job executed by the internal management system S2 is managed.

  The data integration support system 13 is a system that manages data used in the job operation management system 12 (referred to as a “file” including a table and the like). The data integration support system 13 is an ETL (Extract / Transform / Load) tool that extracts data contained in multiple systems, converts and processes the data, and delivers the converted and processed data to the data warehouse. Use.

  The relationship between the items included in the file and the job will be described with reference to FIG. Assume that the downstream internal management system S2 that has acquired the file 50a acquired from the upstream counterpart system S1 generates the files 50b and 50c by executing the job J1. In this case, the items a1 and a2 included in the file 50a affect the items b1 and b2 of the file 50b and the items c1 and c2 of the file 50c.

  Further, when the file 50e is generated by executing the job J2 using the file 50d acquired from the counterpart system S1, each item of the file 50d affects each item of the file 50e. When the files 50f and 50g are generated by executing the job J3 using the files 50c and 50e, the items of the files 50c and 50e affect the items of the files 50f and 50g.

Then, the files 50b, 50f, and 50g are transferred to the user system S3 by the file transfer management system 11 at each transfer time.
Here, when there is a problem with the item a2 included in the file 50a, the files 50f and 50g provided to the user system S3 are affected.

  The influence investigation system 20 in FIG. 1 is a computer system that predicts the influence range of a file or item to be investigated. In the present embodiment, the influence range of files and items handled in the internal management system S2 is predicted. This influence investigation system 20 includes a control unit 21, a file transfer information storage unit 22, a job net information storage unit 23, a job report information storage unit 24, a parameter information storage unit 25, a user dictionary storage unit 26, and an influence investigation information storage unit 27. Is provided.

  The control unit 21 includes control means (CPU, RAM, ROM, etc.), and performs processes (each process such as an information acquisition stage, an analysis stage, and an output control stage) described later. The control unit 21 functions as the information acquisition unit 211, the analysis unit 212, and the output control unit 213 by executing the influence investigation program for that purpose.

  The information acquisition unit 211 acquires various information from the file transfer management system 11 to the data integration support system 13 and executes a process of recording them in the file transfer information storage unit 22 to the parameter information storage unit 25. In this embodiment, the collection / delivery master management registration file is acquired from the file transfer management system 11 and recorded in the file transfer information storage unit 22. Also, the definition information management table is acquired from the job operation management system 12 and recorded in the job net information storage unit 23. Also, a job report and a parameter file are acquired from the data integration support system 13 and registered in the job report information storage unit 24 and the parameter information storage unit 25, respectively. The information acquisition unit 211 executes these registration processes prior to the impact evaluation process described later.

The analysis unit 212 uses the information recorded in the file transfer information storage unit 22 to the parameter information storage unit 25 to analyze the influence range and execute a process of generating an influence range sheet.
The output control unit 213 executes processing for outputting the generated influence range sheet.

The file transfer information storage unit 22 records a collection / delivery master management registration file of files transferred between the customer system S1, the internal management system S2, and the user system S3. This collection / delivery master management registration file includes information regarding the file name, file ID, transfer condition, output destination system ID, and the like of the file to be transferred.
The file name and file ID are a name and identifier for specifying a file transferred by the file transfer management system 11. The transfer condition is a condition for transferring each file (an event that becomes a transfer timing or a transfer trigger). The output destination system ID is an identifier for specifying a file transfer destination system (for example, the user system S3 as an output stage).

  As shown in FIG. 2A, the job net information storage unit 23 records a definition information management table 230 relating to jobs executed in the internal management system S2. In the definition information management table 230, schedule definitions and parameters are recorded for each unit definition. Here, the root job (job net) executed in the internal management system S2 and the constituent jobs constituting the root job are called “units”.

  In the unit definition data area, data relating to an identifier for identifying each unit (root job, configuration job) is recorded. For example, the unit name of the constituent job associates the unit name of the root job by adding a branch code to the unit name of the root job.

A schedule for executing each unit is recorded in the schedule definition data area. In this schedule, a start date, a start time, a processing cycle, and a closed day are recorded for the unit of the root job. The start date is the date when the schedule is started, and the start time is the time when the job is executed. The processing cycle data is a root job execution cycle. “Closed day treatment” is information for determining whether or not execution is required when an operating day falls on a holiday.
In the parameter data area, an identifier (program ID) for specifying a program used in each unit is recorded.

As shown in FIG. 2B, the job report information storage unit 24 records a job report 240 related to each job. The job report 240 includes a job property 241, an output record 242, and an input record 243.
The job property 241 records information for specifying the program name and the write destination name. The program name is an identifier for specifying each program. The write destination name is an identifier (file specifying information) for specifying an output file output by executing this program.

  The output record 242 and the input record 243 are used to specify data (output information) output by the job property 241 program and data (input information) for deriving this output information. Here, input information used to derive the output information is sequentially associated with the output information. Specifically, the second information for deriving the first information recorded in one output record 242 is recorded in the input record 243. Furthermore, third information for deriving the second information is recorded in the input record 243 in the output record 242 in which the second information is recorded. As described above, the output record 242 and the input record 243 are linked, and the input information can be sequentially and sequentially derived from the output information.

  The output record 242 is provided with a data area in which the program ID, process name, item name, and variable name are recorded. The program ID is an identifier that identifies a program. The process name is an identifier for specifying a process to be executed in this program. The item name is an identifier for specifying an item included in the output file. The variable name is a variable used in this item.

  The input record 243 is provided with a data area in which data relating to a derivation source process name, a derivation source item name, and a derivation source variable name is recorded. The derivation source process name is an identifier for specifying a process to be executed in this program. The derivation source item name is an identifier for specifying an item included in the input file. The derivation source variable name is a variable used in this item.

  As shown in FIG. 2C, a parameter file 250 is recorded in the parameter information storage unit 25. In the parameter file 250, information related to files used in the program of each job is recorded. Specifically, the parameter file 250 is given a file name including a program ID. The parameter file 250 records data relating to the input file ID, input item ID, output file ID, and output item ID in this program. The program ID is an identifier for specifying each program. The input file ID and the input item ID are identifiers for specifying a file or item input to the job. The output file ID and the output item ID are identifiers for specifying a file or item output by this program.

  As shown in FIG. 2D, a dictionary record 260 is recorded in the user dictionary storage unit 26. In this dictionary record 260, data relating to item IDs and names is recorded. The item ID is an identifier that identifies each item included in the file. The name is the name of each item used in the user department.

  As shown in FIG. 2 (e), an influence investigation sheet 270 is recorded in the influence investigation information storage unit 27. The influence investigation sheet 270 is provided with a program information column, an input information column, and an output information column for each program that affects the investigation target column. Further, the influence investigation sheet 270 is provided with an influence range column.

In the investigation target column, information on the investigation target file and the investigation target item for which the influence range is investigated is recorded. Specifically, investigation target file information (file name, file ID) and investigation target item (item name, item ID) are recorded. The file name and file ID are the name of the file to be investigated and an identifier for identifying the file, respectively. The item name and item ID are an identifier for identifying the name and item of the item to be investigated.
In the program information column, information on the program affected by the survey target file or the survey target item is recorded. Specifically, information relating to the program name, program ID, job ID, job cycle, and next work day is recorded. The program name and the program ID are an identifier for identifying the name of the affected program and the program, respectively. The job ID is an identifier for specifying a job that calls this program. The job cycle is information relating to a cycle (for example, daily) in which the job is executed. The next working day is information relating to the next time (year / month / day) when this job is executed.

In the input information column, information on files and items to be input in this program is recorded. More specifically, information relating to an input file name, an input file ID, an input item, and an input item ID is recorded. The input file name and the input file ID are an input file name (input file) and an identifier for specifying the file, respectively. The input item and the input item ID are an item name and an identifier for specifying the item included in the input file, respectively.
In the output information column, information on files and items output from this program is recorded. Specifically, information relating to an output file name, an output file ID, an output item, and an output item ID is recorded. The output file name and the output file ID are a name of a file (output file) output in this program and an identifier (file specifying information) for specifying the file, respectively. The output item and the output item ID are an item name and an identifier for specifying the item included in the output file, respectively.

  In the influence range column, information on the system affected by the output file is recorded for each output file. Specifically, information relating to the output file name, output file ID, job ID, and output destination system ID is recorded. The output file name and the output file ID are the name of the output file output to the output stage (user system S3) and an identifier for specifying the output file, respectively. The job ID is an identifier for specifying a job that outputs the output file. The output destination system ID is an identifier for specifying the output stage (user system S3) from which the output file is output.

  The input unit 31 in FIG. 1 includes a keyboard and a pointing device, and acquires various types of input information. The output unit 32 is configured with a display or the like and outputs various types of information. The input unit 31 and the output unit 32 are used by an administrator of the impact investigation system 20.

(Impact assessment process)
Next, the impact evaluation process will be described with reference to FIG.
First, the control unit 21 of the influence investigation system 20 executes investigation target designation processing (step S1-1). Specifically, the analysis unit 212 of the control unit 21 outputs an influence investigation screen to the output unit 32. This influence investigation screen is provided with an input field for designating an investigation object file (file name, file ID) and an investigation object item (item name, item ID). Furthermore, an investigation result column is provided on the influence investigation screen. In this investigation result column, an influence investigation sheet 270 described later is output. And the analysis part 212 acquires the investigation object information (file name-item ID) which the user input into the input column using the input part 31. FIG. In this case, the analysis unit 212 records the acquired survey target information in the survey target column and the input information column of the impact survey sheet 270 of the impact survey information storage unit 27.

  Next, the control unit 21 of the impact investigation system 20 executes a parameter file search process (step S1-2). Specifically, the analysis unit 212 of the control unit 21 searches the parameter information storage unit 25 using the acquired survey target ID (file ID) as a key, and the parameter in which the survey target ID is recorded as the input file ID. The file 250 is extracted. Here, when the investigation target ID is recorded as the input file ID in the plurality of parameter files 250, all the parameter files 250 are specified. Then, the analysis unit 212 extracts a program ID from the file name given to the extracted parameter file 250. Then, the analysis unit 212 records the extracted program ID in the program information column of the impact investigation sheet 270. When a plurality of parameter files 250 are specified, they are recorded in different records of the impact investigation sheet 270. The analysis unit 212 outputs an error message to the output unit 32 when the parameter file 250 in which the investigation target ID is recorded cannot be extracted.

  Next, the control unit 21 of the impact investigation system 20 executes output file identification processing (step S1-3). Specifically, the analysis unit 212 of the control unit 21 specifies the output file ID recorded in the parameter file 250. Here, when a plurality of parameter files 250 are specified in step S1-2, an output file ID corresponding to each is specified. Then, the analysis unit 212 records the identified output file ID as an output file ID in the output information column of the impact investigation sheet 270.

Next, the impact investigation system 20 repeats the following processing for each output file.
Here, the control unit 21 of the impact investigation system 20 executes job identification processing (step S1-4). Specifically, the analysis unit 212 of the control unit 21 searches the parameter data area of the definition information management table 230 for the program ID extracted from the file name of the parameter file 250. Then, the analysis unit 212 identifies the definition information management table 230 in which the program ID is recorded in the parameter data area, and identifies the unit name recorded in the unit definition data area of the definition information management table 230.

  Next, the control part 21 of the influence investigation system 20 performs the specific process of the next working day (step S1-5). Specifically, the analysis unit 212 of the control unit 21 identifies a root job by a unit name that does not include a branch code in the identified definition information management table 230, and processes schedule definition information associated with the root job. Get a cycle. Next, the analysis unit 212 calculates the next working day from the calendar based on the identified processing cycle. Then, the analysis unit 212 records the job cycle (processing cycle) and the next working day in the program information column of the impact investigation sheet 270.

  Next, the control unit 21 of the impact investigation system 20 executes job report acquisition processing (step S1-6). Specifically, the analysis unit 212 of the control unit 21 acquires the job report 240 in which the program ID extracted from the file name of the parameter file 250 is recorded in the output record 242 from the job report information storage unit 24.

  Next, the control unit 21 of the impact investigation system 20 executes job report search processing (step S1-7). Specifically, the analysis unit 212 of the control unit 21 searches the acquired job report 240 for the output record 242 using the file ID and item ID of the investigation target column recorded in the influence investigation sheet 270 as keys. In this case, the analysis unit 212 records the investigation target file ID, the item name, and the item ID in the data areas of the process name, the item name, and the variable name, and specifies the output record 242 in which the input record 243 is blank as the start record. To do. Then, the analysis unit 212 receives the input record 243 in which the process name, item name, and variable name of the identified output record 242 (start record) are recorded as the derivation source process name, the derivation source item name, and the derivation source variable name. Identify. Further, the analysis unit 212 specifies an output record 242 derived from the input record 243. In this way, the input record 243 for deriving the output record 242 in a chain from the start record is specified.

  Next, the control part 21 of the influence investigation system 20 performs the determination process about whether it reaches | attains to the last (step S1-8). Specifically, the analysis unit 212 of the control unit 21 receives the input record in which the process name, item name, and variable name of the identified output record 242 are recorded as the derivation source process name, derivation source item name, and derivation source variable name. When 243 cannot be specified, it is determined that the end has been reached.

  When it is determined that it has not reached the end (in the case of “NO” in step S1-8), the control unit 21 of the impact investigation system 20 repeats the job report search process (step S1-7).

  On the other hand, when it determines with reaching | attaining to the last (in the case of "YES" in step S1-8), the control part 21 of the influence investigation system 20 performs the recording process of an output item (step S1-9). Specifically, the analysis unit 212 of the control unit 21 records the item name and variable name of the output record 242 that has arrived last as the output item and output item ID in the output information column of the impact investigation sheet 270. To do.

Next, the control unit 21 of the impact investigation system 20 executes output file specification processing (step S1-10). Specifically, the analysis unit 212 of the control unit 21 acquires the program name and the write destination name recorded in the job property 241 of the job report 240 acquired in step S1-6. Then, the analysis unit 212 records the acquired program name and writing destination name as the program name in the program information column and the output file name in the output information column of the impact investigation sheet 270, respectively.
Furthermore, the analysis unit 212 uses the file transfer information storage unit 22 to specify the file name of the output file, the transfer condition (transfer time) associated with the file ID, and the output destination system ID. Then, the analysis unit 212 records the output file name, output file ID, job ID, and output destination system ID in the influence range column of the influence investigation sheet 270, respectively.

Then, the impact investigation system 20 repeats the above processing until all the specified output files are finished.
Next, the control unit 21 of the influence investigation system 20 executes an influence investigation sheet output process (step S1-11). Specifically, the output control unit 213 of the control unit 21 outputs the impact research sheet 270 recorded in the impact research information storage unit 27 to the survey result column of the impact research screen in a list format. In this case, the output control unit 213 uses the user dictionary storage unit 26 to output the item ID in a form that can be converted into a user item name.

As described above, according to the present embodiment, the following effects can be obtained.
(1) According to the present embodiment, the control unit 21 of the impact investigation system 20 executes a parameter file search process (step S1-2) and an output file specification process (step S1-3). As a result, it is possible to specify a program (job) that uses the investigation target file or item and specify an output file of this program.

  (2) According to the present embodiment, the control unit 21 of the impact investigation system 20 executes a job specifying process (step S1-4) and a next operating day specifying process (step S1-5). As a result, it is possible to specify the execution time of the job that the investigation target file or item affects.

  (3) According to the present embodiment, the control unit 21 of the impact investigation system 20 executes job report acquisition processing (step S1-6) and job report search processing (step S1-7). When it is determined that it has not reached the end (in the case of “NO” in step S1-8), the control unit 21 of the impact investigation system 20 repeats the job report search process (step S1-7). As a result, the files and items that are affected by the survey target can be identified sequentially.

  (4) According to the present embodiment, the control unit 21 of the impact investigation system 20 executes output file specification processing (step S1-10). As a result, it is possible to identify the output stage file that the investigation target affects.

  (5) According to this embodiment, the control part 21 of the influence investigation system 20 performs the output process of an influence investigation sheet (step S1-11). As a result, it is possible to identify files, programs, and jobs that are affected by the file or item to be investigated.

This embodiment can be implemented with the following modifications. The present embodiment and the following modifications can be implemented in combination with each other within a technically consistent range.
In the above embodiment, the influence range of the investigation target file or the investigation subject item is output. In addition to this, the recovery status of a job related to a problem file or item may be predicted. In this case, the impact investigation system 20 is provided with an operation result storage unit and a recovery result storage unit. Further, the control unit 21 is provided with a recovery support unit for supporting recovery in consideration of the influence range.

  The operation result storage unit shown in FIG. 5 records the operation result time in association with the job ID. The job ID is an identifier for specifying each job. The actual operation time is the time required for processing for the unit data amount.

  In the recovery information storage unit, a recovery method candidate and a required recovery time are recorded in association with the file ID and the failure type. The file ID is an identifier for specifying each file. The failure type is an identifier for identifying the type of failure. The recovery method candidate is a recovery method candidate corresponding to the type of failure that has occurred in the file. For example, “upstream re-creation”, “downstream partial correction”, and the like are recorded. The time required for recovery is a statistical value of the time required for recovery according to the recovery method.

Next, the recovery prediction process will be described with reference to FIG.
Here, the control unit 21 of the impact investigation system 20 executes a recovery method candidate specifying process (step S2-1). Specifically, the recovery support unit of the control unit 21 acquires a recovery method candidate associated with the file ID of the file in which the failure has occurred from the recovery information storage unit.

Next, the control unit 21 of the impact investigation system 20 repeats the following processing for each acquired restoration method candidate.
Here, the control unit 21 of the influence investigation system 20 executes the process of specifying the influence range file and item (step S2-2). Specifically, the recovery support unit of the control unit 21 makes an analysis request to the analysis unit 212. This analysis request includes the file ID and item ID where the failure occurred. In this case, the analysis unit 212 executes the impact evaluation process (FIG. 3) using the file ID and item ID of the analysis request as the investigation target. Then, the analysis unit 212 outputs the influence range sheet generated by the influence evaluation process to the output unit 32.

  Next, the control unit 21 of the impact investigation system 20 executes related job identification processing (step S2-3). Specifically, the recovery support unit of the control unit 21 specifies the program ID in the program information column in the impact investigation sheet 270 in which the specified affected range file is recorded in the output information column. Then, the recovery support unit specifies a job (related job) associated with the program ID using the definition information management table 230 of the job net information storage unit 23. Thereby, it is possible to specify a related job necessary for outputting the output file.

Next, the control unit 21 of the impact investigation system 20 repeats the following processing for each related job.
Here, the control unit 21 of the impact investigation system 20 executes a recovery completion time prediction process (step S2-4). Specifically, the recovery support unit of the control unit 21 acquires the operation result time of the related job using the operation result storage unit. Then, the recovery support unit predicts the time required for executing the job based on the amount of data used for the job to be recovered. In this case, the recovery support unit generates a job schedule that specifies an operation time period in which the job is executed based on the required execution time for the job executed at the time of recovery. Then, the recovery support unit identifies the job congestion status in each time zone of the generated job schedule. In this case, the recovery support unit adjusts the operating time zone using the job congestion status. Specifically, when the job is congested and the job execution environment resource is insufficient, correction is performed so that the required execution time is lengthened in the job schedule.
And it repeats until it complete | finishes about all the related jobs.

  Next, the control unit 21 of the impact investigation system 20 executes output time prediction processing (step S2-5). Specifically, the recovery support unit of the control unit 21 specifies the end time (final recovery completion time) of the job that creates the file to be transferred to the user system S3.

  Next, the control part 21 of the influence investigation system 20 performs the determination process about whether it is in time for the time limit of an output stage (step S2-6). Specifically, the recovery support unit of the control unit 21 acquires the transfer time for this file from the transfer conditions recorded in the file transfer information storage unit 22. Then, the final recovery completion time is compared with the file transfer time.

When it is determined that the final recovery completion time is later than the file transfer time and is not in time for the output stage, the recovery support unit records an unusable flag for this recovery method candidate.
The above process is repeated for all recovery method candidates.
Next, the control part 21 of the influence investigation system 20 performs a navigation display process (step S2-7). Specifically, the recovery support unit of the control unit 21 outputs a navigation screen to the output unit 32. This navigation screen includes a final recovery completion time and an unusable flag for each recovery method candidate. When a plurality of failures occur at the same time, the job recovery method candidates are output in order from the job whose output time is close.

  Further, the recovery work start time may be set in consideration of the resource for recovery and the work situation of the person in charge. In this case, the influence investigation system 20 is connected to the resource status information of the downstream system and the work information of the person in charge related to the recovery. Then, the impact investigation system 20 acquires the resource status information of the downstream system and the work information of the person in charge related to the recovery from the resource management system. Next, the start time of the job in the job schedule is specified based on the available time of resources available for recovery and the attendance time of the person in charge, and the operation time zone of the job is calculated from this start time.

  In the above embodiment, the output process of the impact investigation sheet is executed (step S1-11). In this case, jobs and files in the affected area are output in a list format. The output format is not limited to the list format.

  For example, as shown in FIG. 6A, the tree display 600 may be used for output. Here, a tree in which jobs J10 to J17 executed until the output stage file is output is connected in a preceding / following relationship is generated and output to the output unit 32.

  In the tree display 600, a specific condition may be set to display a job that is affected by the condition and a job that is not affected by the condition.

The filtering process will be described with reference to FIG.
First, the control unit 21 of the impact investigation system 20 executes filtering condition input processing (step S3-1). Specifically, the output control unit 213 of the control unit 21 outputs a condition setting screen to the output unit 32. This condition setting screen is provided with a setting field for inputting the conditions of variables used in the job. As conditions, items and item values (upper limit value, lower limit value, range, etc.) and operation cycle (execution time) included in the file are used. And the output control part 213 acquires the conditions input into the condition setting screen.

  Next, the control part 21 of the influence investigation system 20 performs a filtering process (step S3-2). Specifically, the output control unit 213 of the control unit 21 specifies a job to be executed according to the condition in the influence range in the influence evaluation process (FIG. 3) based on the acquired condition.

  Next, the control part 21 of the influence investigation system 20 performs the output process of the adjusted influence range (step S3-3). Specifically, the output control unit 213 of the control unit 21 displays the affected job and the unaffected job in the tree display so that they can be identified.

  For example, as shown in FIG. 6C, it is assumed that the job J11 is affected when conditions are set in the jobs J11 and J12 subsequent to the job J10. Furthermore, it is assumed that the job J14 is affected when conditions are set in the jobs J14 and J15 subsequent to the job J13. In this case, in the tree display 610, the jobs J10, J11, J13, J14 that are affected by the condition setting and the jobs J12, J16, J17 that are not affected are identified and output. Further, the output control unit 213 may display the next working date (execution time) of each job in association with each affected job J10, J11, J13, J14 in the tree display.

In the above embodiment, the output process of the impact investigation sheet is executed (step S1-11). Here, the impact in the user department may be predicted and output.
In this case, as shown in FIG. 7, the impact investigation system 20 is provided with an inquiry record storage unit, an access record storage unit, and an influence information storage unit. Here, the inquiry record storage unit and the access record storage unit function as a contact history storage unit that records a contact history from the user department.

  Inquiry record information is recorded in the inquiry record storage unit. This inquiry record information is recorded when an inquiry is received from the user department. The inquiry result information includes information on the inquiry date, inquiry department, file ID, item ID, and inquiry contents. The inquiry date is the date and time when the inquiry was received. The inquiry department is an identifier for identifying the department of the user department that made the inquiry. The file ID and item ID are identifiers for specifying the file or item to be queried. The inquiry content is a question content about a file or an item.

  Access record information is recorded in the access record storage unit. This access record information is recorded when there is an access from the user system S3. This access record information includes information on access date / time, access department, file ID, and item ID. The access date and time is the date and time of access. The access department is an identifier for identifying the department of the user department that has made access. The file ID and item ID are identifiers for specifying a file or item to be accessed.

  In the impact information storage unit, impact assessment information obtained by evaluating the impact level of each file or item is recorded. This influence evaluation information is recorded when impact evaluation described later is performed. This impact evaluation information includes information on file ID, item ID, time / time zone, impact level, and affected department. The file ID and item ID are identifiers for specifying the file and item. The time / time zone is a time (calendar day) / time zone in which a failure may occur in the file or item. The degree of influence is an index representing the magnitude of impact when a failure occurs in a file or item. The affected department is an identifier for identifying the department of the user department that is affected when a failure occurs in a file or item.

  And the control part 21 of the impact investigation system 20 performs an impact evaluation process (step S4-1). Specifically, the analysis unit 212 of the control unit 21 performs matrix evaluation using the “inquiry” situation and the “access” situation. For example, for the files and items recorded in the inquiry record storage unit and the access record storage unit, the inquiry frequency and the access frequency are calculated for each period and time zone. Then, for each file or item, the weighted influence is calculated by using the inquiry frequency and the access frequency as variables for each period / time zone. Here, the higher the inquiry frequency and the higher the access frequency, the higher the degree of influence is calculated. Then, the analysis unit 212 records the influence degree in the influence information storage unit in association with the file ID, the item ID, and the time / time zone. Further, the analysis unit 212 acquires the inquiry department and the access department that inquired and accessed during this time / time period from the inquiry result storage part and the access result storage part, and records them in the influence information storage part as an influence department.

Next, the control unit 21 of the influence investigation system 20 executes investigation target designation processing in the same manner as in step S1-1 (step S4-2).
And the control part 21 of the influence investigation system 20 performs the output process of an influence range (step S4-3). Specifically, the analysis unit 212 of the control unit 21 specifies the impact evaluation information including the file ID and item ID acquired as the investigation target and the output time of the output file in the time / time zone. Then, the analysis unit 212 outputs the degree of influence recorded in the influence information storage unit to the output unit 32. Thereby, each job and item can be evaluated based on the evaluation of the item in the output stage that affects the business of the user department. Also in this case, the item ID may be changed to a name using the user dictionary storage unit 26.

  In the above embodiment, the control unit 21 of the influence investigation system 20 executes investigation target designation processing (step S1-1). Here, a file or item is specified as an investigation target. The survey target is not limited to files and items. For example, a program may be designated as an investigation target. In this case, the processing after step S1-4 is executed using the program ID designated as the survey target. Further, a job may be designated as an investigation target. In this case, the job net information storage unit 23 acquires the program ID from the parameter data area using the definition information management table 230 in which the designated job identifier is recorded in the unit definition data area. And using this program ID, the process after step S1-4 is performed. For example, it is possible to specify the program or job to be renewed and predict the influence range based on the file or item output from this program or job.

  In the above embodiment, the control unit 21 of the impact research system 20 executes the impact research sheet output process (step S1-11). In this case, the analysis unit 212 may rearrange the programs in the earliest order in the next working day and output the program information column, the input information column, and the output information column.

  DESCRIPTION OF SYMBOLS S1 ... Counterpart system, S2 ... Internal management system, S3 ... User system, 11 ... File transfer management system, 12 ... Job operation management system, 13 ... Data integration support system, 20 ... Impact investigation system, 21 ... Control part, 211 ... Information acquisition unit, 212 ... Analysis unit, 213 ... Output control unit, 22 ... File transfer information storage unit, 23 ... Job net information storage unit, 24 ... Job report information storage unit, 240 ... Job report, 25 ... Parameter information Storage unit, 250... Parameter file, 26... User dictionary storage unit, 27.

Claims (12)

In a job execution environment in which a job is executed using a file, an impact investigation system including a control unit that evaluates an influence of an item in the file on an output file,
The control unit is
Obtain information about the files and items to be investigated,
In the parameter file in which the file identification information to be input to the program used for the job is recorded, all the programs and output files that use the file to be investigated are identified,
Using the job report that records the output information including the item information output in the identified program and the input information including the item information for deriving the output information, the input information is not recorded and the survey target From the output information in which the items are recorded, the input information for deriving the output information is sequentially searched, the output items in the output stage are specified, and the output range including the output file and the specified information of the output items is output. An impact investigation system characterized by that.   The control unit specifies job operation time using job definition information including operation time of a job using the program, and outputs the operation time in association with the output file of the influence range. The impact investigation system according to claim 1. The control unit is
Identify the operation time of a job that uses a program that outputs all output files included in the affected range,
3. The influence investigation system according to claim 2, wherein the earliest time among all the specified operation times is output. The control unit is
Obtain information about the program under investigation,
The influence investigation system according to any one of claims 1 to 3, wherein an influence range is specified and output using a job report of the program. The control unit is
Based on the job execution results using the program included in the influence range, the time required for job execution is calculated,
5. The output time of the output file is predicted by calculating the execution time of a job that uses the program included in the influence range by using the required time. The impact investigation system described in The control unit is
In the job item that uses the program included in the influence range, the filtering condition is acquired,
6. The influence investigation system according to any one of claims 1 to 5, wherein the influence range is adjusted and output based on the filtering condition. For the output file, it has a contact history storage unit that records the contact history from the user,
The control unit is
Calculate the contact frequency based on the contact history recorded in the contact history storage unit, calculate the output file access status by the contact frequency,
7. The influence investigation according to claim 1, wherein an influence degree of a job that uses a program that is included in the influence range and is executed to output the output file is output. system. The control unit is
Identify the contact time when contact was made in the contact history recorded in the contact history storage unit, and calculate the access status of each output file based on the contact time,
8. The influence investigation system according to claim 7, wherein an influence degree corresponding to the contact time corresponding to the output time of the influence range is output.   8. The control unit according to claim 7, wherein the control unit specifies a user who has made contact in the contact history using the contact history storage unit, and calculates an access status of each output file to the user. 8. The impact investigation system according to 8. A user dictionary storage unit that records the item name used by the user for each item;
The control unit is
The item included in the influence range is specified by using the user dictionary storage unit, the item name used by the user is specified, and the item included in the influence range is output in association with the item name. The influence investigation system as described in any one of 1-9. In a job execution environment in which a job is executed using a file, a method for conducting an impact investigation using an impact investigation system including a control unit that evaluates an influence of items in the file on an output file,
The control unit is
Obtain information about the files and items to be investigated,
In the parameter file in which the file identification information to be input to the program used for the job is recorded, all the programs and output files that use the file to be investigated are identified,
Using the job report that records the output information including the item information output in the identified program and the input information including the item information for deriving the output information, the input information is not recorded and the survey target From the output information in which the items are recorded, the input information for deriving the output information is sequentially searched, the output items in the output stage are specified, and the output range including the output file and the specified information of the output items is output. The impact investigation method characterized by this. In a job execution environment for executing a job using a file, a program for conducting an impact investigation using an impact investigation system including a control unit that evaluates an influence of an item in the file on an output file,
The control unit
Obtain information about the files and items to be investigated,
In the parameter file in which the file identification information to be input to the program used for the job is recorded, all the programs and output files that use the file to be investigated are identified,
Using the job report that records the output information including the item information output in the identified program and the input information including the item information for deriving the output information, the input information is not recorded and the survey target From the output information in which the items are recorded, the input information for deriving the output information is sequentially searched, the output items in the output stage are specified, and the output range including the output file and the specified information of the output items is output. An impact investigation program characterized by functioning as a means.

Images