Device and method for acquiring resource lock

• US 9,189,512 B2
• Filed: 09/05/2014
• Issued: 11/17/2015
• Est. Priority Date: 12/02/2011
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kohno, Noriaki
• Primary Examiner(s): LE, UYEN T
• Application Number:
  US14/478,108
• Publication Number:
  US 20140379679A1
• Time in Patent Office: 438 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/1774 Locking methods, e.g. locking methods for file systems allowing shared and concurrent access to files
• CPC Class Codes: G06F 16/2343 Locking methods, e.g. distributed locking or locking implementation details
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

A lock control device receives a lock acquisition request from an application and transmits a lock acquisition request to a DBMS, receives a lock acquisition response from the DBMS, and transmits a lock acquisition response to the application, and each time, acquires statistical time information including the lock request counter, subsequent lock request counter, lock request time, lock acquisition time, initial lock acquisition time, and subsequent lock request time. The statistical processing device calculates the lock request count for each resource, subsequent lock request count for each resource, average lock wait time, and average lock acquisition delay expectation time, based on the statistical time information. Based on these values, the statistical processing device calculates an evaluation value which is the degree of expectation for the time eliminated from the lock wait time when lock acquisition is postponed, and outputs the lock order of the resources arranged in order of smallest evaluation value to a lock order table.

Claims

1. A device for acquiring resource locks for a plurality of resources in a specific order, comprising:

a computing device for;

generating a time exclusion expectation, the time exclusion expectation comprising an expectation for a length of time that is excluded from a time for retaining a lock on a resource in a system in the case where acquisition of the resource lock is postponed based on statistics obtained by a statistical processing device, for each resource of a plurality of resources; and

shortening a lock retaining time for the system by determining a specific order such that resources with a higher time exclusion expectation generated by the generating component are assigned later in the order.

2. The device according to claim 1, wherein the generating further comprises:

generating a time exclusion expectation that includes a lock wait time exclusion expectation, the lock wait time exclusion expectation comprising the expectation for a length of lock waiting time for another resource, excluded from the time for retaining a lock on the resource when acquisition of the resource lock is postponed, for each resource of a plurality of resources.

3. The device according to claim 2, wherein the generating further comprises:

generating a time exclusion expectation that includes a pre-use time exclusion expectation, the pre-use time exclusion expectation comprising the expectation for a length of time until all resources are used, excluded from the time for retaining a lock on the resource when acquisition of the resource lock is postponed, for each resource of a plurality of resources.

4. The device according to claim 3, wherein the computer device is further configured for:

retrieving a number of times that acquisition of each resource lock has been requested by an application program that uses each resource of a plurality of resources;

wherein the generating further comprises;

generating a lock retaining time exclusion expectation based on the number of times that each resource has been retrieved by the retrieving component, for each resource of the plurality of resources.

5. The device according to claim 3, wherein the computer device is further configured for:

retrieving an acquisition time where software acquires a lock for each resource, and a request time where acquisition of the lock for each resource is requested for software that manages a plurality of resources when an application program that uses various resources from a plurality of resources request acquisition of the resource lock;

wherein the generating further comprises;

generating a lock waiting time exclusion expectation based on the request time and the acquisition time retrieved by the retrieving component, for each resource of the plurality of resources.

6. The device according to claim 3, wherein the computer device is further configured for:

retrieving a number of times that acquisition of each resource lock has been requested as a second or subsequent request for acquisition of a resource lock, by an application program that uses each resource of a plurality of resources;

wherein the generating further comprises;

generating a lock pre-use time exclusion expectation based on the number of times that each resource has been retrieved by the retrieving component, for each resource of the plurality of resources.

7. The device according to claim 3, wherein the computer device is further configured for:

retrieving the acquisition time that each resource lock was acquired, when acquisition of each resource lock is requested as a first request for acquisition of a resource lock, by an application program that uses each resource of a plurality of resources, and retrieves the request time for requesting acquisition of each resource lock, when an application program request acquisition of each resource lock as a second or subsequent request for acquisition of a resource lock;

wherein the generating further comprises;

generating a pre-use time exclusion expectation based on the acquisition time and the request time retrieved by the retrieving component, for each resource of the plurality of resources.

8. A method, comprising:

generating, by a computing device, a time exclusion expectation, the time exclusion expectation comprising an expectation for a length of time that is excluded from a time for retaining a lock on a resource in a system in the case where acquisition of the resource lock is postponed, for each resource of a plurality of resources; and

