International Business Machines Corporation

Vasu Gajendran

Suryanarayana K Rao

Ramesh Chandra Pathak

Sriram Lakshminarasimhan

Savitha Joshi

Maya Anilson

Abhilash Divakaran Pillai

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.

Optimizing online schema processing for busy database objects

An approach is provided where a put request is received to put a data entry into a queue. A detection is made that a primary queue data structure corresponding to the queue is damaged. If an alternate queue data structure corresponding to the queue has not yet been created, then the alternate queue data structure is dynamically created. The data entry is then stored in the alternate queue data structure.

Circumventing queue downtime in a queue damage scenario

Growing community of inventors

Indiranagar, India

Vasu Gajendran