JPH04361338A - Transaction log data succeeding system - Google Patents

Abstract

PURPOSE:To improve efficiency for the processing of a batch job to access a transaction log file by reading the contents of the transaction log file to be written by an online job without waiting for the release of the online job. CONSTITUTION:For the request of a data base update processing inputted from an online terminal 100, a transaction log file update processing 400 outputs the file name of the transaction log file at a write destination and the write address to a transaction log file address table 600 when data are written in a transaction log file 700. When the transaction log file update processing 400 is abnormally finished, a transaction log file correction processing 500 writes a record without data having a control value at that time in the address of the transaction log file 700 shown in the transaction log file address table 600.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a transaction log data transfer method, and more particularly to a transaction log data transfer method that improves the processing efficiency of batch jobs that access transaction log files recorded by online jobs.

0002

[Background Art] Transaction log data file recording processing and transaction log data file batch access processing using a conventional online job are performed using an online terminal 100 that generates a message and an online terminal that receives and processes the message, as shown in FIG. Application program (hereinafter referred to as “AP”)
) 101, a transaction log file update process 400, a transaction log file 700, a transaction log file management file 200 for managing the transaction log file, and a transaction log file in which the contents of the transaction log file management file 200 are developed in memory. It has a management table 300, a transaction log file reading process 800, and an AP 102 that processes data of the transaction log file.

FIG. 3 shows a transaction log file management file 20.
The structure of 0 is shown. This transaction log file management file 2
00 manages a plurality of transaction log files 700, and the number of records is equal to the number of transaction log files 700. The items of the transaction log file management file 200 are a file name 201, a transaction log file start address 202, an end address 203, an online job transaction log file processing status 204, a batch job transaction log file processing status 205, and a control value 206 indicating the validity of the transaction log data. Online job transaction log file processing status 2
04 is set to a value indicating online unused as an initial value, and when an online job uses the transaction log file, it is rewritten to a value indicating online use, and when an online job opens the transaction log file, it is rewritten to a value indicating online usage. It is rewritten to a value indicating . In the batch job transaction log file batch processing status 205, a value indicating that the batch job has not been processed is set as an initial value, and when the batch job finishes reading the transaction log file, a value indicating that the batch job has been processed is set. can be rewritten as

FIG. 4 shows transaction log file management table 3.
The structure of 00 is shown. This transaction log file management table 300 is the one in which the management information of the transaction log file 700 being used by the online job is expanded in memory among the records of the transaction log file management file 200. Transaction log data was recently written in the file name 301, the start address 302, the end address 303, the control value 304, and the transaction log file 700, which are expanded file names 201, start addresses 202, end addresses 203, and control values 204, respectively. It has a current address 305 indicating the address.

FIG. 6 shows the structure of a transaction log file 700, which includes a record control section 701 and a data section 702 indicating transaction log data.

Next, the operation will be explained.

Prior to system activity, the control values in the record control section 701 of the all transaction log file 700 are initialized, and the control values 206 in all the records of the transaction log file management file 200 contain the data for that day. Set a control value to indicate this. When the system starts, information about the transaction log file in which the transaction log should be written is expanded from the transaction log file management file 200 onto the transaction log file management table 300. At this time, current address 3
05 is set to a value obtained by subtracting 1 from the value of the start address 302. Thereafter, the current address 305 is used as the access key when writing data to the transaction log file 700 until the value of the current address 305 becomes equal to the value of the end address 303. The transaction log file processing status 204 of the online job on the transaction log file management file 200 is rewritten to a value indicating that the transaction log file 700 is being used online when the transaction log file 700 is developed in the transaction log file management table 300.

The data generated by the transaction log file update process 400 is written on the transaction log file 700 with the file name 301 shown in the transaction log file management table 300. A control value 304 is written in the record control unit 701. The write address is the current address 305 plus 1, and the current address 305 of the transaction log file management table 300 is also updated at the same time. When updating the current address 305, exclusive control is applied to the transaction log file management table 300. This is to prevent data records from being overwritten due to multiple tasks obtaining the same current address 305 when transaction log file update processing is performed by multiple tasks.

[0009] Current address 305 is end address 3
If it is equal to 03, transaction log file update process 4
00 rewrites the online job transaction log file processing status 204 of the record on the transaction log file management file 200 corresponding to the transaction log file management table 300 from online in use to online used, and updates the next transaction log file 700. The information is developed on the transaction log file management table 300.

Transaction log file 70 showing transaction details
In a batch job that processes 0 data records, the transaction log file processing status 204 of the online job in the transaction log file management file 200 is set from the start record 202 to the end record 203 for the transaction log file 700 that is online used. Performs reading processing. After the reading process is completed, the transaction log file processing status 205 of the batch job of the transaction log file 700 that has been processed is set to batch processed.

