JP2003085133A - Batch control system of on-line compatible system, batch control program of on-line compatible system and recording medium for recording this program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To avoid inconvenience such as the deterioration in a response of on-line processing without restricting a batch job more than necessary in a computer system for processing the on-line processing and the batch job in parallel. SOLUTION: This system executes the batch job by a batch processing part 11 and the on-line processing by an on-line processing part 12 in parallel to a common database DB, and is provided with a monitor 16 for monitoring an executing state of the on-line processing by the on-line processing part 12, and a batch control part 15 for setting a parameter being a control condition at batch job executing time by the batch processing part 11 on the basis of a monitoring result by the monitor 16, and promotes the on-line processing without restricting the batch job more than necessary by changing the parameter according to an occurrence state when a standby state of the on-line processing is caused.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a computer system, and more particularly to a batch job control system in a system for performing online processing and batch jobs in parallel on a common database, a program used for this type of system, and a program therefor. A recording medium in which is recorded belongs to the field of data management technology using a computer.

[0002]

2. Description of the Related Art In recent years, ATMs have been used in management systems using computers such as banks and credit card companies.
With the spread of nighttime transactions and internationalization of card transactions,
There is a demand for 24-hour on-line processing, and the number of batch jobs for managing these tasks tends to increase. Therefore, it has been attempted to simultaneously perform an online process and a batch job, which have been conventionally performed in a common database at different time zones, in parallel, and to put them into practical use.

[0003]

By the way, in a batch job, for example, when a series of processes related to a specific transaction is completed, when such processes are executed a predetermined number of times, or when a predetermined processing time elapses. The so-called synchronous processing for fixing the contents of the updated database is performed at intervals such as, but this synchronous processing imposes a heavy load on the CPU and requires a lot of time. Therefore, it has been customary to set the interval relatively long and set the number of times of synchronization processing to be as small as possible.

However, in the combined system with the online processing as described above, if the interval of the synchronous processing of the batch job is lengthened, the online processing is accepted until the updated or read record is synchronously processed by the exclusive function of the database. As a result, the rapid processing of the online processing is hindered, and as a result, the response time of the online processing becomes significantly longer, especially during the daytime when the online processing is concentrated, which hinders the processing. Will come.

To solve this problem, in a predetermined time zone such as daytime when online processing is likely to be concentrated, by shortening the interval for performing batch job synchronous processing, the records in the exclusive state of the database can be processed early. It is conceivable to make adjustments such as releasing it to promote online processing and shortening its response time.

However, when the online processing is concentrated more than expected, it is impossible to sufficiently process the online processing only by the uniform adjustment according to the time zone, and the response is deteriorated. Conversely, when the occurrence of online processing is small, batch jobs are restricted more than necessary, and the overall processing capacity of the host computer is reduced.

Therefore, the present invention effectively promotes online processing in a computer system that processes online processing and batch jobs in parallel without unnecessarily limiting batch jobs, and increases the processing power of the host computer. It is an object to avoid problems such as deterioration of response of online processing while maintaining the above.

[0008]

That is, the present invention is characterized by having the following constitution in order to solve the above problems.

First, the invention according to claim 1 of the present application is a batch control system for a system that executes online processing and batch jobs in parallel to a common database by means of online processing execution means and batch job execution means. And a standby state detecting means for detecting the occurrence of the standby state of the online processing during the parallel processing of the batch processing and the online processing by the both executing means, and the detecting means for detecting the occurrence of the standby state of the online processing. And a batch job control means for changing the control condition when the batch job is executed by the batch job execution means so as to reduce the waiting state.

According to the present invention, when the online processing and the batch job are executed in parallel, the number of records in the exclusive state by the batch job is increased, so that the online processing has a waiting state of a predetermined limit or more. When it occurs, the batch job is limited by changing the control conditions such as the synchronization processing interval. This will facilitate online processing and improve its response.

According to a second aspect of the present invention, in the system according to the first aspect, the standby state detecting means is
It is characterized in that the occurrence of a standby state of online processing is detected based on an average response time of a predetermined number of online processing or online processing that occurs within a predetermined time.

According to the present invention, the occurrence of the waiting state of the online processing is detected based on the average response time of the predetermined number of online processings or the online processings occurring within the predetermined time. Unnecessarily limiting the batch job against accidental deterioration of response is avoided, and effective and stable control of the batch job is always performed.

