# US 2015/0178121 A1 · Replication of batch jobs of computing systems

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

- Number: US 2015/0178121 A1
- Document ID: US20150178121A1
- Status: Published application
- Kind: A1
- Application number: 14/134,002
- Filed: 2013-12-19
- Published: 2015-06-25
- Earliest claimed: 2013-12-19
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: James D. Spyker
- Web page: https://patentgrep.com/patent/US20150178121A1

## CPC

- G06F 9/466: {Transaction processing}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method for replicating the effect of batch jobs using a replication agent is provided. The method comprises a replicating agent maintaining a maximum level in rows and a minimum level in rows for one or more columns in a database table of one or more database systems. The replicating agent further analyzes a mapping defined in the replicating agent to identify source columns of a source database system of the one or more database systems which are mapped to a target column of a target database system of the one or more database systems. According to at least one embodiment, the replicating agent further identifies a logical clause of the source database system and the target database system to define a range refresh. The replication agent further initiates the defined range refresh.

## Claims

### Claim 1

A computer-implemented method for replicating the effect of batch jobs using a replication agent, the computer-implemented method comprising:
a replicating agent maintaining, by one or more computer processors, a maximum level in rows and a minimum level in rows for one or more columns in a database table of one or more database systems;
the replicating agent analyzing, by the one or more processors, a mapping defined in the replicating agent to identify source columns of a source database system of the one or more database systems which are mapped to a target column of a target database system of the one or more database systems;
the replicating agent identifying, by the one or more processors, a logical clause of the source database system and the target database system to define a range refresh; and
the replication agent initiating, by the one or more processors, the defined range refresh.

### Claim 2 (depends on 1)

The computer-implemented method according to claim 1, wherein the maximum level in rows and the minimum level in rows are separately maintained for each one of the one or more columns of the database table.

### Claim 3 (depends on 2)

The computer-implemented method according to claim 2, wherein the one or more columns are orderable columns of the database table.

### Claim 4 (depends on 3)

The computer-implemented method according to claim 3, wherein the orderable column is utilized by a logical clause, wherein the logical clause is a WHERE clause, and wherein the WHERE clause includes logical operators.

### Claim 5 (depends on 1)

The computer-implemented method according to claim 1, wherein the replication agent maintains the maximum level in rows and the minimum level in rows changed by batch jobs of a batch operating system of the one or more database systems.

### Claim 6 (depends on 1)

The computer-implemented method according to claim 1, wherein the defined range refresh includes all rows of both the source database system and the target database system that are affected by batch jobs of a batch operating system of the one or more database systems.

### Claim 7 (depends on 1)

The computer-implemented method according to claim 1, wherein the initiated defined refresh range includes a cleanup of the target database system.

### Claim at position 8

8-20. (canceled)