The transaction log file reading process 800 is performed by the record control unit 70 of the accessed transaction log file 700.
The data part of the record whose control value 1 is equal to the control value 206 of the transaction log file management file 200 is batched into AP1.
Pass it to 02. The control value of the record control unit 701 is control value 2
If it is different from 06, it is determined that the data is not for that day, and the process of passing the data section 702 to the batch AP 102 is not performed. This record reading process is performed from the start record to the end record of the accessed transaction log file 700.

0012

[Problems to be Solved by the Invention] The reading process of the transaction log file 700 of the conventional batch job is based on the control value of the record control unit 701 and the transaction log file management file 200.
A comparison is made with the control value 206, and records with equal values are read, and records with different values are skipped. Therefore, if you change the access method from the conventional file-based transaction log data access to record-based transaction log data access, the transaction log file reading process will be performed for the transaction log file 700 that is currently in use or unused online. 800 has a problem in that records that have not been updated are also skipped.

[0013]

[Means for Solving the Problems] The transaction log data transfer method of the present invention provides a system in which an online job records transaction logs and a batch job processes transaction logs that occur sequentially. A transaction log file address table in memory for storing file name addresses of transaction log files, and a function for erasing the contents of the transaction log file address table when a task having the transaction log file address table completes processing normally. a transaction log file update means having a function of writing a file name address in which a transaction log is written into the transaction log file address table; and when an abnormality occurs in the task having the transaction log file address table, the transaction log file is updated. A transaction log file modification means that has a function of writing a record with control for the current day to the transaction log file address indicated by the address table, and a function that controls reading processing and reading interruption based on the control value in the transaction log file record. a transaction log file reading means, a transaction log file for writing a log of transactions that have occurred, a transaction log file management file for managing the transaction log file, and a transaction log file management table for managing the transaction log file. be done.

[0014]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be explained with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention, and is a conceptual diagram of transaction processing using a transaction log handover method.

The online terminal 100 issues processing requests such as database update processing, and the online AP 101 receives processing messages and performs processing on the database and the like. The transaction log file update process 400 outputs the details of the process that occurred at that time to the transaction log file 700. The output destination transaction log file 700 is obtained from the transaction log file management table 300.

The contents of the transaction log file management file 200 are developed in the transaction log file management table 300 prior to the transaction log file update process 400. When transaction log file update processing 400 writes data to transaction log file 700, it outputs the file name and write address of the transaction log file to which data is to be written to transaction log file address table 600. The structure of the transaction log file address table 600 is shown in FIG. The file name of the transaction log file 700 into which the transaction log data has been written is written in 602, and the write address is written in 603, respectively. At this time, the number of entries 601 is incremented by 1.

The transaction log file modification process 500 updates data with the current day's control value to the address of the transaction log file 700 shown in the transaction log file address table 600 when the transaction log file update process 400 ends abnormally. Write a record of none. The transaction log file reading process 800 reads the transaction log file management file 20.
Batch AP 102 accesses the transaction log files 700 in the order registered in 0 and reads them in order from the first record.
Pass the data to. Record control section 7 of the read record
If the control value 01 is different from the control value 206, this is a record that has not been written, so the reading process is interrupted.

Transaction log file management table 300 when transaction log file update process 400 is performed normally and when an abnormality occurs during processing using the case where transaction log file update process 400 has a multi-task configuration. , the status of the transaction log file 700 will be explained.

FIG. 7 is an excerpt of the system configuration from an explanatory diagram showing the operation of this embodiment.

Tasks 400A and 401B represent transaction log file update processing, and file 700A represents the transaction log file. If a transaction log write request occurs in the order of task 400A and task 401B, task 400A
has accessed the transaction log file management table 300, the transaction log file management table 300 is exclusive, and the task 401B enters a waiting state. Task 400A writes transaction log data to address 2 of file 700A obtained from transaction log file management table 300. Task 400A updates the current address 305 of the transaction log file management table 300 and releases the exclusion of the transaction log file management table 300. FIG. 8 is a diagram showing the state after the series of processing up to this point has been completed.

The current address 304 of the transaction log file management table 300 is updated to 2, and the file 700
Address 2 of A has a control value 3 in the record control unit 701.
A transaction log data record with 05 is written. The file name and write address of the file 700A in which the data record has been written are written to the transaction log file address table 600, and the number of entries 601 is updated. Since the exclusive use of the transaction log file management table 300 by the task 400A is released, the task 401B can access the transaction log file management table 300. Task 401B is also task 4 explained above.
The same process as 00A is performed to update the transaction log file management table 300, transaction log file 700, and transaction log file address table 610. FIG. 9 is a diagram showing the state after the series of processing up to this point has been completed. AP101 that called task 400A and task 401B,
Immediately before the AP 111 terminates normally, the number of entries in the transaction log file address tables 600, 610 is 601,
611 is initialized to 0.