According to a third aspect of the present invention, the system according to the first or second aspect, in particular, the batch job executing means is configured to perform a predetermined process every predetermined number of times, or at the time of starting a job or the last time. Batch job control in a system that is configured to perform a synchronous process on a database at least at intervals of a predetermined elapsed time after the synchronous process is executed, and is capable of setting a pause period for a batch job after the synchronous process is executed. The means is characterized in that, as the control condition of the batch job, at least one parameter of the number of times of execution or the elapsed time which is the interval of the synchronous processing or the time of the batch job suspension period is changed.

The invention according to claim 4 is, in the system according to claim 3 as a parameter,
A normal time parameter, a primary restriction parameter that restricts execution of a batch job by a predetermined amount from a normal time, and a secondary restriction parameter that further increases the restriction degree are set. After the parameter is changed to the primary limiting parameter, the secondary limiting parameter is used when the standby state of the online processing is not resolved.

According to these aspects of the invention, when the waiting state of the online processing occurs, the number of executions of the predetermined processing, which is the interval of the synchronous processing, of the parameters as the control condition of the batch job is reduced, or The records that were in the exclusive state in the database will be released early due to the shortening of the elapsed time from the execution of the synchronous processing of, and the batch job suspension period will be provided after the synchronous processing is executed, or Online processing will be promoted due to a longer period of time. In this case, if two or more parameters such as the number of times or the above interval and the batch job pause time are changed at the same time, online processing can be more effectively promoted.

According to the invention described in claim 4,
In the case where a standby state for online processing has occurred, the secondary limit parameter is used when the standby state is not sufficiently resolved by simply changing the parameter from the normal parameter to the primary limit parameter.
Since the degree of limitation on the batch job is increased, the waiting state of the online processing can be reliably eliminated without imposing unnecessary limitation on the batch job from the beginning.

Further, according to the invention described in claim 5, in the system according to claim 3 or 4, particularly in the system for processing a plurality of batch jobs, at least the priority of processing or the degree of hindering online processing is provided. Parameter recording means for recording a parameter for each group of batch jobs classified based on one attribute is provided, and the batch job control means is configured to set parameters for the group to which the batch job currently being executed belongs from the parameter recording means. Is read out and used.

According to the present invention, in the case of a system in which a plurality of batch jobs of different types are executed, the priority of each batch job is, for example, whether the processing is urgent or not, The jobs will be grouped according to attributes such as the degree of obstructing online processing, such as whether the job involves updating the database or only the reference, and parameters will be set for each group according to the above attributes. . Then, from the parameter recording means that records the parameters for each group,
The batch job will be executed by reading the parameters of the group to which the currently executing batch job belongs.

Therefore, the limitation on each batch job is appropriately executed by the parameter according to the attribute of the batch job, and when setting or changing this parameter, the setting or change for each batch job is not necessary. Therefore, it becomes possible to collectively set and change batch jobs of the same group.

On the other hand, according to a sixth aspect of the present invention, the online processing execution means and the batch job execution means execute the online processing and the batch job in parallel on the common database, and both of the execution means. The present invention relates to a batch control program for a system having online processing monitoring means for monitoring the execution status of online processing during parallel processing of online processing and batch jobs, wherein a computer is used for monitoring results by the online processing monitoring means. Based on the standby state determining means for determining whether or not the standby state has occurred in the online processing based on the determination, and when the determination means determines that the standby state for the online processing has occurred, the standby state is reduced. , The control conditions at the time of batch job execution by the above batch job execution means Further, characterized in that to function as a batch job control means for.

The invention according to claim 7 is the program according to claim 6, wherein a predetermined number of online processes or online processes that occur within a predetermined time when the computer functions as the standby state determination means. It is characterized by functioning to determine the occurrence of a standby state of online processing based on the average response time of.

According to an eighth aspect of the present invention, in the program according to the sixth or seventh aspect, the batch job executing means performs the predetermined processing every predetermined number of times, or at the time of starting the job or the previous time. When used in a system that is configured to perform synchronization processing for a database at least at intervals of every predetermined elapsed time from the time when synchronization processing is executed, and that allows the setting of a pause period for batch jobs after execution of synchronization processing When the computer is caused to function as the batch job control means, as the control condition of the batch job, at least one parameter of the number of times of execution or the elapsed time which is the interval of the synchronous processing, or the time of the batch job suspension period is changed. It is characterized by making it function as.

