Patent ID: 9606892
Date: 2017-03-28
CPC Classifications: G06F

Claim:
1. A computer-implemented method, comprising: receiving, at a processor, a configuration file comprising a plurality of workfile threshold values; monitoring, at the processor, workfile usage in a database management system, wherein the workfile usage comprises a total amount of workfile space used by SQL queries, a number of workfiles created by the database management system, and a total amount of disk capacity utilized by workfiles; comparing, at the processor, the plurality of workfile threshold values with the workfile usage to determine whether the workfile usage has reached at least one of the plurality of workfile threshold values; determining, at the processor, that a parameter to reclaim space was included in the configuration file; determining, at the processor, whether the database management system comprises at least one overgrown workfile, wherein the overgrown workfile comprises at least one workfile dataset created by the database management system; and outputting, at the processor, a threshold alert when the workfile usage has reached the at least one workfile threshold value.