Abstract: The present invention provides a method, system, and program for debugging external programs, such as user-defined functions, stored procedures, and triggers executed in relational database management systems (RDBMS), in a client-server, i.e., distributed, environment. In the present invention, a debugger is initiated from within a process running the external program by executing a special segment of code prior to the execution of the external program. In one embodiment of the invention, this debugging function is triggered by including a variation of this special segment of program code within the external program, itself. In another embodiment of the invention, this debugging triggering function is provided within an enhanced RDBMS with extensions to SQL to activate the debugging ability in the RDBMS. The invention can be implemented by using present day serial debuggers or parallel and/or distributed debuggers.

Abstract: The present invention provides a dynamic connection for distributed applications that need to locate application development tools, including but not limited to debuggers, trace collection tools, compilers, etc.) which may be running on different machines, and to send the tools messages. The program requesting debugging service (i.e., a debugger client) sends, to a tool locator, criteria which specifies the properties of a desired debugger. The tool locator maintains a registry of all tools, e.g. debuggers, and their properties, which remain active within the network by receiving tool registration information from each tool as it is started on any machine within the network.

Abstract: This invention provides a small and efficient set of primitives for debugging a distributed application that runs on a plurality of processors connected by a common network. These primitives permit a user to debug a distributed application in a manner similar to debugging a non-distributed application. The invention allows a user to step into and return from a remote procedure call in exactly the same manner as a local procedure call. The invention also allow a user to set breakpoints in a server for specific clients and to specify conditions under which a particular remote call from a client should trap in a server. These capabilities greatly simplify the process of debugging distributed applications such as client-server programs.