JP4104600B2 - Line management system, line management method, line management program - Google Patents

Description

  The present invention relates to a line management system, a method, and a program for a communication line connected to a host computer, and in particular, a line management system and a line management for determining whether or not a terminal system on a communication line connection can be added and whether or not a line quality investigation can be performed. The present invention relates to a method and a line management program.

As a line management system according to the prior art, for example, as detailed in the following Patent Document 1, a network that proposes a change in operation method and an increase in equipment based on the configuration and operation status of a network device connected to the network A management system has been proposed. This relates to a system that can automatically design a network operation method for satisfying the quality required by a user or a necessary equipment expansion plan and set the design result directly on the network.
Japanese Patent Application Laid-Open No. 11-68750

  The above-described line management system according to the prior art proposes an optimal network path for connecting apparatuses based on the line utilization rate when adding apparatuses to an existing network. In this prior art, the network route for minimizing the cost of adding the device calculated by the combination is not necessarily optimal when viewed from the whole network. Therefore, a processing program or system for the purpose of optimizing the network route Therefore, there is a problem that it does not have a function for proposing an extension of a terminal system connected to each communication line.

In a conventional line management system, when adding a terminal system on a communication line connected to a host computer in an existing configuration, necessary information is collected, including threshold values used as criteria and terminal system expansion schedule. In addition, there was no function for determining whether or not to add a terminal system on a communication line.
Similarly, information on the line quality, including the value used as a criterion, has not been collected, and there has been no function for grasping the quality state of the communication line and determining whether or not to conduct a line quality survey.

An object of the present invention is to eliminate the above-mentioned problems caused by the prior art, and to provide a line management system, method and program for automatically determining whether or not a terminal system can be added on a communication line.
Another object of the present invention is to provide a line management system, method and program for automatically determining a line on which a line quality check should be performed.

  In order to achieve the above object, the present invention adds the utilization rate of the line connected to the host computer and the planned expansion of the terminal system connected to the line to the criterion of determination, and whether or not the terminal system connected to the host computer can be added. For each communication line, based on the line error information of the host computer, grasps the line quality status, and automatically determines the communication line that requires line quality investigation from these results and the preset line quality. Judgment is the main feature. According to the present invention, in the determination, an investigation target period is input, and the total number of line errors occurring within the period is calculated. When the accumulated line error count exceeds a preset line error count, it is determined that a line quality check is necessary, and the target communication line and the accumulated line error are output.

More specifically, the present invention relates to a communication line management system connected to a host computer.
A configuration management database that stores a line utilization threshold value that represents the line speed of the communication line connected to the host computer and the maximum value of the communication line utilization rate that is arbitrarily determined;
A terminal system information database for storing communication data amount per unit time per terminal of a terminal system connected to a communication line connected to a host computer;
A line log information database that stores the cumulative amount of data passing within a specified time for each line of the communication line connected to the host computer;
A line traffic database that stores line utilization information for each line;
With a line management system controller that performs calculations and processing,
The line management system control unit
Reading the cumulative passage data amount stored in the line log information database and the line speed stored in the configuration management database, calculating the passage data amount within a specified time from the cumulative passage data amount and the line speed Calculate the amount of data that can be transmitted within the specified time from
A line traffic database creating means for calculating a line utilization rate by dividing the calculated passing data amount by a transmittable data amount, and writing the calculated line utilization rate in the line traffic database for each line;
The communication data amount per terminal stored in the terminal system information database, the line utilization threshold value and the line speed stored in the configuration management database, and the line traffic database. Read the line utilization rate,
By comparing the maximum value of the line usage rate and the threshold value of the line usage rate, it is determined whether or not the terminal system can be expanded on the communication line,
And / or
By dividing the amount of communication data per unit time per terminal by the amount of data that can be transmitted, an increase value of the line utilization rate is obtained, and the maximum value of the line utilization rate is subtracted from the line utilization rate threshold value. Calculate the number of terminals that can be added by obtaining the margin value of the utilization rate and dividing the increased value of the line utilization rate by the margin value of the line utilization rate,
A first feature is that it has terminal extension possible line determination means for outputting whether or not the terminal can be added and / or the number of terminals that can be added to an optional output means.

According to the present invention, in the communication line management system according to the first feature, the line log information database includes a total number of retries within a specified time for each line and a total number of timeout occurrences within a specified time. , Stores the total number of errors received within the specified time,
The line quality database stores the number of retries within the specified time, the number of timeout occurrences within the specified time, and the number of errors received within the specified time for each line.
The line management system control unit
By the setting means, the upper limit of the investigation period, the number of retries that can be accepted in terms of the quality of the communication line, the number of timeout occurrences, and the number of error receptions is preset,
A line quality alert for calculating the total number of retries, timeout occurrences and error receptions stored in the line log information database as the cumulative number of retries, timeout occurrences and error receptions within the preset investigation period Means,
The upper limit of the preset retry count, timeout occurrence count and error reception count is compared with the total of retry count, timeout occurrence count and error reception count within the survey period calculated by the line quality database, A second feature is that it has a line quality alert means for determining a line exceeding the upper limit value as a line requiring a line quality investigation.

The present invention also provides a method for managing a communication line connected to a host computer.
A configuration management database that stores a line utilization threshold value that represents the line speed of the communication line connected to the host computer and the maximum value of the communication line utilization rate that is arbitrarily determined;
A terminal system information database for storing communication data amount per unit time per terminal of a terminal system connected to a communication line connected to a host computer;
A line log information database that stores the cumulative amount of data passing within a specified time for each line of the communication line connected to the host computer;
A line traffic database that stores line utilization information for each line;
With a line management system controller that performs calculations and processing,
The line management system control unit
Reading the cumulative passage data amount stored in the line log information database and the line speed stored in the configuration management database, calculating the passage data amount within a specified time from the cumulative passage data amount and the line speed Calculate the amount of data that can be transmitted within the specified time from
A line traffic database creation procedure for calculating a line utilization rate by dividing the calculated passing data amount by a transmittable data amount, and writing the calculated line utilization rate for each line in the line traffic database;
The communication data amount per terminal stored in the terminal system information database, the line utilization threshold value and the line speed stored in the configuration management database, and the line traffic database. Read the line utilization rate,
By comparing the maximum value of the line usage rate and the threshold value of the line usage rate, it is determined whether or not the terminal system can be expanded on the communication line,
And / or
By dividing the amount of communication data per unit time per terminal by the amount of data that can be transmitted, an increase value of the line utilization rate is obtained, and the maximum value of the line utilization rate is subtracted from the line utilization rate threshold value. Calculate the number of terminals that can be added by obtaining the margin value of the utilization rate and dividing the increased value of the line utilization rate by the margin value of the line utilization rate,
A third feature is that it has a terminal extension possible line determination procedure for outputting whether or not the terminal can be added and / or the number of terminals that can be added to an arbitrary output means.

