Patent ID: 8407531

Claim:
A method, comprising: collecting a first information on a plurality of programs waiting on or holding a plurality of resources from computers in a multi-computer database system, the first information including a program identifier, a resource identifier, a hold time, and a wait time; creating a first table that includes the first information of programs from one of the multi-computer systems; creating a second table that includes the first information of programs from another of the multi-computer systems; sorting the first information by resource identifier, hold time, and wait time to generate a sorted list; determining an identifier for a program associated with a first row of the sorted list when the first row has a non-zero hold time for a particular resource; identifying a second row of the sorted list that has a non-zero wait time for the particular resource; linking a row of the second table corresponding to the second row of the sorted list with a row of the first table corresponding to the program associated with the first row of the sorted list using the identifier when the first information of the second row of the sorted list is stored in the second table; linking another row of the first table corresponding to the second row of the sorted list with the row of the first table corresponding to the program associated with the first row of the sorted list using the identifier when the first information of the second row of the sorted list is stored in the first table; repeating the determining, identifying, and linking for all rows of the sorted list with a non-zero hold time; identifying a first program of the plurality of programs, executing on a first computer of the multi-computer database system, that is waiting on a first resource of the plurality of resources; identifying a second program of the plurality of programs, executing on a second computer of the multi-computer database system, as the ultimate holder of the first resource by using the first table and the second table; and displaying a second information corresponding to the first program and the second program, wherein the method is performed on a periodic basis.