International Business Machines Corporation

Randall William Horman

Stephen Andrew Brodsky

Paul Arnold Ostler

Anshul Dawra

Vijay R Bommireddipalli

Sam Sampson Lightstone

Mark Francis Wilding

Tony Leung

Holger Karn

Kevin Michael McBride

Gary Valentin

Tony Kai-chi Leung

Bernhard K Schiefer

Matthew Wayne Novak

David Wei-Jye Chang

Peter Wansch

Robin D Van Boeschoten

Said Elnaffar

Pat Martin

Yongchun Zhu

Megan Elena Bock

According to one embodiment of the present invention, a system enables control of database applications. The system comprises a computer system including a database application to provide access to a database system, and at least one processor. The computer system requests retrieval of application specific property information for the database application from a data repository, and applies the retrieved application specific property information to the database application to control operation of the database application. Embodiments of the present invention further include a method and computer program product for controlling database applications in substantially the same manner described above.

Method and system for centralized control of database applications

A method and apparatus for directing a client to establish a secure connection with a server across a public network. The server and the client exchange a Server Authentication Public Key, a Client Authentication Public Key, and a Remote Service Unique Identifier (RSUID) during a registration process. In one embodiment, the method includes the client transmitting to the server a client information package having the RSUID and a client challenge information package encrypted with the Server Authentication Public Key, the client receiving from the server a server information package having the RSUID and a server challenge information package and a portion of the received client challenge information encrypted with the Client Authentication Public Key, the client decrypting and verifying the server challenge information package with the Client Authentication Private Key, and, the client transmitting to the server an encrypted portion of the received client challenge information.

System and method for secure remote access

Embodiments of the invention provide techniques for troubleshooting of computer systems using a fault tree analysis. In one embodiment, data parameters describing a status of a system may be monitored to determine the existence of a fault. In the event of a fault, fault tree analysis metadata may be evaluated to attempt to determine a root cause of the fault. If a root cause can be automatically determined, it may be presented to a user in a troubleshooting console, or may be used to trigger an automated corrective action. Alternatively, if a root cause cannot be automatically determined, the user may be presented with additional fault tree analysis metadata and any relevant data parameters in the troubleshooting console, so that the user may determine the root cause of the fault event.

Collaborative troubleshooting computer systems using fault tree analysis

Workload type to be managed by a database management system (DBMS) is a key consideration in tuning the DBMS. Allocations for resources, such as main memory, can be very different depending on whether the workload type is Online Transaction Processing (OLTP) or Decision Support System (DSS). The DBMS also experiences changes in workload type during the normal processing cycle of the DBMS. It would be preferable for the database administrators to recognize the significant shifts of workload type that demand reconfiguring the DBMS to maintain acceptable levels of performance. Disclosed is a workload type classifier module, used by a DBMS, for recognizing workload types so that the DBMS may then manage or adjust its performance and reconfigure its resources accordingly. The classifier may be constructed based on the most significant workload characteristics that differentiate OLTP from DSS. The classifier is then used for identifying changes in workload types contained in a workload.

Method for identifying a workload type for a given workload of database requests

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.

Database diagnostic system and method

The invention provides method and apparatus for an improved data processing system having an administrative control server; an administrative control database, connected to said administrative control server; and at least one group of servers having similar, but not necessarily identical, configurations adapted for communication with the administrative control server for administrative control thereby, in which the control server can change the configurations of the administered servers to a new desired configuration for each administered server where the new configuration is in synchronization with the configuration of each of said other administered server, by generating synchronization instructions from parameterized synchronization scripts stored in the control database.

Method and apparatus for simplified administration of large numbers of similar information handling servers

The invention provides a method and apparatus for use in an information handling network having an administrative control server and a number of administered servers that are members of the network and are managed by the control server, of providing maintenance of the administered servers for maintaining conformity of configuration of each of the administered servers to a predetermined configuration for all administered servers of the network while permitting evolution of the predetermined configuration from an initial network member configuration to a current network member configuration to which each of the administered servers is to conform, the method including: evolving, as required, the configuration of each server from its current configuration state to the current network member configuration in the following steps: initiating communication, by an administered server, of identification information to the control server identifying the administered server; verifying by the control server whether the administered server is a member of the network managed by the control server, and if it is so managed, then; determining by the control server whether the administered server configuration requires evolution to the current network member configuration; and, if evolution is required by the administered server, then the control server determines what commands are required to evolve the administered server configuration to the current network member configuration; the control server communicates the required commands to the administered server; the administered server executes the required commands to evolve its configuration to the current network member configuration; and the administered server communicates results of the execution of the commands to the control server identifying whether its configuration was successfully evolved to the current network member configuration.

Method and apparatus for maintaining consistency among large numbers of similarly configured information handling servers

Growing community of inventors

Toronto, Canada

Randall William Horman