Dynamic real storage usage control

• US 8,909,877 B2
• Filed: 02/02/2012
• Issued: 12/09/2014
• Est. Priority Date: 02/02/2012
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Kenyon, Jerome P., Slinger, Nigel G., Tobler, John B.
• Primary Examiner(s): Bradley, Matthew
• Assistant Examiner(s): Tsui, Daniel
• Application Number:
  US13/365,042
• Publication Number:
  US 20130205101A1
• Time in Patent Office: 1,041 Days
• Field of Search: None
• US Class Current: 711/154
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 2201/81 Threshold
• CPC Class Codes: G06F 2201/815 Virtual
• CPC Class Codes: G06F 9/5016 the resource being the memory

Abstract

Provided are techniques for managing an amount of real storage used by a database management system. A value of a real storage management parameter is received, wherein the real storage management parameter indicates conditions under which one or more virtual storage pages are analyzed to identify one or more unused, virtual storage pages that are to be discarded. The database management system and consumption of real storage and auxiliary storage is monitored. In response to determining that the value of the real storage management parameter is set to on, the one or more unused virtual storage pages are discarded. In response to determining that the value of the real storage management parameter is set to auto and that paging has occurred, the one or more unused, virtual storage pages are discarded. Health values are recorded.

Claims

1. A method for managing an amount of real storage used by a database management system, comprising:

receiving, with a processor of a computer, a value of a real storage management parameter, wherein the real storage management parameter indicates conditions under which one or more virtual storage pages are analyzed to identify one or more unused, virtual storage pages that are to be discarded; and

while monitoring the database management system and consumption of real storage and auxiliary storage,

in response to determining that the value of the real storage management parameter is set to on, discarding the one or more unused, virtual storage pages;

in response to determining that the value of the real storage management parameter is set to auto,

determining whether paging has occurred; and

in response to determining that paging has occurred, discarding the one or more unused, virtual storage pages; and

recording health values.

2. The method of claim 1, further comprising:

receiving a value for a real storage maximum parameter, wherein the real storage maximum parameter defines a maximum, database management system-wide amount of real and auxiliary storage allowed to be consumed by the database management system.

3. The method of claim 2, further comprising:

adjusting values for at least one of the real storage management parameter and the real storage maximum parameter.

4. The method of claim 1, further comprising:

determining that there is a critical auxiliary storage shortage; and

discarding the one or more unused, virtual storage pages.

5. The method of claim 1, further comprising:

in response to discarding the one or more unused, virtual storage pages, issuing a message to a system administrator.

6. The method of claim 1, further comprising:

performing one or more reactive measures.

7. The method of claim 1, wherein software is provided as a service in a cloud environment.

8. A computer system for an amount of real storage used by a database management system, comprising:

a processor; and

a storage device connected to the processor, wherein the storage device has stored thereon a program, and wherein the processor is configured to execute instructions of the program to perform operations, wherein the operations comprise;

receiving a value of a real storage management parameter, wherein the real storage management parameter indicates conditions under which one or more virtual storage pages are analyzed to identify one or more unused, virtual storage pages that are to be discarded; and

while monitoring the database management system and consumption of real storage and auxiliary storage,

in response to determining that the value of the real storage management parameter is set to on, discarding the one or more unused, virtual storage pages;

in response to determining that the value of the real storage management parameter is set to auto,

determining whether paging has occurred; and

in response to determining that paging has occurred, discarding the one or more unused, virtual storage pages; and

recording health values.

9. The computer system of claim 8, wherein the operations further comprise:

receiving a value for a real storage maximum parameter, wherein the real storage maximum parameter defines a maximum, database management system-wide amount of real and auxiliary storage allowed to be consumed by the database management system.

10. The computer system of claim 9, wherein the operations further comprise:

adjusting values for at least one of the real storage management parameter and the real storage maximum parameter.

11. The computer system of claim 8, wherein the operations further comprise:

determining that there is a critical auxiliary storage shortage; and

discarding the one or more unused, virtual storage pages.

12. The computer system of claim 8, wherein the operations further comprise:

in response to discarding the one or more unused, virtual storage pages, issuing a message to a system administrator.

13. The computer system of claim 8, wherein the operations further comprise:

performing one or more reactive measures.

14. A computer program product for an amount of real storage used by a database management system, the computer program product comprising:

a non-transitory computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising;

computer readable program code, when executed by a processor of a computer, configured to perform operations of;

receiving a value of a real storage management parameter, wherein the real storage management parameter indicates conditions under which one or more virtual storage pages are analyzed to identify one or more unused, virtual storage pages that are to be discarded; and

while monitoring the database management system and consumption of real storage and auxiliary storage,

in response to determining that the value of the real storage management parameter is set to on, discarding the one or more unused, virtual storage pages;

in response to determining that the value of the real storage management parameter is set to auto,

determining whether paging has occurred; and

in response to determining that paging has occurred, discarding the one or more unused, virtual storage pages; and

recording health values.

15. The computer program product of claim 14, wherein the computer readable program code, when executed by the processor of the computer, is configured to perform operations of:

receiving a value for a real storage maximum parameter, wherein the real storage maximum parameter defines a maximum, database management system-wide amount of real and auxiliary storage allowed to be consumed by the database management system.

16. The computer program product of claim 15, wherein the computer readable program code, when executed by the processor of the computer, is configured to perform operations of:

adjusting values for at least one of the real storage management parameter and the real storage maximum parameter.

17. The computer program product of claim 14, wherein the computer readable program code, when executed by the processor of the computer, is configured to perform operations of:

determining that there is a critical auxiliary storage shortage; and

discarding the one or more unused, virtual storage pages.

18. The computer program product of claim 14, wherein the computer readable program code, when executed by the processor of the computer, is configured to perform operations of:

in response to discarding the one or more unused, virtual storage pages, issuing a message to a system administrator.

19. The computer program product of claim 14, wherein the computer readable program code, when executed by the processor of the computer, is configured to perform operations of:

performing one or more reactive measures.