Method of efficient collection of SQL performance measures

A computer-readable medium encoded with a method of collecting selected SQL performance information associated with the processing of a current SQL Data Manipulation Language routine statement within a IBM Database 2 program including control blocks, data structures, an SQL processing module, an SQL processing routine having an associated entry point, and an SQL Data Manipulation Language processing routine comprising processing statements and an associated entry point entry point, in which the method comprises the steps of:

• a. building, acquiring, and initializing storage areas and control blocks, as required;
• b. enabling an SQL intercept code by connecting directly into the SQL processing routine of the IBM Database 2 program;
• c. passing control to a substitute SQL Data Manipulation Language processing routine from the IBM Database 2 program at the point at which the IBM Database 2 program begins to process an SQL Data Manipulation Language statement;
• d. navigating selected structures in order to obtain a series of metrics, and, concurrently, obtaining a first set of required values from the series of metrics;
• e. passing control back to the SQL Data Manipulation Language processing routine;
• f. allowing the relational database management system to complete SQL Data Manipulation Language processing requirements;
• g. automatically passing control back to the substitute SQL Data Manipulation Language processing routine;
• h. navigating the selected structures in order to obtain the series of metrics;
• i. obtaining a second set of required values from the series of metrics;
• j. comparing the first set and the second set;
• k. summarizing the results of the comparing;
• and
• l. returning control to the IBM Database 2 program.

A computerized method of intercepting SQL processing within a relational database including a relational database management program, the relational database management program including SQL processing logic, the method comprising the steps of:

• a. enabling an SQL intercept code by connecting directly into the SQL processing logic of the relational database management program;
• b. using the SQL intercept code to intercept an SQL statement made to the relational database;
• c. using the SQL intercept code to collect a first set of real-time SQL performance information located in selected structures;
• d. returning control to the SQL processing logic until the relational database management program has processed the SQL statement to completion;
• e. using the SQL intercept code to collect a second set of real-time SQL performance information located in the selected structures;
• f. comparing the first set with the second set in order to measure the performance of the SQL statement;
• and
• g. returning control to the relational database management program.

A computerized method of collecting selected SQL performance information associated with the processing of a current SQL Data Manipulation Language routine statement within a IBM Database 2 program including control blocks and data structures, an SQL processing module, an SQL processing routine having an associated entry point, and an SQL Data Manipulation Language processing routine comprising processing statements and an associated entry point entry point, in which the method comprises the steps of:

• a. building, acquiring, and initializing storage areas and control blocks, as required;
• b. enabling an SQL intercept code by connecting directly into the SQL processing routine of the IBM Database 2 program;
• c. passing control to a substitute SQL Data Manipulation Language processing routine from the IBM Database 2 program at the point at which the IBM Database 2 program begins to process an SQL Data Manipulation Language statement;
• d. navigating selected structures in order to obtain a series of metrics, and, concurrently, obtaining a first set of required values from the series of metrics;
• e. passing control back to the SQL Data Manipulation Language processing routine;
• f. allowing the relational database management system to complete SQL Data Manipulation Language processing requirements;
• g. automatically passing control back to the substitute SQL Data Manipulation Language processing routine;
• h. navigating the selected structures in order to obtain the series of metrics;
• i. obtaining a second set of required values from the series of metrics;
• j. comparing the first set and the second set;
• k. summarizing the results of the comparing;
• and
• l. returning control to the IBM Database 2 program.