US 12,093,139 B2
Rolling back a database transaction
Karl Fleckenstein, Malsch (DE); Jens Peter Seifert, Gaertringen (DE); Hans-Jürgen Zeltwanger, Weinsberg (DE); Thomas Rech, Rittersheim (DE); Dirk Nakott, Stuttgart (DE); Holger Hellmuth, Bensheim (DE); Alexander Zietlow, Sandhausen (DE); and Martin Jungfer, Ostelsheim (DE)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Dec. 16, 2021, as Appl. No. 17/644,569.
Prior Publication US 2023/0195582 A1, Jun. 22, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 11/14 (2006.01); G06F 16/23 (2019.01)
CPC G06F 11/1469 (2013.01) [G06F 16/2379 (2019.01); G06F 2201/84 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
executing a database transaction using a database management system;
configuring the database management system to store logged changes of the database management system in an active log occupying an active log space, wherein the database management system is configured to log actions of the database transaction in the active log and to reserve a log space in the active log space for enabling a rollback of the database transaction;
receiving an indication that the rollback of the database transaction is to be performed; and
rolling back by the database management system the database transaction, by truncating one selected from the group consisting of: a database table, and a created index.