JPH03282847A - Method for preventing double update for master file update processing re-execution - Google Patents

Method for preventing double update for master file update processing re-execution

Info

Publication number
JPH03282847A
JPH03282847A JP2084117A JP8411790A JPH03282847A JP H03282847 A JPH03282847 A JP H03282847A JP 2084117 A JP2084117 A JP 2084117A JP 8411790 A JP8411790 A JP 8411790A JP H03282847 A JPH03282847 A JP H03282847A
Authority
JP
Japan
Prior art keywords
update
master file
execution
transaction data
processing
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
JP2084117A
Other languages
Japanese (ja)
Inventor
Noriyuki Saito
斉藤 則行
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
NEC Corp
Original Assignee
NEC Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by NEC Corp filed Critical NEC Corp
Priority to JP2084117A priority Critical patent/JPH03282847A/en
Publication of JPH03282847A publication Critical patent/JPH03282847A/en
Pending legal-status Critical Current

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

PURPOSE:To prevent double update for re-execution of master file update processing in the case of machine down or the like by checking whether the update processing of master data is executed or not. CONSTITUTION:Update AP information (a) is peculiar to each of business APs whose execution order can be discriminated, and a transaction data group number (n) is sequentially given to each of transaction data processed by execution of one business AP. When data of the master file is updated, udpate execution AP information of the master file and the update transaction data group number are substituted with the update AP information (a) and the transaction data group number respectively. That is, information of update execution processing and transaction data are given on the master file, and information of execution processing and transaction data is checked. Thus, double update of the master file is prevented, and it is unnecessary to generate a backup file of the master file before the processing.

Description

