Invention Grant
- Patent Title: Archival management of database logs
-
Application No.: US15060640Application Date: 2016-03-04
-
Publication No.: US09886439B2Publication Date: 2018-02-06
- Inventor: Pavithrananda S. Prabhu , Chandan K. Vishwakarma
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Michael O'Keefe
- Main IPC: G06F17/00
- IPC: G06F17/00 ; G06F17/30

Abstract:
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.
Public/Granted literature
- US20160188611A1 ARCHIVAL MANAGEMENT OF DATABASE LOGS Public/Granted day:2016-06-30
Information query