Furthermore, the present invention provides the communication line management method according to the third feature, wherein the line log information database includes a total number of retries within a specified time for each line, a total number of timeout occurrences within a specified time. , Stores the total number of errors received within the specified time,
The line quality database stores the number of retries within the specified time, the number of timeout occurrences within the specified time, and the number of errors received within the specified time for each line.
The line management system control unit
A procedure in which an upper limit value of the number of retries and the number of timeout occurrences and the number of error receptions that can be accepted in the quality of the communication line is preset by the setting means,
A line quality alert for calculating the total number of retries, timeout occurrences and error receptions stored in the line log information database as the cumulative number of retries, timeout occurrences and error receptions within the preset investigation period Procedure and
The upper limit of the preset retry count, timeout occurrence count and error reception count is compared with the total of retry count, timeout occurrence count and error reception count within the survey period calculated by the line quality database, A fourth feature is that it has a line quality alert procedure for determining a line exceeding the upper limit value as a line requiring a line quality investigation.

Furthermore, the present invention provides a communication line management program connected to a host computer.
A configuration management database that stores a line utilization threshold value that represents the line speed of the communication line connected to the host computer and the maximum value of the communication line utilization rate that is arbitrarily determined;
A terminal system information database for storing communication data amount per unit time per terminal of a terminal system connected to a communication line connected to a host computer;
A line log information database that stores the cumulative amount of data passing within a specified time for each line of the communication line connected to the host computer;
A line traffic database that stores line utilization information for each line;
In a system including a line management system control unit that performs calculation and processing,
In the line management system control unit,
Reading the cumulative passage data amount stored in the line log information database and the line speed stored in the configuration management database, calculating the passage data amount within a specified time from the cumulative passage data amount and the line speed Calculate the amount of data that can be transmitted within the specified time from
A line traffic database creation procedure for calculating a line utilization rate by dividing the calculated passing data amount by a transmittable data amount, and writing the calculated line utilization rate for each line in the line traffic database;
The communication data amount per terminal stored in the terminal system information database, the line utilization threshold value and the line speed stored in the configuration management database, and the line traffic database. Read the line utilization rate,
By comparing the maximum value of the line utilization rate and the line utilization threshold value, it is determined whether or not the terminal system can be expanded on the communication line,
And / or
By dividing the amount of communication data per unit time per terminal by the amount of data that can be transmitted, an increase value of the line utilization rate is obtained, and the maximum value of the line utilization rate is subtracted from the line utilization rate threshold value. Calculate the number of terminals that can be added by obtaining the margin value of the utilization rate and dividing the increased value of the line utilization rate by the margin value of the line utilization rate,
A fifth feature is that a terminal extension possible line determination procedure for outputting whether or not the number of terminals can be added and / or the number of terminals that can be added to an arbitrary output means is executed.

Furthermore, the present invention provides the communication line management program according to the fifth feature, wherein the line log information database includes a total number of retries within a specified time for each line and a total number of timeout occurrences within a specified time. , Stores the total number of errors received within the specified time,
The line quality database stores the number of retries within the specified time, the number of timeout occurrences within the specified time, and the number of errors received within the specified time for each line.
In the line management system control unit,
A setting procedure for presetting the upper limit of the number of retries, timeout occurrences, and error receptions that are acceptable in terms of the quality of the communication line, the investigation period,
A line quality alert for calculating the total number of retries, timeout occurrences and error receptions stored in the line log information database as the cumulative number of retries, timeout occurrences and error receptions within the preset investigation period Procedure and
The upper limit of the preset retry count, timeout occurrence count and error reception count is compared with the total of retry count, timeout occurrence count and error reception count within the survey period calculated by the line quality database, A sixth feature is that a line quality alert procedure for determining a line exceeding the upper limit value as a line requiring a line quality investigation is executed.

  According to the present invention, when a terminal system is added on a communication line connected to a host computer, a threshold value as a criterion, a terminal system addition schedule, information on quality for each line, information on line configuration, line Information regarding the amount of data passing through each of the data is collected, past line utilization data is calculated, and it is possible to select a communication line that can automatically add terminals from these information.

  In addition, since appropriate processing and calculation is performed based on information on the preset line quality and current line error information, it is possible to automatically select communication lines that require line quality investigation. Become.

  Hereinafter, an embodiment of a line management system, method, and program according to the present invention will be described in detail with reference to the drawings. FIG. 1 is an overall view of hardware and software in the line management system of this embodiment. FIG. 2 shows the operation of the “line traffic DB creation program” in the line management system control unit 15 of the line management system 10 according to this embodiment. FIG. 3 is a flowchart showing the operation of the “line quality DB creation program” of the line management system control unit 15, and FIGS. 4 to 7 are diagrams of the “terminal expansion possible line determination program” of the line management system control unit 15. FIG. 8 is a flowchart showing the operation of the “line quality alert program” of the line management system control unit 15. FIG. 9 is a diagram for explaining the “line log information DB” according to this embodiment. FIG. 11 is a diagram for explaining the “configuration management DB” according to the present embodiment, and FIG. FIG. 12 is a diagram for explaining the “line quality inspection period parameter” according to the present embodiment, and FIG. 12 is a diagram for explaining the “line quality report output condition parameter” according to FIG. FIG. 14 is a diagram for explaining the “line traffic DB” according to the present embodiment, FIG. 15 is a diagram for explaining the “line quality DB” according to the present embodiment, and FIG. FIG. 17 is a diagram for explaining the “line quality alert report” according to the present embodiment.