【発明の詳細な説明】 〔産業上の利用分野〕 本発明は、複数のトランザクション・データが同一のマ
スタ・ファイル上のデータを更新する事が無い様な業務
処理に関し、特に、マシンタウンなどの時に、処理の再
実行する際のマスタ・ファイルの二重更新の防止方法に
関する。
[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to business processing in which multiple pieces of transaction data do not update data in the same master file, and in particular, in a machine town or the like. The present invention also relates to a method for preventing double updates of a master file when processing is re-executed.

〔従来の技術〕[Conventional technology]

従来、この種の障害に対しては、マスタ・ファイルを処
理前の状態に戻してから再実行する方法となっていた。
Conventionally, the method for dealing with this type of failure was to return the master file to its pre-processing state and then re-execute the process.

〔発明が解決しようとする課題〕[Problem to be solved by the invention]

上述した従来の方法は、マスタ・ファイルを処理前の状
態に戻し再実行するとなっているので、処理前のマスタ
・ファイルのバックアップを作成する必要があり、また
処理前の状態にマスタ・ファイルを戻す必要があるとい
う欠点がある。
In the conventional method described above, the master file is returned to its pre-processing state and re-executed, so it is necessary to create a backup of the pre-processed master file, and it is also necessary to restore the master file to its pre-processed state. The drawback is that it needs to be returned.

〔課題を解決するための手段〕[Means to solve the problem]

本発明のマスタ・ファイル更新処理時の二重更新の防止
方法の構成は、マスタ・ファイルの各々のデータを更新
するためのトランザクション・データが、高高1個しか
存在しない情処処理システムにおいて、マスタ・データ
の更新処理が、実行されたかチェックする事で、マシン
ダウン等の際、マスタ・ファイル更新処理の再実行時の
二重更新の防止を可能とすることを特徴とする。
The configuration of the method for preventing double updates during master file update processing according to the present invention is such that in an information processing system where there is only one piece of transaction data for updating each data in a master file, By checking whether the master data update process has been executed, it is possible to prevent double updates when the master file update process is re-executed in the event of a machine failure or the like.

〔実施例〕〔Example〕

次に、本発明について図面を参照して説明する。 Next, the present invention will be explained with reference to the drawings.

第1図は本発明の一実施例の全体構成図である。FIG. 1 is an overall configuration diagram of an embodiment of the present invention.

更新AP情報イは、業務APの実行順序が判別可能な業
務AP毎に、個有の情報とし、また、トランザクション
データグループ番号nは、1回の業務APの実行で処理
されるトランザクション・データ毎に、順に付番した情
報とし、マスタ・ファイルのデータを更新した時に、マ
スタ・ファイルの更新実施AP情報、更新トランザクシ
ョンデータグループ番号を、各々、更新AP情報イ、ト
ランザクションデータグループ番号で置き換えを行なう
The updated AP information a is unique information for each business AP whose execution order can be determined, and the transaction data group number n is unique information for each transaction data processed by one execution of the business AP. When the master file data is updated, the update implementation AP information and update transaction data group number in the master file are replaced with the update AP information and transaction data group number, respectively. .

第2図はマスタ・ファイルを更新するか否かのチェック
方法の処理フローである。
FIG. 2 is a processing flow of a method for checking whether or not to update a master file.

〔発明の効果〕〔Effect of the invention〕

以上説明したように本発明は、マスタ・ファイル上に、
更新を実施した処理、トランザクション・データの情報
を持たせ、実行する処理、トランザクション・データの
情報をチェックする事で、マスタ・ファイルの二重更新
を防止する事が可能となり、処理前のマスタ・ファイル
のバックアップを作成しておく必要がなくなり、また、
再処理時にマスクを処理前の状態に戻す事を省略できる
という効果がある。
As explained above, the present invention has the following advantages:
By having information on the updated process and transaction data, and checking the information on the process to be executed and transaction data, it is possible to prevent double updates of the master file, and the master file before processing can be checked. You no longer need to back up your files, and
This has the effect that it is possible to omit returning the mask to its pre-processing state during reprocessing.

【図面の簡単な説明】[Brief explanation of drawings]

第1図は本発明の一実施例の全体構成図、第2図は第1
図の機能の処理フローである。
FIG. 1 is an overall configuration diagram of an embodiment of the present invention, and FIG.
It is a processing flow of the function shown in the figure.

Claims (1)

【特許請求の範囲】[Claims] マスタ・ファイルの各々のデータを更新するためのトラ
ンザクション・データが、高高1個しか存在しない情処
処理システムにおいて、マスタ・データの更新処理が、
実行されたかチェックする事で、マシンダウン等の際、
マスタ・ファイル更新処理の再実行時の二重更新の防止
を可能とすることを特徴とするマスタ・ファイル更新処
理再実行時の二重更新の防止方法。
In an information processing system where there is only one piece of transaction data for updating each data in the master file, the master data update process is
By checking whether it has been executed, when the machine goes down, etc.
A method for preventing double updates when re-executing master file update processing, characterized in that it is possible to prevent double updates when re-executing master file update processing.
JP2084117A 1990-03-30 1990-03-30 Method for preventing double update for master file update processing re-execution Pending JPH03282847A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2084117A JPH03282847A (en) 1990-03-30 1990-03-30 Method for preventing double update for master file update processing re-execution

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP2084117A JPH03282847A (en) 1990-03-30 1990-03-30 Method for preventing double update for master file update processing re-execution

Publications (1)

Publication Number Publication Date
JPH03282847A true JPH03282847A (en) 1991-12-13

Family

ID=13821577

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2084117A Pending JPH03282847A (en) 1990-03-30 1990-03-30 Method for preventing double update for master file update processing re-execution

Country Status (1)

Country Link
JP (1) JPH03282847A (en)

Similar Documents

Publication Publication Date Title
CN100440155C (en) Method and apparatus for creating a virtual data copy
JP3052908B2 (en) Transaction program parallel execution method and transaction program parallel execution method
JPH04139544A (en) Data restoring method
CN111143323A (en) MPP database management method, device and system
JPH03282847A (en) Method for preventing double update for master file update processing re-execution
CN111240891A (en) Data recovery method and device based on data consistency among multiple tables of database
CN113986941A (en) Transaction batch processing method and device
US5615371A (en) Debug processing system for user programs
CN110765144B (en) Distributed heterogeneous database data processing method and device
JPH1153239A (en) Rollback processing method for database and recording medium recorded with procedure thereof
CN107967275B (en) Data processing method and device in relational database
JPH08292884A (en) Repository device
JP2972223B2 (en) Rollback method for sequential files without journal
JPH0512087A (en) System for outputting pre-updating journal
JPH0448333A (en) Automatic control shift system after roll-back
JPH04302337A (en) Rerun countermeasure in abort of update processing
JPH02211557A (en) Data base saving system
JPH01214947A (en) Data preserving system
JPH06332856A (en) On-line job processing system
WO1999008209A1 (en) High performance asynchronous data replication
JPH03105625A (en) Reserving/restoring system for intermediate language
JPH05233546A (en) Logical recovery method
JPS6310251A (en) Control system for record indicator
JPH03233634A (en) Job reprocessing system
JPH05225026A (en) Fault recovery system