Abstract: A method for of accelerating database log hardening using specific per block data protection and damage control is provided. A per write specification is implemented to determine when database log data is mirrored synchronously or asynchronously. Synchronous mirroring is performed upon reaching a predetermined threshold, based on one or more parameters such as transaction value, both individual and cumulative, and the quantity of data written since the last synchronous mirroring. As data is added to the database log, it is written specifying asynchronous mirroring to the primary log file. Once a threshold is met, a write specifying synchronous mirroring is performed to both the primary and secondary log files, thereby hardening the log file in both primary and secondary storage subsystem.

Abstract: A method for of accelerating database log hardening using specific per block data protection and damage control is provided. A per write specification is implemented to determine when database log data is mirrored synchronously or asynchronously. Synchronous mirroring is performed upon reaching a predetermined threshold, based on one or more parameters such as transaction value, both individual and cumulative, and the quantity of data written since the last synchronous mirroring. As data is added to the database log, it is written specifying asynchronous mirroring to the primary log file. Once a threshold is met, a write specifying synchronous mirroring is performed to both the primary and secondary log files, thereby hardening the log file in both primary and secondary storage subsystem.

Abstract: A method for of accelerating database log hardening using specific per block data protection and damage control is provided. A per write specification is implemented to determine when database log data is mirrored synchronously or asynchronously. Synchronous mirroring is performed upon reaching a predetermined threshold, based on one or more parameters such as transaction value, both individual and cumulative, and the quantity of data written since the last synchronous mirroring. As data is added to the database log, it is written specifying asynchronous mirroring to the primary log file. Once a threshold is met, a write specifying synchronous mirroring is performed to both the primary and secondary log files, thereby hardening the log file in both primary and secondary storage subsystem.

Abstract: Methods and systems are provided for tuning memory allocated among a plurality of applications in a data processing system. In one implementation, the method includes generating memory benefit data for the plurality of applications, comparing the generated memory benefit data associated with each of the plurality of applications, and dynamically reallocating memory from one or more of the plurality of applications to one or more other of the plurality of applications based on the comparison. A method and system is also provided for tuning memory allocated among a plurality of individual memory consumers for a given application.

Abstract: A method for of accelerating database log hardening using specific per block data protection and damage control is provided. A per write specification is implemented to determine when database log data is mirrored synchronously or asynchronously. Synchronous minoring is performed upon reaching a predetermined threshold, based on one or more parameters such as transaction value, both individual and cumulative, and the quantity of data written since the last synchronous minoring. As data is added to the database log, it is written specifying asynchronous minoring to the primary log file. Once a threshold is met, a write specifying synchronous minoring is performed to both the primary and secondary log files, thereby hardening the log file in both primary and secondary storage subsystem.

Abstract: Method, device and computer program product for determining a characteristic of an identifiable component. The method includes: receiving identification information representative of an identity of components that belong to a group of components, determining at least one characteristic of an identifiable component in response to the received identification information, and performing at least one characteristic responsive operation. The device includes an identifiable component and a component characteristic determiner. The component characteristic determiner is adapted to receive identification information representative of an identity of components that belong to a group of components and to determine at least one characteristic of the identifiable component in response to a relationship between the received identification information and reference identification information. The device is adapted to perform at least one characteristic responsive information.

Abstract: Two methods (native and clone) are used for installing software, such as an operating system, on client system(s) booting from shared storage. The native installation method configures an interconnection network to create an exclusive communication zone between the client system and the shared storage system and installs the operating system on the client system using the exclusive communication zone. After the software is installed, the method terminates the exclusive communication zone. The clone installation method utilizes a point-in-time copy feature of the shared storage system to clone an operating system drive instantaneously. After the drive is cloned, it is logically attached to a new client and the operating system is customized for that client.

Abstract: A method, system and computer program product for responding to error events are provided. The method includes: detecting a detected error event while executing a computer readable program; looking for a predefined response to the detected error event in a modifiable error event response data structure; validating the modifiable error event response data structure; and responding to the detected error event according to the predefined response if the modifiable error event response data structure is valid and if the modifiable error event response data structure includes the predefined response.

Abstract: Provided are a method, system, and article of manufacture for the traversal of empty regions in a searchable data structure such as a table. A plurality of elements are allocated in logical storage, wherein the plurality of elements correspond to entries of the searchable data structure. An indicator is maintained corresponding to contiguously allocated empty elements in the plurality of elements. An operation is performed on the searchable data structure by avoiding the contiguously allocated empty elements.

