Non-recursive method for parameter evaluation within an information management system

A computer readable medium containing program instructions stored therein that implement a method of performance tuning when executed over a processor within in a relational database management system, said method comprising the steps of:

• a) automatically generating a non-recursive parameter evaluation sequence from said computer readable memory unit, said non-recursive parameter evaluation sequence containing rules for evaluating a plurality of parameters which adjust resources within a database environment wherein parameter dependencies exist within parameters of said plurality of parameters, said step a) comprising the steps of:
• removing circular dependencies within said plurality of parameters;
• and
• ordering said plurality of parameters into said non-recursive evaluation sequence by placing independent parameters first and placing dependent parameters following parameters on which said dependent parameters depend wherein parameters are placed higher in said non-recursive parameter evaluation sequence based on the number of parameters that are data dependent on said parameters;
• b) evaluating said plurality of parameters using said non-recursive parameter evaluation sequence to determine a set of recommended values for said plurality of parameters, said step of evaluating performed in a single non-recursive evaluation path;
• and
• c) performance tuning said database environment by applying said set of recommended values to said plurality of parameters.

A method for evaluating parameters within a relational database management system comprising the steps of:

• a) identifying a plurality of parameters to be tuned within said relational database management system wherein parameter dependencies exist within parameters of said plurality of parameters;
• b) removing circular dependencies among said plurality of parameters;
• c) automatically generating a non-recursive evaluation sequence by ordering said plurality of parameters according to the steps of:
• c1) placing independent parameters first in said non-recursive evaluation sequence and placing dependent parameters following parameters on which said dependent parameters depend;
• and
• c2) placing parameters of said plurality of parameters higher in said non-recursive evaluation sequence based on the number of parameters that are data dependent on said parameters;
• and
• d) using a computer implemented process, evaluating said plurality of parameters using said non-recursive parameter evaluation sequence to determine a set of recommended values for said plurality of parameters.

In a relational database management system having a processor coupled to a bus and a computer readable memory unit coupled to said bus, a method for tuning a database environment, said method comprising the steps of:

• a) identifying a plurality of parameters within said database environment wherein parameter dependencies exist within parameters of said plurality of parameters;
• b) removing circular dependencies within said plurality of parameters;
• c) automatically generating a non-recursive evaluation sequence by ordering said plurality of parameters according to the steps of:
• c1) placing independent parameters first in said non-recursive evaluation sequence and placing dependent parameters following parameters on which said dependent parameters depend;
• and
• c2) for a first set of parameters having no dependencies or equal dependencies, ordering parameters of said first set of parameters based on their impact on system performance and further based on their common data usage;
• d) using a computer implemented process, evaluating said plurality of parameters using said non-recursive parameter evaluation sequence to determine a set of recommended values for said plurality of parameters;
• and
• e) tuning said database environment by applying said set of recommended values to said plurality of parameters.