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 and associated systems for synchronizing a disaster-recovery system of a database. A processor identifies transactions that affect data blocks of a database and records each change in a vector form. For each block, the processor determines a more efficient way to communicate changes made to the block by a subset of the identified transactions. If fewer resources are needed to communicate an updated image of the entire changed block than would be needed to instead communicate a related set of change vectors that identify changes made to the block by the subset of transactions, then the processor communicates the updated image to the disaster-recovery system. Otherwise, the processor instead communicates the related change vectors to the disaster-recovery system. The processor repeats these determinations and communications for each block of the database that was changed by an identified transaction.

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 method and associated system for improving the operation of an optimizer module of a database-management system. A processor of a computer system captures and stores information about the database's recent transactions, where the captured information describes how each transaction altered the logical description of the database or revised data stored in the database. The processor uses this captured information to update stored metadata that identifies the database's logical structure, and to further update stored database statistics that describe characteristics of the data stored in the database. These updated statistics are then returned to the production database's optimizer module, which uses them to determine how to efficiently respond to database-access requests.

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 method and associated systems for synchronizing a disaster-recovery system of a database. A processor identifies transactions that affect data blocks of a database and records each change in a vector form. For each block, the processor determines a more efficient way to communicate changes made to the block by a subset of the identified transactions. If fewer resources are needed to communicate an updated image of the entire changed block than would be needed to instead communicate a related set of change vectors that identify changes made to the block by the subset of transactions, then the processor communicates the updated image to the disaster-recovery system. Otherwise, the processor instead communicates the related change vectors to the disaster-recovery system. The processor repeats these determinations and communications for each block of the database that was changed by an identified transaction.

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 and associated systems for synchronizing a disaster-recovery system of a database. A processor identifies transactions that affect data blocks of a database and records each change in a vector form. For each block, the processor determines a more efficient way to communicate changes made to the block by a subset of the identified transactions. If fewer resources are needed to communicate an updated image of the entire changed block than would be needed to instead communicate a related set of change vectors that identify changes made to the block by the subset of transactions, then the processor communicates the updated image to the disaster-recovery system. Otherwise, the processor instead communicates the related change vectors to the disaster-recovery system. The processor repeats these determinations and communications for each block of the database that was changed by an identified transaction.

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.