<Description of configuration>
In the following, with respect to the line management system 10 according to one embodiment of the present embodiment, an overall diagram of hardware and software in the line management system will be described with reference to FIG. Needless to say, the embodiment is not limited to this.
The line management system 10 is installed in a server 43 connected to the host computer 40. A line 45 to be managed is connected to the host computer 40 via a communication line connection device 41. The communication line 45 may be connected to another host computer 42 or may be connected to a user terminal 46.

  The line management system includes an input / output terminal 44 for the line management system 10, a configuration management database 22 for storing information related to the system configuration and specifications of the host computer 40 (hereinafter referred to as DB), and communication between the host computers. Terminal system information DB 23 for storing information such as the specifications of the terminal system and host computer connected to the line and the planned expansion of the terminal system, and the operation of the communication line connected to the host computer automatically collected from the host computer Line log information DB 24 for storing information, line traffic DB 30 for storing information such as log acquisition date and time and line utilization rate for each line, and information such as log acquisition date and time and error occurrence information for each line Line quality DB31 to calculate and process Having a line management system control unit 15 that performs.

  The line management system control unit 15 reads the data from the line log information DB 24 to create the line traffic DB 30 and the line quality DB 31 to read the data from the line log information DB 24 and create the line quality DB 31. Terminals on the communication line are created based on the creation program 12 and the terminal system information schedule of the terminal system information DB 23, the line specifications of the configuration management DB 22, information on the line utilization threshold, and the line utilization of the line traffic DB 30. It is determined whether or not the system can be expanded, and the terminal expandable line determination program 13 that outputs the expandable line report 32, the investigation period specified by the line quality investigation period parameter 20, and the line quality report output condition Line quality based on the minimum number of errors specified in parameter 21 From the error occurrence information stored in the B31, having determined channel quality alert program 14 line quality research is needed line.

  The line quality inspection period parameter 20 and the line quality report output condition parameter 21 are input from an input / output terminal 44 connected to the server 43, and the input / output terminal 44 having this function can also be called parameter setting means.

<Description of data structure>
Hereinafter, an embodiment of each database and an embodiment of the data structure of input / output information will be described.
As shown in FIG. 9A, the line log information DB 24 includes a “line name” indicating a communication line on the log information file, a “date” indicating an output date of the log information, and an output time of the log information. "Time", "Cumulative data amount" indicating the amount of data passed at that time, "Total number of retries" indicating the number of retries at that time, and "Total time-out" indicating the number of timeout occurrences at that time Each item includes “number of occurrences” and “cumulative error reception number” indicating the number of error receptions at that time. Specific numerical values of each item are, for example, “line name” “ LH1CK01 ”, date“ 040610 ”,“ time ”“ 1040 ”,“ cumulative data amount ”“ 172,965 ”,“ cumulative retry count ”“ 10 ”,“ cumulative timeout occurrence count ”“ 0 ”, `` Cum “Total error reception count” is “5”.
Information of each item in the line log information DB 24 is automatically collected from the host computer and stored in the database.

  As shown in FIG. 10A, the configuration management DB 22 displays a “line name” indicating a line name defined by the host computer and a “line connection apparatus name” indicating the name of the line connection apparatus to which the communication line is connected. "," Line connection system "indicating a line connection system (but there are multiple systems)," line speed "indicating the transfer speed of the communication line, and" line utilization rate "which means the maximum value of the communication line utilization rate As shown in FIG. 10B, for example, “line name” is “LHC1K01”, “line connection device name” is “CCP01”, “line”. The “connection system” is “A”, the “line speed” is “384 kbps”, and the “line utilization threshold” is “50%”. Information on each item in the configuration management DB 22 is input by the operator through the input / output terminal 44.

  As shown in FIG. 11A, the terminal system information DB 23 includes “system name” indicating the name of the terminal system connected to the communication line and “connection” indicating the total number of terminals connected to the communication line. "Number of terminals", "Data volume" indicating the amount of data per unit time per terminal, "Presence / absence of terminal expansion" indicating whether the terminal system is scheduled to be expanded, and "Terminal expansion" indicating the planned expansion date of the terminal system “Scheduled Date” and “Terminal Expansion Number” indicating the number of terminals planned to be added to the terminal system, and the specific numerical value of each item is, for example, “System Name” is “HUB System” and “Number of Connected Terminals”. “500 units”, “data amount” is “10 MB”, “terminal expansion plan presence / absence” is “present”, “terminal expansion scheduled date” is “04.10.11”, and “terminal expansion unit number” is “10 units”. And "system name "CB system", "Number of connected terminals" is "60", "Data amount" is "5MB", and "Terminal expansion plan" is "None". “△” and “terminal expansion number” are also “△”. Information of each item in the terminal system information DB 23 is input by the operator through the input / output terminal 44.

  As shown in FIG. 12A, the line quality investigation period parameter 20 designates an “investigation start date” that designates an investigation start date, an “investigation start time” that designates an investigation start time, and an investigation end date. Each item includes an “investigation end date” and an “investigation end time” for designating the time of the survey end date. Specific numerical values of the items are, for example, “investigation start date” as shown in FIG. Is “040401”, “Survey start time” is “0000”, “Survey end date” is “040630”, and “Survey end time” is “2359”.

  As shown in FIG. 13A, the line quality report output condition parameter 21 includes a “retry number” that specifies the upper limit of the number of retries for outputting a line quality alert report, and the number of timeout occurrences for outputting the line quality alert report. “Time-out occurrence count” for designating the upper limit value of the message, and “Error reception count” for designating the upper limit value of the error reception count for outputting the line quality alert report. The specific numerical values of each item are shown in FIG. As shown in b), the “retry count” is “100”, the “timeout occurrence count” is “150”, and the “error reception count” is “100”.

  As shown in FIG. 14A, the line traffic DB 30 stores the “line name” indicating the line name defined on the host, the “date” indicating the date of the line log information, and the time of the line log information. "Time" to indicate, "data amount" indicating the amount of data passing from the previous time, and "line usage rate" indicating the line usage rate calculated from the line speed and the amount of passing data. As shown in FIG. 14B, the specific numerical values are as follows: “Line name” is “LAB1K01”, “Date” is “040610”, “Time” is “1040”, “Data amount” is “2,290, 069 "and" line utilization "are" 7.77% ".

  As shown in FIG. 15A, the line quality DB 31 stores the “line name” indicating the line name defined on the host, the “date” indicating the date of the line log information, and the time of the line log information. "Time" to indicate, "Retry count" to indicate the number of retries from the previous time, "Time-out occurrence" to indicate the number of timeout occurrences from the previous time, and "Error reception count" to indicate the number of error receptions from the previous time As shown in FIG. 15B, the specific values of each item are “LAB1K01” for “Line name”, “040610” for “Date”, “1040” for “Time”, and “Retry”. “Number of times” is “0”, “Time-out occurrence number” is “0”, and “Error reception number” is “200”.

  As shown in FIG. 16A, the terminal expansion possible line report 32 includes “system name” indicating the name of the terminal system to be expanded, “number of additional terminals” indicating the number of terminals to be expanded, "Data amount" indicating the amount of data generated per unit time at the terminal, "Line name" indicating the line name defined on the host, and "Line" indicating the name of the line connection device to which the communication line is connected “Connection device name”, “Line connection system” indicating a line connection system (but there are multiple systems), “Line speed” indicating the transfer speed of the communication line, and “Maximum value of utilization rate of communication line” "Line usage rate threshold", "Maximum line usage rate" indicating the maximum historical line usage rate on the traffic DB, "Average line usage rate" indicating the average line usage rate on the traffic DB, and the terminal system When one unit is added "Increase value of line utilization" indicating the increase in line utilization rate, "Maximum line utilization rate when adding terminals" indicating the maximum line utilization rate when the number of terminal systems can be expanded, and the terminal system For the number of units that can be added, the "average line usage rate at the time of terminal expansion" indicating the average line usage rate at the time of expansion, "terminal expansion availability" indicating whether the terminal can be expanded, and adding terminals to the line In this case, the number of “expandable terminals” indicating the maximum number of terminals can be set, and the specific numerical value of each item is, for example, “system name” “ “New financial system”, “Number of extension terminals” is “10”, “Data amount” is “10 Mb / 10 min / unit”, “Line name” is “LAB1K01”, “Line connection device name” is “CCP01”, “Line connection system” is “A”, “Line speed” "384kbps", "Line utilization threshold" is "50%", "Maximum line utilization" is "30%", "Average line utilization" is "20%", "Increase in line utilization" "Value" is "4%", "Maximum line usage rate when adding terminals" is "50%", "Average line usage rate when adding terminals" is "40%", "Terminal availability" is "Yes" “Number of expandable terminals” is “5”.

  As shown in FIG. 17A, the line quality alert report 33 includes a “survey target period” indicating the range of the target date and time for outputting the alert report, and thresholds such as the number of retries, the number of times of timeout, and the number of error receptions. "Report output condition", "Line name" that indicates the name of the line that requires quality survey, "Retry count" that indicates the number of retries that occurred within the survey period, and the number of timeout occurrences that occurred within the survey period "Time-out occurrence count", "Error reception count" indicating the number of error receptions that occurred within the investigation period, and "Alert" indicating the warning status. As shown in FIG. 17B, the “survey period” is “YY.MM.DD HH.MM to YY.MM.DD HH.MM”, and the “report output condition” is “retry count> 1”. 00, number of times of occurrence of timeout> 150, number of times of receiving error> 100 ”,“ line name ”is“ LAB1K02 ”,“ number of retries ”is“ 200 ”,“ number of times of occurrence of timeout ”is“ 200 ”, and“ number of times of receiving error ”is“ In the case of “200”, since all the output conditions of the line quality report output parameter are satisfied, “alert” is “o” indicating that the line quality investigation is particularly necessary, “line name” is “LAB1K03”, “retry count” "150", "Timeout occurrence count" is "0", and "Error reception count" is "0", some of the output conditions of the line quality report output parameter are satisfied, so "alert" requires line quality investigation “Δ” indicating that

