Database breakpoint apparatus and method

• US 7,363,617 B2
• Filed: 05/23/2002
• Issued: 04/22/2008
• Est. Priority Date: 05/23/2002
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Barsness, Eric Lawrence, Dettinger, Richard Dean, Majd, Mahdad, Santosuosso, John Matthew, Brutman, Michael Brian, Olson, Brian Edward
• Primary Examiner(s): Dam; Tuan
• Assistant Examiner(s): TECKLU, ISAAC TUKU
• Application Number:
  US10/153,978
• Publication Number:
  US 20030221187A1
• Time in Patent Office: 2,161 Days
• Field of Search: 717168-178, 717/124, 717/129, 717/130, 707 1-206
• US Class Current: 717/129
• CPC Class Codes: G06F 11/3664 Environments for testing or debugging software

Abstract

An apparatus and method define the concept of a “database breakpoint.” One or more conditions in the database are specified as a database breakpoint in a debug environment for debugging a computer program that accesses the database. When the database conditions exist, one or more debug functions may be performed with respect to the execution of the computer program. Examples of debug functions include halting execution of the computer program and halting operations to the database by other programs. With both the computer program and database halted, the user may then interrogate the database to determine its state, and may interrogate the program to determine its state. Database breakpoints greatly enhance the utility of a debugger by providing additional conditions for debugging a computer program that accesses a database.

Claims

1. A method for debugging a computer program that accesses a database, the method comprising the steps of:

defining at least one database breakpoint that specifies at least one database condition;

executing the computer program; and

when the at least one database condition exists, halting operations by other programs to the database and halting execution of the computer program.

2. The method of claim 1 wherein the at least one database condition includes processing a query that causes at least one trigger program to be executed.

3. The method of claim 1 wherein the at least one database condition includes reoptimizing a previously run query.

4. The method of claim 1 wherein the at least one database condition includes processing a query that locks more than a predetermined number of rows in the database.

5. The method of claim 1 wherein the at least one database condition includes processing a query where a query optimizer determines that a temporary index is needed even though an index already exists.

6. The method of claim 1 wherein the at least one database condition includes satisfying at least one programmable threshold in the database.

7. The method of claim 6 wherein the at least one programmable threshold includes at least one time limit for performing a specified operation.

8. The method of claim 6 wherein the at least one programmable threshold includes a specified number of open commitments for a unit of work in the database.

9. The method of claim 1 wherein the at least one database condition includes detecting when a join order is not as expected.

10. The method of claim 1 wherein the at least one database condition includes an error in conversion in the database.

11. The method of claim 1 wherein the at least one database condition includes at least one timeout of at least one lock in the database.

12. The method of claim 1 wherein the at least one database condition includes an insert execution that does not provide a value for a column or that provides null for a column.

13. The method of claim 1 wherein the at least one database condition includes a column or combination of columns not used in an index.

14. The method of claim 1 wherein the at least one database condition includes the processing of a query that involves a table scan.

15. The method of claim 1 wherein the at least one database condition includes the processing of a query that will return no rows.

16. The method of claim 1 wherein the at least one database condition includes the processing of an update or delete statement that would affect multiple rows in a table.

17. A method for debugging a computer program that accesses a database, the method comprising the steps of:

defining in a debugger at least one database breakpoint that specifies at least one database condition;

executing the computer program under control of the debugger;

the database communicating to the debugger data that indicates the state of the database; and

when the state of the database indicates the at least one database condition exists in the database, performing at least one debug function for debugging the computer program, wherein the at least one debug function includes halting operations by other programs to the database and halting execution of the computer program.