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.

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.

Abstract: 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.

Abstract: 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.