<Description of operation>
Next, each of the above-described programs included in the line management system control unit 15 of this embodiment will be described.
<Line traffic DB creation program 11>
FIG. 2 is a flowchart showing the processing procedure of the line traffic DB creation program 11.
As shown in FIG. 2, the processing procedure by the line traffic DB creation program 11 includes line name / date / time / total amount of data / total number of retries / total number of timeout occurrences / total number of errors received from the line log DB 24. Step 197 for reading data, whether or not all data has been read from the line log information DB 24, and if it is determined that all the data has been read, step 198 for ending the process, When it is determined that the input has not been made, step 199 for inputting the line speed data of the line from the configuration management DB 22, step 200 for calculating the data amount at the time, and the amount of data that can be transmitted on the line are calculated. Step 201 and calculating the line usage rate at the time A step 202, a step 203 of registering the line utilization rate calculated by the step 202 to the line traffic DB 30, and sequentially executes the processing returns to step 197 after executing the step 203.

  Since the step 200 indicates the accumulated data amount from a certain point in time in the line log information DB, the data amount at the time is changed from “the accumulated data amount at the time” to “the accumulated data amount at the previous time”. "Is subtracted.

The transmittable data amount in step 201 is a value indicating how much data amount can be transmitted per unit time, and is a value for converting “line speed (unit: bps = bit / sec)” into a byte value. The amount of data that can be transmitted at the time is calculated by dividing by 8 and multiplying this by the value “600 sec” to obtain a value of 600 sec per unit time. (Please check if this is OK)
The step 202 divides the data amount at the time obtained in the step 200 by the transmittable speed obtained in the step 201, and multiplies the value “100” to obtain the result in% units. The line usage rate is calculated.

  As described above, the line traffic DB creation program 11 according to the present embodiment inputs the line operation information and the line speed registered in the line log information DB 24 of this computer system, and calculates the data amount / transmittable data amount at the time. Then, based on these calculated values, the line utilization rate at the unit time is registered in the line traffic DB 30.

<Line quality DB creation program 12>
FIG. 3 is a flowchart showing the processing procedure of the line quality DB creation program 12.
As shown in FIG. 3, the processing procedure by the line quality DB creation program 12 includes line name / date / time / cumulative data amount / cumulative retry count / cumulative timeout occurrence count / cumulative error reception count from the line log information DB 24. In step 298 for reading data, whether or not all data has been read from the line log information DB 24 is determined, and if it is determined that all the data has been read, step 299 for ending the processing, When it is determined that the input has not been performed, step 300 for calculating the number of retries at the time, step 301 for calculating the number of times the timeout occurs at the time, and step for calculating the number of times the error has been received at the time. 302, line name / date / time, and step 300 to step. Step 303 for registering the number of retries at the time calculated in step 302 / the number of times the timeout occurred at the time / the number of error receptions at the time in the line quality DB 31 and the process of returning to step 298 after the execution of step 303 are sequentially executed. .