Abstract: In an information retrieval system, a query optimization method transforms maximum or minimum function aggregation predicates on a non-indexed column into a single sort function. The method evaluates the query to identify a table and a predicate equating a column of the table to a sub-query that applies a maximum or minimum aggregation function to the column to return an aggregate value for the column. The aggregate value is used for selecting rows from the table to produce a query result. A determination is then made whether an index has not been created using the column of the table. In response to these steps of evaluating and determining, the method reforms the query as a sort function on the column. The sort function scans the table once to provide the query result.

Abstract: A method, system and computer program product for responding to error events are provided. The method includes: detecting a detected error event while executing a computer readable program; looking for a predefined response to the detected error event in a modifiable error event response data structure; validating the modifiable error event response data structure; and responding to the detected error event according to the predefined response if the modifiable error event response data structure is valid and if the modifiable error event response data structure includes the predefined response.

Abstract: Methods and systems are provided to facilitate the optimization process of existing relational database managers when processing complex queries. Specialized constraining clauses are inserted in or added to SQL queries, which do not affect the semantics of the queries. This operation causes the RDBMS to partition the query into sub-queries, and to apply a more efficient optimization for each sub-query. A condition in which the execution time of the modified query substantially exceeds that of the original query may indicate a design flaw in the RDBMS query optimizer.

Abstract: Methods and systems are provided for tuning memory allocated among a plurality of applications in a data processing system. In one implementation, the method includes generating memory benefit data for the plurality of applications, comparing the generated memory benefit data associated with each of the plurality of applications, and dynamically reallocating memory from one or more of the plurality of applications to one or more other of the plurality of applications based on the comparison. A method and system is also provided for tuning memory allocated among a plurality of individual memory consumers for a given application.

Abstract: The invention herein provides method and apparatus for managing attribute-tagged index entries contained in an index by assigning or tagging an index entry attribute indicator to a newly inserted index entry (that is, at the time when a key data value is inserted into the index, the key data value becomes a newly inserted index entry and an attribute indicator is tagged to the newly inserted index entry). The index entry can be placed anywhere within the index. Once a group of attribute-tagged index entries have been inserted into the index, the attribute identifiers can be switched off instantaneously (that is, the attribute associated with the attribute indicators is disabled).

Abstract: Method, device and computer program product for determining a characteristic of an identifiable component. The method includes: receiving identification information representative of an identity of components that belong to a group of components, determining at least one characteristic of an identifiable component in response to the received identification information, and performing at least one characteristic responsive operation. The device includes an identifiable component and a component characteristic determiner. The component characteristic determiner is adapted to receive identification information representative of an identity of components that belong to a group of components and to determine at least one characteristic of the identifiable component in response to a relationship between the received identification information and reference identification information. The device is adapted to perform at least one characteristic responsive information.

Abstract: Provided are a method, system, and article of manufacture for the traversal of empty regions in a searchable data structure such as a table. A plurality of elements are allocated in logical storage, wherein the plurality of elements correspond to entries of the searchable data structure. An indicator is maintained corresponding to contiguously allocated empty elements in the plurality of elements. An operation is performed on the searchable data structure by avoiding the contiguously allocated empty elements.

Abstract: Logging and storage transactions in a database are directed to a single storage server. A modification of a database record is written only once to a log record on the storage server. Subsequently, the storage server interprets the database log records, and modifies the database storage accordingly. The number of bytes written to storage is potentially reduced by fifty percent as compared to writing the log record and then writing the modified database record to the storage server.

Abstract: A method, apparatus and article of manufacture, implementing the method, accesses rows in a range-clustered table in a database management system. A table stores data that is organized into rows and columns. At least one column is designated as a key column. A particular row in the table is accessed based on a relationship between a specified key value and a predetermined range of key values associated with the key column. The table has slots for storing rows, and the slots are organized in accordance with the values of the predetermined range.

Abstract: Two methods (native and clone) are used for installing software, such as an operating system, on client system(s) booting from shared storage. The native installation method configures an interconnection network to create an exclusive communication zone between the client system and the shared storage system and installs the operating system on the client system using the exclusive communication zone. After the software is installed, the method terminates the exclusive communication zone. The clone installation method utilizes a point-in-time copy feature of the shared storage system to clone an operating system drive instantaneously. After the drive is cloned, it is logically attached to a new client and the operating system is customized for that client.

Abstract: The present invention is directed towards a diagnostic system for a database system. The diagnostic system includes a grouping module for assigning a grouping identifier to each query received by the database system; and a statistics collection module. The statistics collection module includes a query processing statistics module for obtaining processing statistics corresponding to each query; a group statistics compilation module for compiling processing statistics for each query by the query's grouping identifier; and group data storage for storing compiled processing statistics. A method is also disclosed for generating database diagnostic data.