International Business Machines Corporation

Oliver Harm

Knut Stolze

Peter Bendel

Dirk Nakott

Björn Broll

Gunter Schoellmann

The present disclosure relates to executing concurrent database operations in a database system during a time window. The database operations are configured to use storage units of a storage space of the database system. A first usage speed of free storage units is determined to be used by at least one first database operation and a second usage speed of free storage units to be used by a second database operation. The first and second usage speeds may be used for determining a maximum number of free storage units to be used by the second database operation during the time window. The second database operation may be executed during the time window in accordance with the maximum number. The first database operation may be executed, wherein the execution of the first database operation during the time window being limited to the storage units of the storage space.

Concurrent execution of database operations

A method, system, and computer program product for implementing backup history cleanup operations for a database management system are provided. The method includes identifying a version control base (VCB) value for a most recently stored record in a history table, the record representing a back up copy of a data set. The method includes scanning the table starting from most recently stored records to identify records that represent previous backup copies of the data set, the records assigned VCB values. Using a retention limit value assigned to each of the VCBs, the method includes selecting at least one record to determine the deletion date for use in implementing the cleanup operations. The selection includes counting the number of records, representing back up copies of the data set, for each VCB value; identifying last records for respective VCBs that do not exceed the retention limit value; selecting the oldest storage date among the last records; and deleting records that have storage dates older than the oldest storage date.

Growing community of inventors

Stuttgart, Germany

Oliver Harm