The cumulative retry count, cumulative timeout occurrence count, and cumulative error reception count in the line log information DB 24 indicate cumulative values from a certain point in time. Therefore, in step 300, the number of retries at the time is calculated by subtracting the number of retries at the previous time from the number of retries at the time.
In step 301, the number of time-out occurrences at the time is calculated by subtracting the time-out occurrence times at the previous time from the time-out occurrence times at the time.
In step 302, the number of error receptions at the time is calculated by subtracting the number of error receptions at the previous time from the number of error receptions at the time.

  As described above, the line quality DB creation program 12 calculates the number of retries at the time, the number of times the timeout occurred at the time, and the number of error receptions at the time from the data in the line log information DB 24 and outputs the calculated number to the line quality DB 31.

<Terminal extension available line determination program 13>
FIGS. 4 to 7 are flowcharts of the terminal expansion possible line determination program 13. Each step in this program will be described below.
[Step 398]: From the terminal system information DB 23, the “number of connected terminals”, “data amount”, “presence / absence of terminal expansion”, “scheduled terminal expansion date”, and “terminal expansion number” are read.
[Step 399]: It is determined whether the read data has been completed. If the read data has been completed, the configuration management DB is read in [Step 424]. If there is data, the determination in [Step 400] is performed. Do.

[Step 400]: The data read from the terminal system information DB 23 is checked to determine whether the “terminal expansion plan presence / absence” item is “present” or “no”. If it is “Yes”, the process proceeds to [Step 401], and if the item “Presence / absence of terminal expansion” is “None”, the process returns to [Step 398].
[Step 401]: The system name, the number of additional terminals, and the amount of data are acquired, and an expanded terminal system table creation process is performed.

[Step 424]: Read the line name, line connection device name, line connection system, line speed, and line utilization threshold from the configuration management DB 22.
[Step 425]: It is determined whether or not the reading of data from the configuration management DB 22 has been completed.
If data reading has been completed, [Step 405] is performed, and if data reading has not been completed, [Step 402] is performed.
[Step 402]: Information necessary for output of the terminal expansion possible line report from the configuration management DB 22 and information necessary for determining whether or not terminal expansion is possible (line name, line connection device name, line connection system, line speed, line usage rate threshold) Value) is acquired, and a configuration management table creation process is performed.

[Step 403]: The transmittable data amount is calculated from the line speed acquired in the configuration management table creation process 402 by the following formula.
Amount of data that can be transmitted (byte / 10 minutes) = (line speed ÷ 8) × 600
The transmittable data amount indicates how much data amount can be transmitted per unit time, and is used in the subsequent [Step 404].

[Step 404]: Based on the value obtained in the transmittable data amount calculation processing 403 and the data amount acquired in the additional terminal system table creation acquisition processing 401, the increase value of the line utilization rate at the time of adding one terminal is as follows. And return to [Step 424]. The increase value of the line utilization rate indicates how much the line utilization rate increases when one terminal system is added to the communication line.
Increase in line utilization rate = amount of data ÷ amount of data that can be transmitted

Next, FIG. 5 will be described.
[Step 405]: [Step 425] It is determined whether or not reading of data from the configuration management DB 22 has been completed. If the reading of data has been completed, the counter 1, counter 2, Counter setting processing for substituting 0 (zero) for the maximum line utilization rate is performed.
Counter 1 and counter 2 are counters for calculating an average line utilization rate. The counter 1 is a counter for adding the total value of the line usage rates, and the counter 2 is a counter for adding the number of data of the input line usage rates.
[Step 426]: The line name, date, time, data amount, and line utilization rate are read from the line traffic DB 30.

[Step 427]: It is determined whether or not reading of data from the line traffic DB 30 is completed, and if the reading of data is completed, the line utilization rate margin value calculation process of FIG. 6 is performed [Step 415]. If data reading is not completed, the subsequent [Step 406] determination is performed.

[Step 406]: The line name input last time is compared with the line name input this time. If the line names are not the same, [Step 412] is executed. If the line names are the same, [Step 407] ]I do.
[Step 412]: The average line usage rate is calculated. The average line usage rate is calculated using the following formula.
Average line usage rate = Counter 1 / Counter 2
The counter 1 is the total value of the line utilization rate for each line obtained in [Step 410], and is the number of data obtained in [Step 411].

[Step 413] A table setting process is performed for the line name, maximum line utilization rate, and average line utilization rate.
[Step 414] The counter 1, the counter 2, and the maximum line utilization rate are set to 0 (zero). Then, the circuit traffic DB 30 is read [step 426].
[Step 407]: The line name input last time in [Step 406] is compared with the line name input this time. If the line names are the same, the maximum line utilization rate and the current input are input in [Step 407]. When the line utilization rate input this time is larger, [Step 408] is performed. When the line utilization rate input this time is not larger, the maximum line utilization rate setting process is performed [Step 408]. The subsequent determination of [Step 409] is performed.
[Step 408]: The currently used line utilization rate is set as the maximum line utilization rate.

[Step 409]: It is determined whether or not the time of the line traffic DB 30 is between 8:00 and 17:00.
The calculation of the average line usage rate in [Step 412] is performed for the line usage rate from 8:00 to 17:00 in the line traffic DB 30. Therefore, when the time of the line traffic DB 30 is not between 8:00 and 17:00, the process returns to [Step 426], and when it is between 8:00 and 17:00, [Step 410] is performed.
However, the limitation of the use data based on this time is performed on the assumption that the range of the center of the operation time is between 8:00 and 17:00, which is the normal business hours. Therefore, when the center of the operation time is in another time zone, the determination in another time zone may be performed.

[Step 410]: The line utilization rate is added to the counter 1 and the result is substituted into the counter 1 for line utilization rate addition processing.
[Step 411]: 1 is added to the counter 2 and the result is added to the counter 2. The line usage rate data number addition process is performed, and the line traffic DB 30 is read. The process returns to [Step 426].

