# US 6,732,137 B1 · Performance optimization for data sharing across batch sequential processes and on-line transaction processes

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 6,732,137 B1
- Document ID: US6732137B1
- Status: Granted
- Kind: B1
- Application number: 09/311,204
- Filed: 1999-05-12
- Granted: 2004-05-04
- Earliest claimed: 1999-05-12
- Assignees: International Business Machines Corporation
- Inventors: Gerard MacLean Dearing; Kenneth Michael Kapulka; Jimmy Paul Strickland
- Web page: https://patentgrep.com/patent/US6732137B1

## CPC

- G06F 9/466: {Transaction processing}
- G06F 9/526: {Mutual exclusion algorithms}
- G06F 2209/523: Mode
- Y10S 707/99938: Concurrency, e.g. lock management in shared database
- Y10S 707/99952: Coherency, e.g. same view to multiple users
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## Abstract

Aspects for data sharing across batch sequential processes and on-line transactional processes in a clustered arrangement of multiple data processing systems are described. In a method aspect, the method includes performing on-line transaction process accesses and batch sequential process accesses on record data. The method further includes utilizing a dual-level locking protocol for the on-line transaction process accesses and batch sequential process accesses to achieve substantially concurrent accessibility to the record data with minimized processing overhead for the batch sequential processes.

## Claims

### Claim 1

A method for data sharing across batch sequential processes and on-line transactional processes in a clustered arrangement of multiple data processing systems, the method comprising:
performing on-line transaction process accesses and batch sequential process accesses on record data; and
utilizing a dual-level locking protocol for the on-line transaction process accesses and batch sequential process accesses to achieve substantially concurrent accessibility to the record data with minimized processing overhead for the batch sequential processes, including utilizing a first level locking protocol for an on-line transaction process accessing a file, determining if a batch sequential process is accessing a file, and transitioning to a second level locking protocol when a batch sequential process is accessing a file.

### Claim 2 (depends on 1)

The method of claim 1 wherein utilizing a first level locking protocol further comprises obtaining record locks in a SHARE or EXCLUSIVE state.

### Claim 3 (depends on 1)

The method of claim 1 wherein transitioning to a second level locking protocol further comprises obtaining a control area lock in a first state for transaction requests in addition to record locks.

### Claim 4 (depends on 3)

The method of claim 3 wherein the first state further comprises a TRANSACTION_SHARED state.

### Claim 5 (depends on 4)

The method of claim 4 wherein transitioning to a second level locking protocol further comprises obtaining a control area lock in a second state for the batch sequential process.

### Claim 6 (depends on 5)

The method of claim 5 wherein the second state further comprises a BATCH_EXCLUSIVE state.

### Claim 7

A system for data sharing across batch sequential processes and on-line transactional processes, the system comprising:
a plurality of direct access storage devices (DASDs) for storing record data;
a plurality of data processing systems coupled to the plurality of DASDs in a clustered system arrangement, wherein batch sequential process accesses and on-line transaction process accesses occur substantially concurrently to the record data by the plurality of data processing systems through utilization of a dual-level locking protocol for the on-line transaction process accesses and batch sequential process accesses with minimized overhead for the batch sequential process accesses, including utilizing a first level locking protocol for an on-line transaction process accessing a file, the first level locking protocol including obtaining record locks in a SHARE or EXCLUSIVE state, determining if a batch sequential process is accessing a file, and transitioning to a second level locking on a protocol when a batch sequential process is accessing a file.

### Claim 8 (depends on 7)

The system of claim 7 wherein transitioning to a second level locking protocol further comprises obtaining a control area lock in a first state for transaction requests in addition to record locks.

### Claim 9 (depends on 8)

The system of claim 8 wherein the first state further comprises a TRANSACTION_SHARED state.

### Claim 10 (depends on 9)

The system of claim 9 wherein transitioning to a second level locking protocol further comprises obtaining a control area lock in a second state for the batch sequential process.

### Claim 11 (depends on 10)

The system of claim 10 wherein the second state further comprises a BATCH_EXCLUSIVE state.