The invention according to claim 9 is, in the program according to claim 8 as a parameter,
When the system is used in a system in which a normal time parameter, a primary restriction parameter that restricts execution of a batch job by a predetermined amount from the normal time, and a secondary restriction parameter that further increases the restriction degree are set, the computer is batched. When functioning as the job control means, after changing from the normal parameter to the primary limiting parameter, the secondary limiting parameter is used when the standby state of the online processing is not resolved.

According to a tenth aspect of the invention, in the program according to the eighth or ninth aspect, a plurality of batch jobs are executed, and at least one of the priority of processing and the degree of hindering online processing is set. When the computer is made to function as the batch job control means when used in a system provided with a parameter recording means for recording parameters for each group of batch jobs classified based on attributes, the parameter recording means is currently executing the data from the parameter recording means. It is characterized in that it functions so as to read and use the parameters of the group to which the batch job belongs.

The programs described in claims 6 to 10 correspond to the systems described in claims 1 to 5, respectively, and these programs are executed by batch job execution means, online processing execution means, etc. When used in a computer system equipped with, the same operation as the batch control system according to the first to fifth aspects can be obtained.

The invention described in claim 11 relates to a computer-readable recording medium in which the program according to any one of claims 6 to 10 is recorded. According to this recording medium, When the program according to any one of claims 6 to 10 is executed, the same operation as that of the batch control system according to claims 1 to 5 is realized.

[0027]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below.

FIG. 1 shows a hardware configuration of a system according to this embodiment. A host computer 10, which is the center of the system, has a batch processing unit 11 and an online processing unit 12, and both processing units 11 are provided. , 12 are connected to operator terminals 21 used for inputting various commands and monitoring the progress of batch jobs.

Further, the batch processing section 11 inputs data from an external input file FL1 and outputs an output file FL2.
Data output to the online processing unit 12 is provided, and the online processing unit 12 includes a counter 13 and a timer 14 used for setting the timing of synchronization processing.
Can be connected to a large number of user terminals (not shown) via the communication control device 22.

Further, the host computer 10 is provided with a batch control unit 15 for controlling the processing state of the batch job by the batch processing unit 11, and the batch control unit 15 has the operator terminal 2
1, a monitor 16 for monitoring the execution status of online processing by the online processing unit 12, and a clock 1
7 and 7 are connected. Further, the batch control unit 15 records a job group table TB1 in which a group to which each of a plurality of batch jobs grouped according to attributes belongs is recorded, and a parameter table in which parameters that are control conditions at the time of executing the batch job are recorded. TB2 is connected.

Then, the batch controller 15 follows the batch control program according to the embodiment of the present invention, and outputs a signal from the monitor 16 indicating the execution status of the online processing.
The processing status of the batch job by the batch processing unit 11 is controlled based on the signal from the clock 17, the command signal from the operator terminal 21, and the information read from the job group table TB1 and the parameter table TB2, respectively. It is supposed to do.

Here, the job group table TB
1 and the parameter table TB2,
First, in the job group table TB1, as shown in FIG. 2, each batch job is a job that exclusively updates the database DB and has a high degree of obstruction to online processing, and a job that mainly refers to the database DB. Are divided into those having a low degree and those not using the database DB and are respectively divided into a division A, a division B, and a division C, and a plurality of jobs in each division have a priority 1 according to the urgency of processing or the like. 2 are set, and each job is divided into groups using the division and the priority as parameters.

The parameter table TB2 is
As shown in FIG. 3, of the batch jobs grouped by the job group table TB1, a group A1 of jobs exclusively updating the database DB,
A2 ..., and for each group of jobs B1, B2 ... Of which reference is mainly made to the database DB, a predetermined number of times of execution of a predetermined process (hereinafter, referred to as “interval number”) and an interval at which the synchronous process is executed, and the start time of the job. Alternatively, three parameters, that is, a predetermined elapsed time from the previous execution of the synchronization processing (hereinafter, referred to as “interval time”) and a pause time of the batch job provided after the execution of the synchronization processing, are set as batch non-limitation in the online priority time zone. Time, batch primary restriction, secondary restriction, and batch priority time zone are set.

In that case, in the online priority time zone,
The number of intervals is small and the interval time is shortened when the primary job is restricted compared to when the batch job is not restricted, so that the records in the database DB that are in the exclusive state due to the execution of the batch job are set to be released early. Further, the batch job pause time is set to a value larger than 0, and the batch job is set to pause for a predetermined time after the synchronous processing is executed.