Next, FIG. 6 will be described.
[Step 415]: When it is determined in [Step 427] that the reading of data from the line traffic DB 30 has been completed, the following line utilization rate margin value calculation processing is performed.
The margin value of the line usage rate is based on the line usage rate threshold acquired in the configuration management table creation process [Step 402] and the maximum line usage rate acquired in the line usage rate table setting process [Step 413]. Is calculated.
Specifically, the margin value of the line utilization rate is a difference between the line utilization rate threshold value set in the configuration management DB 22 and the maximum line utilization rate, and serves as determination data on whether or not a terminal can be added. The larger the margin value of the line utilization rate, the larger the number of terminal systems that can be added on the communication line.

In this example, the reason for calculating the margin value of the line utilization rate based on the maximum line utilization rate is that each communication line needs to be able to withstand peak usage, and it can be expanded based on the average line utilization rate. This is because if the number of possible terminals is calculated, the line utilization rate may exceed the capacity of each line when the terminal system is expanded. The calculation formula is as follows.
Line utilization margin = line utilization threshold-maximum line utilization

[Step 416]: It is determined whether or not the margin value of the line utilization rate exceeds 0 (zero). If the margin value of the line utilization rate is 0 (zero) or less, [Step 418] is performed to obtain the line utilization rate. If the margin value exceeds 0 (zero), [Step 417] is performed.
[Step 417]: A process of calculating an increase value of the line utilization rate when one terminal is added is performed. A process of calculating an increase value of the line utilization rate and a margin value of the line utilization ratio calculated in [Step 404] is performed [Step 415]. Calculate the number of terminals that can be added to the terminal system based on the margin value of the line usage rate calculated in step 1. The number of terminals that can be added is obtained as an integer, and the numbers after the decimal point are rounded down. The calculation formula is as follows.
Number of terminals that can be added = Increased line usage rate ÷ Margin of line usage rate

Thereafter, a maximum line utilization rate calculation process at the time of adding terminals is performed [Step 419].
[Step 418]: 0 (zero) is set to the number of terminals that can be added. If the margin value of the line utilization rate is less than 0 (zero), it indicates that the maximum line utilization rate exceeds the line utilization rate threshold value, and terminal expansion is not possible. Thereafter, a maximum line utilization rate calculation process at the time of adding terminals is performed [Step 419].

[Step 419]: The maximum line utilization rate when the number of terminals is increased is calculated.
The maximum line usage rate at the time of terminal addition is calculated by calculating the maximum line usage rate set at [Step 413] and the line usage rate increase value at the time of adding one terminal [Step 404]. ] Is calculated based on the increase in the line usage rate calculated in step 2) and the number of terminals that can be added. The maximum line usage rate when this terminal is added indicates how much the maximum line usage rate will be when the number of terminal systems that can be added is added. The calculation formula is as follows.
Maximum line usage rate when adding terminals = Maximum line usage rate +
(Increase in line usage rate x number of terminals that can be added)

[Step 420]: The average line utilization rate at the time of adding terminals is calculated.
The average line usage rate at the time of adding a terminal is calculated by calculating the average line usage rate set in [Step 413] performing the line usage rate table setting process and the line usage rate increasing value at the time of adding one terminal [Step 413]. 404] is calculated on the basis of the increase value of the line utilization rate. Shows how much the average line usage rate is when the number of terminal systems is increased. The calculation formula is as follows.
Average line usage rate when adding terminals = Average line usage rate +
(Increase in line usage rate x number of terminals that can be added)
[Step 428]: The additional terminal system table creation acquisition process is performed in the output area. The system name, the number of additional terminals, and the data amount acquired in [Step 401] are set.

Next, FIG. 7 will be described.
[Step 421]: It is determined whether or not the number of expandable terminals obtained in [Step 417] is one or more. If the number of expandable terminals is one or more, [Step 422] is performed and one is set. If it is less, [Step 423] is performed.
[Step 422]: A “permitted” mark and the number of terminals that can be added are set in the terminal extension availability column in the output area.
[Step 423]: The “impossible” mark is set in the terminal extension availability column in the output area.

[Step 429]: The display item of the terminal expansion possible line report is set in the output area.
The items to be set are as follows.
・ "Line name"
・ "Line connection device name"
・ "Line connection system"
・ "Line speed"
・ "Line usage threshold"
・ Maximum line usage rate
・ "Average line usage rate"
・ "Increased line utilization"
・ "Maximum line usage rate when adding terminals"
・ "Peak average line usage rate when adding terminals"

[Step 430]: The terminal expansion possible line report 32 is output.
[Step 431]: It is determined whether or not the data read from all DBs stored in the memory and the data calculated from them have been read for all communication lines. If the data input is completed, the process is terminated. If the data input for all communication lines is not completed, the process returns to the line utilization rate margin value calculation process of [Step 415] in FIG.

As described above, the terminal expandable line determination program 13 outputs the terminal expandable line report 32 from the data in the terminal system information DB 23, the data in the configuration management DB 22, and the data in the line traffic DB 30.
The operator can select a communication line capable of adding a terminal by viewing the terminal expandable line report 32.

<Line quality alert program 14>
FIG. 8 is a flowchart of the line quality alert program 14, and each step in this program will be described below.
[Step 496]: The line quality survey period parameter 20 is input, and the survey target period is set.
[Step 497]: The line quality report output condition parameter 21 is input, and the report output condition is set. This report output condition setting is to set an upper limit value of the total number of retries, timeout occurrences, and error receptions that occurred within the investigation period, which is acceptable in terms of communication line quality.

[Step 498]: Read the line name, date and time, number of retries, number of timeout occurrences and number of error receptions from the line quality DB 31.
[Step 499]: It is determined whether or not the data reading from the line quality DB 31 is completed. When it is determined that the data reading is completed, [Step 506] is executed and the data reading is not completed. If it is determined, [Step 500] is determined.
[Step 500]: If the date and time in the line quality DB 31 are within the range specified in the line quality inspection period parameter 20, the process is performed, and [Step 501] is performed. Returning to [Step 498], line name / date / time / number of retries / number of times of timeout / number of errors received in the line quality DB 31 are read.

[Step 501]: The total number of retries, the total number of timeout occurrences, and the number of error receptions are calculated as follows.
(1) The total number of retries is calculated using the following formula. The total number of retries is calculated by adding the number of retries in the line quality DB 31 for each identical line name.
Total number of retries = total number of retries + number of retries (2) The total number of times of timeout occurrence is calculated by the following formula. For the total number of timeout occurrences, the number of timeout occurrences in the line quality DB 31 is added for each identical line name.
Total timeout occurrence count = total timeout occurrence count + timeout occurrence count

