Abstract: The invention relates to a method for providing access paths to data within a database, in particular using REBIND for DB2, wherein real time database statistics are determined using a database integrated monitor, wherein the database statistics are output substantially in real time using the database integrated status monitor, and wherein the database statistics from the integrated monitor are used to initiate generation of data set statistics, and to determine the access paths.

Abstract: The index optimization (XOP) program is a method to recommend new or improved performance indexes for use by an IBM mainframe DB2 database server for a given set of SQL statements. The recommendations are calculated based on a single call of the DB2 optimizer for each SQL statement with the existing index set, parsing of the SQL statements, the filter factors of the SQL statement predicates, and the getpage workload of an SQL statement. The getpage workload of an SQL statement is the read/change activity on each table and each index currently used for all invocations of an SQL statement. The XOP program computes new and improved performance indexes based on the getpage workload of all relevant SQL statements and does not use the DB2 optimizer to determine the usefulness of potential indexes.

Abstract: The invention relates to a method for providing access paths to data within a database, in particular using REBIND for DB2, wherein real time database statistics are determined using a database integrated monitor, wherein the database statistics are output substantially in real time using said database integrated status monitor, and wherein said database statistics from said integrated monitor are used to initiate generation of data set statistics, and to determine said access paths.

Abstract: The invention relates to a method for the real time maintenance of database content, in particular files (data sets), of a relational database, specifically DB2. Continuous availability with simultaneous continuous maintenance of a relational database is made available by a method in which the status of the database content is determined using a status monitor integrated in the database, in which status data of the determined status is output in real time using said database-integrated status monitor, in which said output status data is analyzed and compared to comparison data and in which maintenance functions are mostly activated directly following a positive compare result.

Abstract: The invention relates to a method of determining relevant figures that describe time within a database recovery process, wherein the database comprises at least a multitude of objects and a multitude of log files, wherein the objects are stored in object backups, wherein the database is stored in system backups, in which changes in objects are recorded in log files, and wherein for the purpose of recovering the database in a state at a determinable target point in time objects are reconstructed at least in part from the log files based on the object backups or the system backups. A prediction of the duration of a recovery process can be made in that for a recovery of the database from the system backup the size of the system backup to be retrieved is determined, that for a recovery of the database from the object backups the size of the object backups to be retrieved is determined and that prior to a database recovery the relevant figures are calculated based on the determined sizes and displayed.

Abstract: The index optimization (XOP) program is a method to recommend new or improved performance indexes for use by an IBM mainframe DB2 database server for a given set of SQL statements. The recommendations are calculated based on a single call of the DB2 optimizer for each SQL statement with the existing index set, parsing of the SQL statements, the filter factors of the SQL statement predicates, and the getpage workload of an SQL statement. The getpage workload of an SQL statement is the read/change activity on each table and each index currently used for all invocations of an SQL statement. The XOP program computes new and improved performance indexes based on the getpage workload of all relevant SQL statements and does not use the DB2 optimizer to determine the usefulness of potential indexes.