The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 28, 2019
Filed:
Aug. 10, 2015
International Business Machines Corporation, Armonk, NY (US);
Vasu Gajendran, Indiranagar, IN;
Sriram Lakshminarasimhan, Chennai, IN;
Ramesh C. Pathak, Bangalore, IN;
Suryanarayana K. Rao, Bangalore, IN;
International Business Machines Corporation, Armonk, NY (US);
Abstract
An approach is provided for managing a reorganization of a database object. Because a reorganization utility cannot acquire exclusive access to the object to complete the reorganization, determinations are made: an amount of transaction log records corresponding to active units of work using the database object is determined to be less than a first threshold; a sum of costs of SQL statements executed in the units of work is determined to be less than a second threshold; and a priority of the reorganization is determined to indicate a greatest priority among multiple priorities. Based on the determinations, (1) a reorganization lock providing exclusive access to the database object is acquired, (2) process(es) holding lock(s) on the database object experience a lockout error, a rollback of the process(es) is issued, and the lock(s) are released, and (3) the utility completes the reorganization based on the lock(s) being released.