Patent ID: 9037622
Filing Date: 2015-05-19
Classification: G06F

Abstract:
1. A computer-implemented method for managing spool space in a database system including fast and slow storage locations, the method comprising the steps of: (a) establishing a soft reserve comprising a percentage of said fast storage locations within said database system, said soft reserve being storage space reserved for special allocation types including spool space; (b) setting an initial value for a spool constant metric, said spool constant metric indicating spool use within said database storage locations; (c) measuring, by said computer, an actual amount of storage space allocated to spool use within said database storage locations; (d) setting, by said computer, a new value of said spool constant metric by blending said spool allocation measurement with an immediate prior value of said spool constant metric; and (e) setting, by said processor, said soft reserve percentage equal to said new value of said spool constant metric.