In addition, the numerical value at the time of the secondary restriction is 1 for the secondary restriction.
It is a value that is added to the value of the parameter at the time of primary limitation so as to increase the degree of limitation on the batch job each time it is executed. By subtracting the interval count and interval time by a predetermined amount, the exclusion status Is set to release the record at an earlier time, and the batch pause time after the execution of the synchronous processing is incremented by a predetermined amount to make the pause time longer.

Regarding the priority of the batch job,
The higher the priority, the larger the number of intervals and the interval time, and the shorter the pause time.
As for the classification of batch jobs, the job of the section A that exclusively updates the database DB (the section having a high degree of hindering online processing) is the job of the reference center of the database DB (the section having a low degree of hindering online processing) The number of intervals and the interval time are set to values smaller than those of the job No., and the pause time is set to be longer, so that the limit for the batch job is set stronger.

In the batch priority time zone in which the batch job restriction control is not performed, both the number of intervals and the interval time are larger than the online priority time zone, and the pause time after the synchronous processing is 0. It is said that the processing of batch jobs is actively promoted.

Next, the job operation by the above system, particularly the control operation for the batch job according to the execution status of the online processing will be described.

First, the operation of the synchronous processing control during the execution of a batch job centered on the batch processing section 11 shown in FIG. 1 will be described with reference to the flowchart shown in FIG.

This synchronous processing control is executed as a subroutine called in the main routine of the batch job each time a predetermined processing such as the processing of inputting a record from the input file FL1 is performed. First, step S1 is executed. Then, the number of times the subroutine is called, that is, the number of times the predetermined process is executed is counted by the counter 13 shown in FIG. Then, in step S2, it is determined whether or not the number of times has reached a predetermined number of intervals after the execution of the previous synchronization process. If not, the timer 14 shown in FIG. 1 is used in step S3. It is determined whether the elapsed time from the start of the job being measured or the time of the previous execution of the synchronization process has reached a predetermined interval time.

The above-mentioned interval count and interval time are set to values read in advance from the parameter table TB2 of FIG. 3 according to the group to which the batch job belongs and the execution state of the online processing by the batch restriction control described later. The interval time is the input / output file FL to / from the host computer 10.
1, when the FL2 setting or the like requires a certain time or more, or when the predetermined process is a process for handling a large amount of data and it takes a long time to execute the process, etc., before the number of intervals is reached. However, it is set to perform the synchronization process.

After execution of the previous synchronization processing, when the number of executions of the predetermined processing reaches the number of intervals, or even before reaching the number of intervals, the time elapsed from the start of the batch or the execution of the previous synchronization processing. When the time reaches the interval time, step S2 or step S3 to step S4 is executed, and the database DB is synchronously processed in the updated state at that time.

Next, in step S5, the batch pause period after the execution of the synchronous processing which is read out from the parameter table TB2 and set in advance by the batch restriction control described later (hereinafter referred to as "pause time"). Wait for. During this pause period, batch jobs are paused,
During that time, the host computer 10 exclusively executes online processing. When the pause time is 0, that is, when the batch pause period after the synchronous processing is not set, step S5 ends immediately.

When the pause time has elapsed, the count value of the number of times the predetermined process is executed by the counter 13 (the number of times the subroutine is called) and the time measured by the timer 14 are cleared in step S6, and this synchronous process control is executed. To finish.

Next, the operation of the batch limitation control for setting the parameters, which are the control conditions of the batch job, such as the number of intervals, the interval time and the pause time, according to the execution state of the online processing will be described with reference to the flowchart shown in FIG. To do. Note that this control is performed mainly by the batch control unit 15 in FIG. 1, and its operation corresponds to the operation of the program according to the embodiment of the present invention.

This control is usually performed by the host computer 1.
It starts from the start of daily work by 0, first, after a predetermined initialization, step S1 of the flowchart.
In step 1, it is determined by the signal from the clock 17 shown in FIG. 1 whether or not the current time belongs to a predetermined online priority time zone.

If, for example, the online priority time zone is from 9 am to 5 pm, and the start of the day's work on the host computer 10 is 9 am, the online priority time is set at the start of work. Will belong to the belt. In this case, first, in step S12, as parameters of the number of intervals for performing the synchronization processing, the interval time, and the batch pause time after execution of the synchronization processing, as shown in FIG.
Value of the job group to which the currently executed batch job belongs is read out from the parameter table TB2 during the batch non-limit time period,
These are set in the parameters for batch job control.

