International Business Machines Corporation

Kyndryl, Inc.

Chandan Kumar Vishwakarma

Pavithrananda S Prabhu

Sriram Lakshminarasimhan

Prasanna Veeraraghavan

Sundar Sarangarajan

A computer-implemented method of optimizing data rollback is disclosed. The method receives a request to perform a task on a disk storage. The method initiates the task by reading a plurality of data pages from the disk storage to a database buffer. Each of the plurality of data pages on the database buffer are modified to form a plurality of dirty pages. In response to reaching and/or exceeding a database buffer threshold, a portion of the plurality of dirty pages on the database buffer are externalized to a rollback buffer. In response to reaching and/or exceeding a rollback buffer threshold, a subset of the portion of the plurality of dirty pages on the rollback buffer are externalized to the disk storage. The method detects a task cancelling activity prior to completion of the task; and performs a rollback of the plurality of dirty pages to a pre-task state.

System and method of optimizing rollbacks

A method for preventing suspension of transactions in a database computing system by monitoring active database logs of the database computing system is provided. The method comprises switching archive units of the database computing system due to full database log condition occurring during system operations of the database computing system. The method further comprises maintaining a database log history table, wherein the database log history table captures a threshold count of the active database logs generated by system threads of the database computing system. The method further comprises defining a temporary location for archiving the active database logs based on the switched archive units of the database computing system, and the maintained threadhold count of active database logs in the database log history table due to full database log condition occurring during system operations of the database computing system.

Growing community of inventors

Hazaribagh, India

Chandan Kumar Vishwakarma