Abstract: A method, system and computer program product for providing support for identification of the problem root cause in a computing system. Knowledge base mapping monitoring programs with respective to one or more technical problem definitions and a predefined system configuration are provided. The technical problems are defined using a predefined data structure. An inquiry relating to the computing system is received from a requester. The inquiry indicates a technical problem statement of the computing system. The received inquiry is parsed for constructing a problem description in accordance with the predefined data structure. A set of monitoring programs of the knowledge base may be identified using the problem description. Using software and/or hardware configuration data of the computing system, the set of monitoring programs may be instantiated in a monitor system. The instantiated programs may be provided to the requester as support for identification of the problem root cause.

Abstract: A method, system and computer program product for providing support for identification of the problem root cause in a computing system. Knowledge base mapping monitoring programs with respective to one or more technical problem definitions and a predefined system configuration are provided. The technical problems are defined using a predefined data structure. An inquiry relating to the computing system is received from a requester. The inquiry indicates a technical problem statement of the computing system. The received inquiry is parsed for constructing a problem description in accordance with the predefined data structure. A set of monitoring programs of the knowledge base may be identified using the problem description. Using software and/or hardware configuration data of the computing system, the set of monitoring programs may be instantiated in a monitor system. The instantiated programs may be provided to the requester as support for identification of the problem root cause.

Abstract: A method, system and computer program product for providing support for identification of the problem root cause in a computing system. Knowledge base mapping monitoring programs with respective to one or more technical problem definitions and a predefined system configuration are provided. The technical problems are defined using a predefined data structure. An inquiry relating to the computing system is received from a requester. The inquiry indicates a technical problem statement of the computing system. The received inquiry is parsed for constructing a problem description in accordance with the predefined data structure. A set of monitoring programs of the knowledge base may be identified using the problem description. Using software and/or hardware configuration data of the computing system, the set of monitoring programs may be instantiated in a monitor system. The instantiated programs may be provided to the requester as support for identification of the problem root cause.

Abstract: A method, system and computer program product for providing support for identification of the problem root cause in a computing system. Knowledge base mapping monitoring programs with respective to one or more technical problem definitions and a predefined system configuration are provided. The technical problems are defined using a predefined data structure. An inquiry relating to the computing system is received from a requester. The inquiry indicates a technical problem statement of the computing system. The received inquiry is parsed for constructing a problem description in accordance with the predefined data structure. A set of monitoring programs of the knowledge base may be identified using the problem description. Using software and/or hardware configuration data of the computing system, the set of monitoring programs may be instantiated in a monitor system. The instantiated programs may be provided to the requester as support for identification of the problem root cause.

Abstract: A method, system and computer program product for providing support for identification of the problem root cause in a computing system. Knowledge base mapping monitoring programs with respective to one or more technical problem definitions and a predefined system configuration are provided. The technical problems are defined using a predefined data structure. An inquiry relating to the computing system is received from a requester. The inquiry indicates a technical problem statement of the computing system. The received inquiry is parsed for constructing a problem description in accordance with the predefined data structure. A set of monitoring programs of the knowledge base may be identified using the problem description. Using software and/or hardware configuration data of the computing system, the set of monitoring programs may be instantiated in a monitor system. The instantiated programs may be provided to the requester as support for identification of the problem root cause.

Abstract: A method, system and computer program product for providing support for identification of the problem root cause in a computing system. Knowledge base mapping monitoring programs with respective to one or more technical problem definitions and a predefined system configuration are provided. The technical problems are defined using a predefined data structure. An inquiry relating to the computing system is received from a requester. The inquiry indicates a technical problem statement of the computing system. The received inquiry is parsed for constructing a problem description in accordance with the predefined data structure. A set of monitoring programs of the knowledge base may be identified using the problem description. Using software and/or hardware configuration data of the computing system, the set of monitoring programs may be instantiated in a monitor system. The instantiated programs may be provided to the requester as support for identification of the problem root cause.

Abstract: Dispatching a database request. A database request is received. Latency times are determined for databases managed by the DBMS, the latency times being estimates of the times to complete replications from the other databases of all unreplicated data changes in the other databases. For each database, a capture velocity and an apply are determined, which are a number of data changes applied to the database that can be identified or applied in a predefined time interval. For each database, an estimated time to complete the database request is determined. The database request is dispatched to the database having an estimated minimum time of execution of the database request, wherein the time of execution is function of the estimated time for the database to complete the database request, the latency time of the database, and the capture and apply velocities of the database.

Abstract: A computer receives a database request to be executed on a source database or a target database. The source database is configured to efficiently process database queries of a first query type, the target database is configured to efficiently process database queries of a second query type, data changes in the source database are asynchronously replicated to the target database, and all changed data in the source database impacting a result of the database request are replicated to the target database before executing the database request. The computer determines a latency time to asynchronously complete a replication of unreplicated data changes and determines a velocity of replication. The computer predicts, using the latency time and velocity of replication, which of the databases will complete an execution of the database request first and dispatches the database request to the database predicted to complete the execution of the database request first.