If the group to which the currently executed batch job belongs is A1, for example, as shown in FIG. 3, the number of intervals is 1 as each of the above parameters.
00 times, the interval time is set to 30 seconds, the batch pause time is set to 0, and the above-mentioned subroutine is used to perform the synchronous processing for the batch job using these parameters.

Next, in step S13, the response time of the online processing is detected based on the signal from the monitor 16 shown in FIG. 1, and the time is at or below the allowable limit as shown in FIG. Therefore, the limit execution reference value T1 that is a reference for determining whether to limit the batch job
Which is a criterion for determining whether or not the limit is once exceeded, or whether or not the limit once implemented should be released.
It is determined whether or not it is less than the limit cancellation reference value T2 shorter than 1 and further whether or not it is a value between these times T1 and T2.

In order to avoid unnecessary restrictions on batch jobs due to temporary or sudden response delays in online processing, the above determination is made by averaging a predetermined number of online processings or online processings that have occurred within a predetermined time. It is designed to be performed based on the response time. Therefore, steps S13 and thereafter are executed when the average value is calculated.

Then, the online processing is executed smoothly, and the response time thereof is the above-mentioned limit execution reference value T1.
In the following cases, that is, when belonging to the area B or C in FIG. 6,
No aggressive restrictions are placed on batch jobs. In that case, if the response time is less than the restriction release reference value T2 and belongs to the area C, it is determined in step S14 whether or not the restriction on the batch job is currently executed. Is not restricted, the control ends as it is.

On the other hand, when the frequency of online processing is high and the response time becomes long and exceeds the above-mentioned limit enforcement reference value T1 to belong to the area A of FIG. 6,
That is, when a peak of online processing (peak A in FIG. 7) occurs, steps S13 to S15 are executed to count the number of occurrences of online peaks, and in step S16, the current occurrence is the online priority time zone. It is determined whether or not it is the first time after the start of control in.
If it is the first time, in step S17, as shown in FIG.
The parameter for primary restriction for the job group is read from the parameter table TB2, and thereafter, the synchronization process by the subroutine of FIG. 4 is executed using this parameter.

Thus, for example, in the case of a batch job belonging to the job group A1, the interval count is 50.
The number of times and the interval time are reduced to 15 seconds respectively, and the batch pause period of 0.5 seconds is set after the synchronous processing is executed. By executing the synchronous processing with this parameter, the symbol a in FIG. As shown by, the batch job is in the first restricted state.

That is, the batch processing is suppressed by shortening the interval of the synchronous processing and increasing the number of times, but on the other hand, the database DB which is in the exclusive state due to the execution of the batch job. Will be released earlier, and online processing will be promoted to that extent, and the online processing will be further promoted by providing the pause period of the batch job after the synchronous processing is executed.

After starting the primary restriction, the current time indicated by the clock 17 is recorded as the primary restriction start time in step S18 for the next restriction control.

Although the response time for online processing is usually shortened by the above-mentioned restriction control for batch jobs, the frequency of occurrence of online processing is further increased, and the average response time is less than the restriction release reference value T2. The limit enforcement reference value T
May exceed 1. In this case, the above step S13
From step S15 to step S16, step S19 is executed. By comparing the time at that time indicated by the clock 17 and the primary restriction start time,
The time elapsed from the start of the primary restriction is determined.

Then, when this time is less than 15 minutes, that is, as shown in the online peak B in FIG. 7, the average response time is set to the restriction execution reference value T1 again while the sufficient time has not elapsed from the start of the primary restriction. When it exceeds, the new restriction is not made to see the situation for a while and the state of the primary restriction is maintained.

On the other hand, as shown in the online peak C of FIG. 7, the state where the average response time exceeds the limitation execution reference value T1 is 3 minutes after 15 minutes have passed from the start of the primary limitation.
If it occurs before 0 minute has elapsed, step S20 is executed, and the secondary limitation on the batch job is started, as indicated by the symbol b in FIG.

The secondary restriction is read from the parameter table TB2 in FIG. 3 by reading out the increment of each parameter of the group to which the job belongs and adding this to the value at the time of primary restriction to strengthen the restriction on the batch job. To do. For example, if the batch job currently being processed belongs to the group A1, the interval count is 5
It becomes 45 times by adding -5 to 0, and the interval time becomes 13 seconds by adding -2 to 15 and the batch pause time after the synchronous processing is 0.5 to 0.2.
It becomes 0.7 by adding.