The transaction log file reading process of the batch job that reads the file 700A reads up to the record at address 3 and interrupts the process when the record at address 4 is accessed. The above explanation is based on tasks 400A, 40
This is a case where the AP 101 and AP 111 calling 0B terminate normally. In FIG. 7, after the task 400A releases the exclusion of the transaction log file management table 300,
FIG. 10 shows the state when a transaction abort occurs. When a transaction abort occurs, a backout process is performed on the transaction log file 700, and the writing process of the task 400A to the transaction log file is canceled. Since the task 401B writes data to the address obtained from the transaction log file management table 300, an unupdated record occurs at address 2 in the file 700A as shown in FIG.

[0024] If such an unupdated record exists,
In the transaction log file reading process 800 of the batch job, if the control value of the record control unit 701 is different from the control value 206 in the transaction log file management file 200, the reading process is interrupted. You will not be able to read beyond the record. If a transaction abort occurs, the AP where the error occurred
101 calls the transaction log file modification process 500, and the transaction log file modification process 500 adds the transaction log file 700 shown in the transaction log file address table 600 to the transaction log file 700 with no transaction log data having the control value 206 in the record control unit 701. Write a record. After processing all entries in the transaction log file address table 600, the number of entries 601 is initialized. FIG. 11 shows the state after the above processing is executed. Since a record in which the control value of the record control unit 701 is equal to the control value 206 was written to address 2 of the transaction log file 700, the transaction log file reading process 800 of the batch job is executed as follows.
Processing can be performed on the record at address 2. However, since there is no transaction log data in the record of address 2, the process of passing the data to the AP 102 is not performed.

Transaction log file reading processing 800 reads the next record of address 3, processes it, and reads the record of address 4.
Processing is interrupted when the record is read.

[0026]

[Effects of the Invention] As explained above, by using the transaction log data transfer method, a batch job can transfer the contents of a transaction log file written by an online job without waiting for the online job to open the transaction log file. This makes it possible to increase the processing efficiency of batch jobs that access transaction log files.

[Brief explanation of the drawing]

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

FIG. 2 is a block diagram showing the configuration of a transaction log data transfer method according to a conventional technique.

FIG. 3 is an explanatory diagram showing the structure of a transaction log file management file.

FIG. 4 is an explanatory diagram showing the structure of a transaction log file management table.

FIG. 5 is an explanatory diagram showing the structure of a transaction log file address table of this embodiment.

FIG. 6 is an explanatory diagram showing the structure of a transaction log file.

FIG. 7 is an explanatory diagram showing the operation of this embodiment.

FIG. 8 is an explanatory diagram showing the operation of this embodiment.

FIG. 9 is an explanatory diagram showing the operation of this embodiment.

FIG. 10 is an explanatory diagram showing the operation of this embodiment.

FIG. 11 is an explanatory diagram showing the operation of this embodiment.

[Explanation of symbols]

100 Online terminal 101, 111 Online AP (online application program) 102 Batch AP (batch application program) 200 Transaction log file management file 201
(Transaction log) File name 202 (Transaction log file) Start address 203 (Transaction log file) End address 204 Online (Job transaction log file) Processing status 205 Batch (Job transaction log file) Processing status 206 Control value 300 Transaction log File management table 301
(Transaction log file) File name 302
(Transaction log file) Start address 303 (Transaction log file) End address 304 Control value 305 (Transaction log file) Current address 400 Transaction log file update process 500
Transaction log file modification process 600, 610 Transaction log file address table 601, 611
(Transaction log file address table) Number of entries: 602 (Transaction log file address table)
File name 603 (Transaction log file address table)
Address 700 Transaction log file 701 Record control section 702 Data section

Claims (1)

[Claims] Claim 1: In a system where a batch job processes transaction logs recorded by an online job and generated sequentially, a transaction log in memory that stores the file name address of a transaction log file in which the online job writes the transaction log. When a task that has a file address table and a transaction log file address table completes processing normally, a function that erases the contents of the transaction log file address table and a file name address where the transaction log was written are added to the transaction log file. If an abnormality occurs in a transaction log file update means having a function of writing to an address table and a task having the transaction log file address table, the transaction log file address indicated by the transaction log file address table is updated on the day. transaction log file modifying means having a function of writing records with control; transaction log file reading means having a function of controlling reading processing and reading interruption according to control values in transaction log file records; A transaction log data transfer method comprising a transaction log file to be written, a transaction log file management file to manage the transaction log file, and a transaction log file management table to manage the transaction log file.