Systems and methods for efficient DB2 outage operations

摘要

In one aspect, a computer-implemented method provides more efficient outages for databases. The method may include intercepting a database transaction request prior to connection to the database subsystem and determining whether the transaction will finish before an expected drain time for the database object, the transaction being associated with the database object. The method may also include allowing the transaction to proceed when it is determined that the transaction will finish before the expected drain time and suspending the transaction otherwise. The transaction may be associated with the database object in a table so that only transactions associated with the database object are considered for suspension. In another aspect, the method may include determining which transactions running when a drain for the object is initiated and associating the running transactions with the database object in the table.

主权项

1. A computer system for reduced database outage time comprising:
a database subsystem, the database subsystem having at least one database object; at least one processor; and a memory storing instructions that, when executed by the at least one processor, cause the computer system to perform operations including:
intercepting a transaction prior to connection to the database subsystem,determining whether the transaction will finish before an expected drain time for a database object, the transaction being associated with the database object,allowing the transaction to proceed when it is determined that the transaction will finish before the expected drain time, andsuspending the transaction when it is determined that the transaction will not finish before the expected drain time.