By executing the synchronous processing control by the subroutine of FIG. 4 with the new parameters thus corrected, the synchronous processing is performed more frequently and the batch pause after the synchronous processing is executed. The period of time becomes longer, and as a result, the processing of the batch job is further restricted, and the online processing is further accelerated accordingly.

As shown in the online peak D shown in FIG. 7, the elapsed time from the start of the primary restriction is 15 minutes to 30 minutes.
If an online peak occurs multiple times by the minute, the above parameters will be added by the above increments each time. Therefore, the interval is gradually shortened, and the batch pause time after execution of the synchronous processing is gradually lengthened.

In addition, despite the above-mentioned secondary restriction, the average response time of online processing was not effectively shortened, and 30 minutes had elapsed from the start of the primary restriction as shown by online peak E in FIG. When a situation in which the limit execution reference value T1 is exceeded later occurs, in this batch limit control, steps S19 to S21 of the flowchart of FIG. 5 are executed, the limit control is interrupted, and the operator terminal 21 is notified of that. Notify the status.

As a result, the operator operates the terminal 2
From 1 to the batch processing unit 11, processing such as issuing a command for temporarily stopping the batch job is performed, and as a result, a significant deterioration in the response of the online processing is avoided.

When the average response time of the online processing becomes less than the limit release reference value T2 due to the execution of the above-described first-order limitation or second-order limitation, the steps S13 and S14 are followed by the step S22. Execution is performed, and each parameter is reset to the value when the batch is not restricted in the parameter table TB2 of FIG. As a result, the processing status of the batch job returns to the non-restricted status in the online priority time zone, as indicated by the symbol c in FIG.

Then, in step S23, the number of times of occurrence of the online peak counted in step S15 and the primary restriction start time set in step S18 are cleared to prepare for the control when the online peak occurs again. .

Although the online peak does not occur after the primary restriction or the secondary restriction is executed, the average response time does not fall below the restriction cancellation reference value T2 and belongs to the area B in FIG. If the state persists, the limit for batch jobs will be to maintain the current state.

Further, when the current time measured by the clock 17 in FIG. 1 shifts to the batch priority time zone (for example, 5 pm to 9 am the next day), steps S11 to 24 are executed, As the value of each of the above parameters,
The value of the batch priority time zone is read from the parameter table TB2 of FIG. 3, and the batch job is executed using the value.

In this case, since the deterioration of the response of the online processing is unlikely to be a problem, both the number of intervals and the interval time are set to a large value, and the pause period after the synchronous processing is not set. .
Therefore, batch jobs are executed continuously and intensively, and the processing thereof is promoted.

Although the above description has been made by taking the batch job belonging to the group A1 as an example, in the parameter table TB2 of FIG. 3, each control parameter is set according to the attribute of the batch job, and for example, has a high priority. Batch jobs are less restricted than lower priority jobs, which prevents significant delays in their processing.
For jobs that have a high degree of obstruction to online processing, the degree of restriction is set higher than for jobs with a low degree to maintain a good response of online processing. It will be done finely according to the attribute.

By recording the control parameters for each group of batch jobs, it is possible to collectively set or change them for each group of batch jobs.

[0071]

As described above, according to the present invention, in a system in which online processing and batch jobs are processed in parallel, when a standby state for online processing occurs, such as when the response time exceeds a predetermined value. The batch job restriction control is performed according to the occurrence status.

As a result, it is possible to effectively eliminate or avoid the deterioration of the response of the online processing while avoiding the unnecessary limitation such as the case where the batch job is uniformly limited according to the time zone or the like. As a result, the online processing is always executed well without deteriorating the overall processing capacity of the host computer.

[Brief description of drawings]

FIG. 1 is an explanatory diagram of a hardware configuration of a system according to an embodiment of the present invention.

FIG. 2 is a configuration diagram of a job group table in the embodiment.

FIG. 3 is also a configuration diagram of a parameter table.

FIG. 4 is a flowchart showing an operation of synchronous processing control.

FIG. 5 is a flow chart showing the operation of batch limitation control in the same manner.

FIG. 6 is a region diagram of a response time of online processing similarly.

FIG. 7 is a time chart showing an execution state of batch limitation control.

[Explanation of symbols]

