Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Archival management of database logs

A database and log technology, applied in the field of database log archive management, can solve problems such as inability to trim logs, log size increases, and data deletion.

Active Publication Date: 2015-04-15
KYNDRYL INC
View PDF3 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, long-running UOWs prevent this mechanism from working until such UOW has completed and its log data is no longer needed, its data cannot be deleted from the log, and all entries since the UOW's first log entry All data recorded must be kept on a logbook
Therefore, the system will not be able to trim the log after the key point indication, and the size of the log will keep growing
Eventually, when a critical threshold of the logging subsystem, operating system, or available hardware is exceeded, this causes requests to write to the log to fail due to an "out of space" type condition

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Archival management of database logs
  • Archival management of database logs
  • Archival management of database logs

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The present invention will now be described in detail with reference to the drawings. Reference now figure 1 , Which shows a DBMS environment for archiving the active database log of the DBMS computing environment 100 (including, for example, preventing the transaction suspension of the active database log, thus ensuring that the active database log is available to the database system for processing in the DBMS computing environment 100) 100. The database system can be Is a relational model database server (RDBMS), which is suitable for serving various operating systems, including for example or Operating system platform.

[0018] According to aspects of the present invention, database operation activities performed by a database system are typically maintained by an activity database log, where the storage of the activity database log is utilized by the database system to recover from operational failures of the DBMS computing environment 100. The database log is a ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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.

Description

Technical field [0001] The present invention generally relates to database operation activities of a database computing system, and more particularly relates to archive management of database logs of a database computing system. Background technique [0002] A transaction (sometimes called a "unit of work" or "UOW") is a group of related operations that must be completed together. All recoverable actions of the related operations must be completed successfully or not executed at all. This characteristic of transactions is called "atomicity." In the simplest case, the transaction will access resources connected to a single computer processor. Such transactions are called "local transactions". However, more generally, transactions will access resources located in several different computer processors or logical partitions, each containing its own transaction log. Such transactions are called "distributed transactions". When the distributed transaction ends, the atomicity of th...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30073G06F16/113G06F16/1734G06F16/219G06F16/2358G06F16/21
Inventor P·S·普拉布C·K·维什瓦卡玛
Owner KYNDRYL INC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com