Abstract: A method for creating a standby database with read/write access capability while also maintaining a data consistency with a primary database, is provided. The method includes syncing the primary database with a physical standby mirror existing on the standby database, creating a first data compartment and a second data compartment on the standby database, separate from the physical standby mirror, applying a change made to the first data object on the primary database to the corresponding first data object on the physical standby mirror; and determining whether the change should be applied to the corresponding first data object stored on the first data compartment in accordance with data merge rules associated with the first data compartment and the second data compartment.

Abstract: A database is identified, wherein the database has two or more tablespaces. A local partition and a global partition for each tablespace of the two or more tablespaces is created, wherein the created two or more global partitions are included in a global storage pool. A request to move an object to a first local partition of a first tablespace of the two or more tablespaces is received. That an amount of used space of the first local partition is above a first threshold is determined. Responsive to determining that the amount of used space of the first local partition is above the first threshold, at least a portion of the object is stored in the global storage pool.

Abstract: A method for creating a standby database with read/write access capability while also maintaining a data consistency with a primary database, is provided. The method includes syncing the primary database with a physical standby mirror existing on the standby database, creating a first data compartment and a second data compartment on the standby database, separate from the physical standby mirror, applying a change made to the first data object on the primary database to the corresponding first data object on the physical standby mirror; and determining whether the change should be applied to the corresponding first data object stored on the first data compartment in accordance with data merge rules associated with the first data compartment and the second data compartment.

Abstract: A method for creating a standby database with read/write access capability while also maintaining a data consistency with a primary database, is provided. The method includes syncing the primary database with a physical standby mirror existing on the standby database, creating a first data compartment and a second data compartment on the standby database, separate from the physical standby mirror, applying a change made to the first data object on the primary database to the corresponding first data object on the physical standby mirror; and determining whether the change should be applied to the corresponding first data object stored on the first data compartment in accordance with data merge rules associated with the first data compartment and the second data compartment.

Abstract: An approach to generating an application prototype. The approach parses ASCII text-based requirements into a collection of sentences and parses the collection of sentences into collections words associated with the collection of sentences. The approach then uses an ASCII dictionary to determine the nouns and verbs found in the collections of words marking the nouns as entities and the verbs as responsibilities. Further, the approach determines if nouns are shared among the collection of sentences and if they are, then records relationships between the sentences. The approach then generates metadata describing these components and generates byte code based on the metadata. The approach packages the byte code, other data relating to the entry point and type of prototype application, e.g., web-based or standalone and an encryption module for distribution.

Abstract: A dynamic cache engine designed to perform advanced, dynamic, application-specific data caching, based on multiple application and user parameters included in client requests that are sent to a server.

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: A method for creating a standby database with read/write access capability while also maintaining a data consistency with a primary database, is provided. The method includes syncing the primary database with a physical standby mirror existing on the standby database, creating a first data compartment and a second data compartment on the standby database, separate from the physical standby mirror, applying a change made to the first data object on the primary database to the corresponding first data object on the physical standby mirror; and determining whether the change should be applied to the corresponding first data object stored on the first data compartment in accordance with data merge rules associated with the first data compartment and the second data compartment.

Abstract: A database is identified, wherein the database has two or more tablespaces. A local partition and a global partition for each tablespace of the two or more tablespaces is created, wherein the created two or more global partitions are included in a global storage pool. A request to move an object to a first local partition of a first tablespace of the two or more tablespaces is received. That an amount of used space of the first local partition is above a first threshold is determined. Responsive to determining that the amount of used space of the first local partition is above the first threshold, at least a portion of the object is stored in the global storage pool.

Abstract: A database is identified, wherein the database has two or more tablespaces. A local partition and a global partition for each tablespace of the two or more tablespaces is created, wherein the created two or more global partitions are included in a global storage pool. A request to move an object to a first local partition of a first tablespace of the two or more tablespaces is received. That an amount of used space of the first local partition is above a first threshold is determined. Responsive to determining that the amount of used space of the first local partition is above the first threshold, at least a portion of the object is stored in the global storage pool.

Abstract: A dynamic cache engine designed to perform advanced, dynamic, application-specific data caching, based on multiple application and user parameters included in client requests that are sent to a server.

Abstract: An approach to generating an application prototype. The approach parses ASCII text-based requirements into a collection of sentences and parses the collection of sentences into collections words associated with the collection of sentences. The approach then uses an ASCII dictionary to determine the nouns and verbs found in the collections of words marking the nouns as entities and the verbs as responsibilities. Further, the approach determines if nouns are shared among the collection of sentences and if they are, then records relationships between the sentences. The approach then generates metadata describing these components and generates byte code based on the metadata. The approach packages the byte code, other data relating to the entry point and type of prototype application, e.g., web-based or standalone and an encryption module for distribution.

Abstract: A computer-implemented method, system, and/or computer program product optimizes storage space usage. One or more processor, which implement a Smart Volume Manager, receive an input/output (I/O) client process that requests an I/O action from a file system storage device. In response to determining that the file system storage device is operating at 100% capacity, the Smart Volume Manager generates a dynamic virtual buffer disk group from multiple donor disk groups, and then redirects the I/O client process to the dynamic virtual buffer disk group, which is appended to the file system storage device to create an extended filesystem volume.

Abstract: A computer-implemented method, system, and/or computer program product optimizes storage space usage. One or more processor, which implement a Smart Volume Manager, receive an input/output (I/O) client process that requests an I/O action from a file system storage device. In response to determining that the file system storage device is operating at 100% capacity, the Smart Volume Manager generates a dynamic virtual buffer disk group from multiple donor disk groups, and then redirects the I/O client process to the dynamic virtual buffer disk group, which is appended to the file system storage device to create an extended filesystem volume.

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: A database is identified, wherein the database has two or more tablespaces. A local partition and a global partition for each tablespace of the two or more tablespaces is created, wherein the created two or more global partitions are included in a global storage pool. A request to move an object to a first local partition of a first tablespace of the two or more tablespaces is received. That an amount of used space of the first local partition is above a first threshold is determined. Responsive to determining that the amount of used space of the first local partition is above the first threshold, at least a portion of the object is stored in the global storage pool.