10 Host Computer 11 Batch Processing Unit (Batch Execution Means) 12 Online Processing Unit (Online Execution Means) 15 Batch Control Unit (Batch Control Means) DB Database TB2 Parameter Recording Means (Parameter Table)

Claims (11)

[Claims] 1. A batch control system of a system for executing online processing and batch jobs in parallel to a common database by means of the online processing executing means and the batch job executing means, wherein the online processing is performed by both of the executing means. And a standby state detecting means for detecting the occurrence of the standby state of the online processing during the parallel processing of the batch job, and when the standby state of the online processing is detected by the detecting means, the standby state is reduced,
A batch control system for an online combination system, comprising: a batch job control means for changing a control condition when the batch job is executed by the batch job execution means. 2. The standby state detection means detects the occurrence of a standby state of online processing based on an average response time of a predetermined number of online processes or online processing that occurs within a predetermined time. Batch control system of the online combination system described in. 3. The batch job executing means performs the synchronization processing on the database at least once every predetermined number of times of predetermined processing, or at least one of every predetermined elapsed time from the start of the job or the previous execution of the synchronization processing. In the system configured as described above and capable of setting the pause period of the batch job after the synchronous processing is executed, the batch job control means uses the number of execution times or the elapsed time as the interval of the synchronous processing as the control condition of the batch job. Alternatively, at least one parameter of the batch job pause period is changed, and the batch control system of the online combination system according to claim 1 or 2. 4. A parameter for a normal time as a parameter and a limit for executing a batch job by a predetermined amount from the normal time.
The next limit parameter and the second limit parameter for further increasing the limit degree are set, and the batch job control means does not cancel the standby state of the online processing after changing from the normal parameter to the first limit parameter. The batch control system of the online combination system according to claim 3, wherein a secondary limiting parameter is sometimes used. 5. In a system in which a plurality of batch jobs are executed, there is provided a parameter recording means for recording parameters for each group of batch jobs classified based on at least one of the priority of processing and the degree of obstructing online processing. 5. The online combination system according to claim 3 or 4, wherein the batch job control means is provided and uses the parameter for the group to which the currently executing batch job belongs, read from the parameter recording means. Batch control system. 6. The online processing execution means and the batch job execution means execute online processing and batch jobs in parallel with respect to a common database, and the online processing and batch jobs are executed in parallel by both execution means. Is a batch control program for a system provided with an online processing monitoring means for monitoring the execution status of online processing in a computer, in which a standby state occurs in the online processing based on the monitoring result by the online processing monitoring means. When the batch job is executed by the batch job executing means, the standby state determining means for determining whether or not the standby state is reduced when the online state waiting state is determined by the determining means Function as a batch job control unit that changes the control conditions of A program for batch control of an online combination system characterized by the following. 7. When the computer functions as a standby state determination means, it is determined whether or not a standby state of online processing occurs based on an average response time of a predetermined number of online processes or online processing that occurs within a predetermined time. The program for batch control of the online combination system according to claim 6, which is made to function. 8. The batch job executing means performs synchronous processing on the database at least once every predetermined number of times of predetermined processing, or at least one of predetermined time elapsed from the start of the job or the previous synchronous processing execution. And a program used in a system capable of setting a pause period of a batch job after the synchronous processing is executed, wherein when the computer functions as a batch job control unit, 8. The online system according to claim 6 or 7, wherein at least one parameter of the number of times of execution or an elapsed time that is an interval of the synchronous processing or the time of the batch job suspension period is changed. Program for batch control of combined system. 9. A parameter for a normal time as a parameter and a limit for executing a batch job by a predetermined amount from the normal time 1
A program used in a system in which a secondary restriction parameter and a secondary restriction parameter for further increasing the degree of restriction are set, and when the computer is made to function as batch job control means, the primary restriction is performed from the normal parameter. 9. The program for batch control of an online combination system according to claim 8, wherein the program is made to function so as to use the secondary restriction parameter when the standby state of the online processing is not resolved after changing to the parameter. 10. A parameter recording means for recording a parameter for each group of batch jobs in which a plurality of batch jobs are executed, and which are classified based on at least one of the priority of processing and the degree of obstructing online processing. A program used in the system described above, when the computer is caused to function as a batch job control unit, the parameter recording unit is caused to read and use a parameter for a group to which the currently executing batch job belongs. 10. The batch control program for the online combination system according to claim 8 or 9. 11. A computer-readable recording medium in which the program according to any one of claims 6 to 10 is recorded.