shortening, by the computing device, lock retaining time for the system by determining a specific order such that resources with a higher generated time exclusion expectation are assigned later in the order.

9. The method according to claim 8, wherein the generating generates a time exclusion expectation that includes a lock wait time exclusion expectation, the lock wait time exclusion expectation comprising the expectation for a length of lock waiting time for another resource, excluded from the time for retaining a lock on the resource when acquisition of the resource lock is postponed, for each resource of a plurality of resources.

10. The method according to claim 9, wherein the generating generates a time exclusion expectation that includes a pre-use time exclusion expectation, the pre-use time exclusion expectation comprising the expectation for a length of time until all resources are used, excluded from the time for retaining a lock on the resource when acquisition of the resource lock is postponed, for each resource of a plurality of resources.

11. The method according to claim 10, further comprising retrieving, by the computing device, a number of times that acquisition of each resource lock has been requested by an application program that uses each resource of a plurality of resources;

wherein the generating generates a lock retaining time exclusion expectation based on the number of times that each resource has been retrieved, for each resource of the plurality of resources.

12. The method according to claim 10, further comprising:

retrieving, by the computing device, an acquisition time where software acquires a lock for each resource, and a request time where acquisition of the lock for each resource is requested for software that manages a plurality of resources when an application program that uses various resources from a plurality of resources request acquisition of the resource lock;

wherein the generating generates a lock waiting time exclusion expectation based on the request time and the retrieved acquisition time, for each resource of the plurality of resources.

13. The method according to claim 10, further comprising:

retrieving, by the computing device, a number of times that acquisition of each resource lock has been requested as a second or subsequent request for acquisition of a resource lock, by an application program that uses each resource of a plurality of resources;

wherein the generating generates a lock pre-use time exclusion expectation based on the number of times that each resource has been retrieved, for each resource of the plurality of resources.

14. The method according to claim 10, further comprising:

retrieving, by the computing device, the acquisition time that each resource lock was acquired, when acquisition of each resource lock is requested as a first request for acquisition of a resource lock, by an application program that uses each resource of a plurality of resources, and retrieves the request time for requesting acquisition of each resource lock, when an application program request acquisition of each resource lock as a second or subsequent request for acquisition of a resource lock;

wherein the generating generates a pre-use time exclusion expectation based on the retrieved acquisition time and the request time, for each resource of the plurality of resources.

15. A program product embodied on a non-transitory storage device, which when executed by a computing device, performs a method, the method comprising

generating a time exclusion expectation, the time exclusion expectation comprising an expectation for a length of time that is excluded from a time for retaining a lock on the resource in a system in the case where acquisition of the resource lock is postponed, for each resource of a plurality of resources;

and

shortening, by the computing device, lock retaining time for the system by determining a specific order such that resources with a higher generated time exclusion expectation are assigned later in the order.

16. The program product according to claim 15, wherein the time exclusion expectation includes a lock wait time exclusion expectation, the lock wait time exclusion expectation comprising the expectation for a length of lock waiting time for another resource, excluded from the time for retaining a lock on the resource when acquisition of the resource lock is postponed, for each resource of a plurality of resources.

17. The program product according to claim 16, wherein the time exclusion expectation includes a pre-use time exclusion expectation, the pre-use time exclusion expectation comprising the expectation for a length of time until all resources are used, excluded from the time for retaining a lock on the resource when acquisition of the resource lock is postponed, for each resource of a plurality of resources.

18. The program product according to claim 17, wherein the method further comprises:

retrieving a number of times that acquisition of each resource lock has been requested by an application program that uses each resource of a plurality of resources;

wherein the generating generates a lock retaining time exclusion expectation based on the number of times that each resource has been retrieved, for each resource of the plurality of resources.

19. The program product according to claim 17, wherein the method further comprises:

retrieving an acquisition time where software acquires a lock for each resource, and a request time where acquisition of the lock for each resource is requested for software that manages a plurality of resources when an application program that uses various resources from a plurality of resources request acquisition of the resource lock;

wherein the generating generates a lock waiting time exclusion expectation based on the request time and the retrieved acquisition time, for each resource of the plurality of resources.

20. The program product according to claim 17, wherein the method further comprises:

retrieving a number of times that acquisition of each resource lock has been requested as a second or subsequent request for acquisition of a resource lock, by an application program that uses each resource of a plurality of resources;

wherein the generating generates a lock pre-use time exclusion expectation based on the number of times that each resource has been retrieved, for each resource of the plurality of resources.