Abstract: A computer receives a database request to be executed on a source database or a target database. The source database is configured to efficiently process database queries of a first query type, the target database is configured to efficiently process database queries of a second query type, data changes in the source database are asynchronously replicated to the target database, and all changed data in the source database impacting a result of the database request are replicated to the target database before executing the database request. The computer determines a latency time to asynchronously complete a replication of unreplicated data changes and determines a velocity of replication. The computer predicts, using the latency time and velocity of replication, which of the databases will complete an execution of the database request first and dispatches the database request to the database predicted to complete the execution of the database request first.

Abstract: Dispatching a database request. A database request is received. Latency times are determined for databases managed by the DBMS, the latency times being estimates of the times to complete replications from the other databases of all unreplicated data changes in the other databases. For each database, a capture velocity and an apply are determined, which are a number of data changes applied to the database that can be identified or applied in a predefined time interval. For each database, an estimated time to complete the database request is determined. The database request is dispatched to the database having an estimated minimum time of execution of the database request, wherein the time of execution is function of the estimated time for the database to complete the database request, the latency time of the database, and the capture and apply velocities of the database.

Abstract: A computer receives a database request to be executed on a source database or a target database. The source database is configured to efficiently process database queries of a first query type, the target database is configured to efficiently process database queries of a second query type, data changes in the source database are asynchronously replicated to the target database, and all changed data in the source database impacting a result of the database request are replicated to the target database before executing the database request. The computer determines a latency time to asynchronously complete a replication of unreplicated data changes and determines a velocity of replication. The computer predicts, using the latency time and velocity of replication, which of the databases will complete an execution of the database request first and dispatches the database request to the database predicted to complete the execution of the database request first.

Abstract: A method, system and computer program product for providing support for identification of the problem root cause in a computing system. Knowledge base mapping monitoring programs with respective to one or more technical problem definitions and a predefined system configuration are provided. The technical problems are defined using a predefined data structure. An inquiry relating to the computing system is received from a requester. The inquiry indicates a technical problem statement of the computing system. The received inquiry is parsed for constructing a problem description in accordance with the predefined data structure. A set of monitoring programs of the knowledge base may be identified using the problem description. Using software and/or hardware configuration data of the computing system, the set of monitoring programs may be instantiated in a monitor system. The instantiated programs may be provided to the requester as support for identification of the problem root cause.

Abstract: A method, system and computer program product for providing support for identification of the problem root cause in a computing system. Knowledge base mapping monitoring programs with respective to one or more technical problem definitions and a predefined system configuration are provided. The technical problems are defined using a predefined data structure. An inquiry relating to the computing system is received from a requester. The inquiry indicates a technical problem statement of the computing system. The received inquiry is parsed for constructing a problem description in accordance with the predefined data structure. A set of monitoring programs of the knowledge base may be identified using the problem description. Using software and/or hardware configuration data of the computing system, the set of monitoring programs may be instantiated in a monitor system. The instantiated programs may be provided to the requester as support for identification of the problem root cause.

Abstract: Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.

Abstract: Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.

Abstract: Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.

Abstract: Embodiments of the present invention provide systems, methods, and computer program products for detecting shifts in types of workloads handled by a relational database management system. Embodiments of the present invention can afford relational database administrators with the ability to leverage information pertinent to the current type of workload being handled by the relational database management system. Furthermore, embodiments of the present invention provide relational database administrators with information in regard to system workload states and workload transitions.

Abstract: A computer receives a database request to be executed on a source database or a target database. The source database is configured to efficiently process database queries of a first query type, the target database is configured to efficiently process database queries of a second query type, data changes in the source database are asynchronously replicated to the target database, and all changed data in the source database impacting a result of the database request are replicated to the target database before executing the database request. The computer determines a latency time to asynchronously complete a replication of unreplicated data changes and determines a velocity of replication. The computer predicts, using the latency time and velocity of replication, which of the databases will complete an execution of the database request first and dispatches the database request to the database predicted to complete the execution of the database request first.

Abstract: A computer-implemented method, system, and/or computer program product monitors stored procedures that are executed in a database management system. A determination is made, for a stored procedure that is executed in a database management system, of an identification of the stored procedure and event data related to the stored procedure. The event data includes when the stored procedure began and ended executing, an SQL identifier for an SQL statement in the stored procedure, and a counter of how many times the SQL statement executed. The database management system provides values of parameters used when executing the SQL statement. These values are then correlated with the count of how many times the SQL statement executed.

Abstract: System and computer program product for processing a text search query in a collection of documents. A full posting index is generated that has first index terms and a full posting list for each first index term, enumerating occurrences of the first index terms in the documents of the collection. A text search query includes search conditions search terms. The search conditions are translated into conditions on the first index terms to provide translated conditions. At least one short posting index is generated, which includes second index terms and a short posting list for each second index term, enumerating documents in which the second index terms occur. Filter conditions and complementary conditions are generated to represent the translated conditions. The filter conditions approximate the translated conditions, and are processed using the short posting index. The complementary conditions are processed using the full posting index to provide a query result.