(3) The number of error receptions is calculated. For the number of error receptions, the number of error receptions in the line quality DB 31 is added by the following formula for each line name.
Total error reception count = Total error reception count + Error reception count When [Step 501] is completed, the process returns to reading of data from the line quality DB 31 in [Step 498].

[Step 506]: [Step 499] It is determined whether or not the reading of data from the line quality DB 31 is completed. When it is determined that the reading of data is completed, the line quality inspection period parameter 20 is designated in the output area. The report output condition specified in the line quality report output condition parameter 21 is set during the survey period.
[Step 502]: It is determined whether all items exceed the value specified in the line quality report output condition parameter 20, and if all items exceed the value specified in the line quality report output condition parameter 20, [Step 504] is performed, and if the items exceeding the value specified in the line quality report output condition parameter are not all items, the following [Step 503] is performed.

[Step 503]: It is determined whether there are one or more items exceeding the value specified in the line quality report output condition parameter 21, and one or more items exceeding the value specified in the line quality report output condition parameter 21 are determined. If there is, [Step 505] is performed, and if there is no item exceeding the value specified in the line quality report output condition parameter 21, the line quality alert report 33 is not output. In this case, [Step 510] is performed next.
[Step 504]: A circle is set in the alert field of the output area, and [Step 507] is performed.
[Step 505]: A mark Δ is set in the alert field of the output area.

[Step 507]: Set the line name, the number of times of timeout occurrence, and the number of error receptions in the output area.
[Step 508]: A line quality alert report 33 is output for a communication line having one or more items exceeding the value specified in the line quality report output condition parameter 21.
[Step 510]: It is determined whether reading of data for all communication lines stored in the table has been completed. If it is determined that the process has been completed, the process ends. If not, the process returns to the determination in [Step 502].

As described above, the line quality alert program 14 uses the line quality report output condition parameter 21 data inputted in advance and the data in the line quality DB 31 in the same way as the data inputted in the line quality investigation period parameter 20 in advance. 33 is automatically created. In this report, a “◯” mark is printed in an alert field for a communication line that requires a line quality survey, and a “Δ” mark is printed in an alert column for a communication line that requires a line quality survey.
By viewing the alert column of the line quality alert report 33, the operator can select a communication line that requires line quality investigation.

  The embodiment according to the present invention is not limited to this, and a line traffic DB creation that is a system having the same functions as the line traffic DB creation program, the line quality DB creation program, the terminal expansion possible line determination program, and the line quality alert unit It is also possible to configure a line, a line quality DB creation part, and a terminal extension possible line determination part.

1 is an overall diagram of hardware and software in a line management system according to an embodiment of the present invention. 9 is a flowchart showing the operation of a “line traffic DB creation program” in the line management system control unit 15 of the line management system 10 according to the present embodiment. 14 is a flowchart showing the operation of the “line quality DB creation program” of the line management system control unit 15 according to the present embodiment. 6 is a flowchart showing the operation of the “line quality DB creation program”. 6 is a flowchart showing the operation of the “line quality DB creation program”. 6 is a flowchart showing the operation of the “line quality DB creation program”. 6 is a flowchart showing the operation of the “line quality DB creation program”. 14 is a flowchart showing the operation of the “line quality alert program” of the line management system control unit 15 according to the present embodiment. The figure for demonstrating "line log information DB" by this embodiment. The figure for demonstrating "configuration management DB" by this embodiment. The figure for demonstrating "terminal system information DB" by this embodiment. The figure for demonstrating the "line quality investigation period parameter" by this embodiment. The figure for demonstrating the "line quality report output condition parameter" by this embodiment. The figure for demonstrating "line traffic DB" by this embodiment. The figure for demonstrating "line quality DB" by this embodiment. The figure for demonstrating the "terminal expansion possible line report" by this embodiment. The figure for demonstrating the "line quality alert report" by this embodiment.

Explanation of symbols

10: Line management system, 11: Line traffic DB creation program, 12: Line DB creation program, 13: Terminal expansion line determination program, 14: Line quality alert program, 15: Line management system control unit, 21: Line quality investigation period Parameters: 22: Configuration management DB, 23: Terminal management system, 24: Line log information DB, 30: Line traffic DB, 31: Line quality DB, 32: Terminal expansion possible line report, 33: Line quality alert report, 40: Host computer, 41: communication line connection device, 42: external host computer connected via communication line, 43: server, 44: line management system input terminal, 45: communication line, 46: user terminal

Claims (6)

In the communication line management system connected to the host computer,
A configuration management database that stores a line utilization threshold value that represents the line speed of the communication line connected to the host computer and the maximum value of the communication line utilization rate that is arbitrarily determined;
A terminal system information database for storing communication data amount per unit time per terminal of a terminal system connected to a communication line connected to a host computer;
A line log information database that stores the cumulative amount of data passing within a specified time for each line of the communication line connected to the host computer;
A line traffic database that stores line utilization information for each line;
With a line management system controller that performs calculations and processing,
The line management system control unit
Reading the cumulative passage data amount stored in the line log information database and the line speed stored in the configuration management database, calculating the passage data amount within a specified time from the cumulative passage data amount and the line speed Calculate the amount of data that can be transmitted within the specified time from
A line traffic database creating means for calculating a line utilization rate by dividing the calculated passing data amount by a transmittable data amount, and writing the calculated line utilization rate in the line traffic database for each line;
The communication data amount per terminal stored in the terminal system information database, the line utilization threshold value and the line speed stored in the configuration management database, and the line traffic database. Read the line utilization rate,
By comparing the maximum value of the line usage rate and the threshold value of the line usage rate, it is determined whether or not the terminal system can be expanded on the communication line,
And / or
By dividing the amount of communication data per unit time per terminal by the amount of data that can be transmitted, an increase value of the line utilization rate is obtained, and the maximum value of the line utilization rate is subtracted from the line utilization rate threshold value. Calculate the number of terminals that can be added by obtaining the margin value of the utilization rate and dividing the increased value of the line utilization rate by the margin value of the line utilization rate,
A communication line management system comprising: a terminal extension possible line determination unit that outputs whether or not the terminal can be added and / or the number of terminals that can be added to an arbitrary output unit. The line log information database stores the total number of retries within a specified time for each line, the total number of timeout occurrences within a specified time, and the total number of error receptions within a specified time.
The line quality database stores the number of retries within the specified time, the number of timeout occurrences within the specified time, and the number of errors received within the specified time for each line.
The line management system control unit
By the setting means, the upper limit of the investigation period, the number of retries that can be accepted in terms of the quality of the communication line, the number of timeout occurrences, and the number of error receptions is preset,
A line quality alert for calculating the total number of retries, timeout occurrences and error receptions stored in the line log information database as the cumulative number of retries, timeout occurrences and error receptions within the preset investigation period Means,
The upper limit of the preset retry count, timeout occurrence count and error reception count is compared with the total of retry count, timeout occurrence count and error reception count within the survey period calculated by the line quality database, 2. The communication line management system according to claim 1, further comprising line quality alert means for determining a line exceeding the upper limit value as a line requiring a line quality investigation. In the management method of the communication line connected to the host computer,
A configuration management database that stores a line utilization threshold value that represents the line speed of the communication line connected to the host computer and the maximum value of the communication line utilization rate that is arbitrarily determined;
A terminal system information database for storing communication data amount per unit time per terminal of a terminal system connected to a communication line connected to a host computer;
A line log information database that stores the cumulative amount of data passing within a specified time for each line of the communication line connected to the host computer;
A line traffic database that stores line utilization information for each line;
With a line management system controller that performs calculations and processing,
The line management system control unit
Reading the cumulative passage data amount stored in the line log information database and the line speed stored in the configuration management database, calculating the passage data amount within a specified time from the cumulative passage data amount and the line speed Calculate the amount of data that can be transmitted within the specified time from
A line traffic database creation procedure for calculating a line utilization rate by dividing the calculated passing data amount by a transmittable data amount, and writing the calculated line utilization rate for each line in the line traffic database;
The communication data amount per terminal stored in the terminal system information database, the line utilization threshold value and the line speed stored in the configuration management database, and the line traffic database. Read the line utilization rate,
By comparing the maximum value of the line usage rate and the threshold value of the line usage rate, it is determined whether or not the terminal system can be expanded on the communication line,
And / or
By dividing the amount of communication data per unit time per terminal by the amount of data that can be transmitted, an increase value of the line utilization rate is obtained, and the maximum value of the line utilization rate is subtracted from the line utilization rate threshold value. Calculate the number of terminals that can be added by obtaining the margin value of the utilization rate and dividing the increased value of the line utilization rate by the margin value of the line utilization rate,
A communication line management method comprising: a terminal extension possible line determination procedure for outputting whether or not the terminals can be added and / or the number of terminals that can be added to an arbitrary output means. The line log information database stores the total number of retries within a specified time for each line, the total number of timeout occurrences within a specified time, and the total number of error receptions within a specified time.
The line quality database stores the number of retries within the specified time, the number of timeout occurrences within the specified time, and the number of errors received within the specified time for each line.
The line management system control unit
A procedure in which an upper limit value of the number of retries and the number of timeout occurrences and the number of error receptions that can be accepted in the quality of the communication line is preset by the setting means,
A line quality alert for calculating the total number of retries, timeout occurrences and error receptions stored in the line log information database as the cumulative number of retries, timeout occurrences and error receptions within the preset investigation period Procedure and
The upper limit of the preset retry count, timeout occurrence count and error reception count is compared with the total of retry count, timeout occurrence count and error reception count within the survey period calculated by the line quality database, 4. The communication line management method according to claim 3, further comprising a line quality alert procedure for determining a line exceeding the upper limit value as a line requiring a line quality investigation. In the communication line management program connected to the host computer,
A configuration management database that stores a line utilization threshold value that represents the line speed of the communication line connected to the host computer and the maximum value of the communication line utilization rate that is arbitrarily determined;
A terminal system information database for storing communication data amount per unit time per terminal of a terminal system connected to a communication line connected to a host computer;
A line log information database that stores the cumulative amount of data passing within a specified time for each line of the communication line connected to the host computer;
A line traffic database that stores line utilization information for each line;
In a system including a line management system control unit that performs calculation and processing,
In the line management system control unit,
Reading the cumulative passage data amount stored in the line log information database and the line speed stored in the configuration management database, calculating the passage data amount within a specified time from the cumulative passage data amount and the line speed Calculate the amount of data that can be transmitted within the specified time from
A line traffic database creation procedure for calculating a line utilization rate by dividing the calculated passing data amount by a transmittable data amount, and writing the calculated line utilization rate for each line in the line traffic database;
The communication data amount per terminal stored in the terminal system information database, the line utilization threshold value and the line speed stored in the configuration management database, and the line traffic database. Read the line utilization rate,
By comparing the maximum value of the line utilization rate and the line utilization threshold value, it is determined whether or not the terminal system can be expanded on the communication line,
And / or
By dividing the amount of communication data per unit time per terminal by the amount of data that can be transmitted, an increase value of the line utilization rate is obtained, and the maximum value of the line utilization rate is subtracted from the line utilization rate threshold value. Calculate the number of terminals that can be added by obtaining the margin value of the utilization rate and dividing the increased value of the line utilization rate by the margin value of the line utilization rate,
A communication line management program for executing a terminal expansion possible line determination procedure for outputting to the arbitrary output means whether or not the number of terminals can be expanded and the number of terminals that can be expanded. The line log information database stores the total number of retries within a specified time for each line, the total number of timeout occurrences within a specified time, and the total number of error receptions within a specified time.
The line quality database stores the number of retries within the specified time, the number of timeout occurrences within the specified time, and the number of errors received within the specified time for each line.
In the line management system control unit,
A setting procedure for presetting the upper limit of the number of retries, timeout occurrences, and error receptions that are acceptable in terms of the quality of the communication line, the investigation period,
A line quality alert for calculating the total number of retries, timeout occurrences and error receptions stored in the line log information database as the cumulative number of retries, timeout occurrences and error receptions within the preset investigation period Procedure and
The upper limit of the preset retry count, timeout occurrence count and error reception count is compared with the total of retry count, timeout occurrence count and error reception count within the survey period calculated by the line quality database, 6. The communication line management program according to claim 5, wherein a line quality alert procedure for determining a line that exceeds the upper limit value as a line that requires a line quality check is executed.

Images