Automatic management of dependencies between physical and logical elements in an application set

• US 7,475,094 B2
• Filed: 03/10/2006
• Issued: 01/06/2009
• Est. Priority Date: 03/10/2006
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ruggles, Jeffrey Ralph, Farber, Joel Frank, Church, Nathan Daniel, Leamon, Teresa Lynn
• Primary Examiner(s): Mofiz; Apu
• Assistant Examiner(s): CHEN, TE Y
• Application Number:
  US11/372,806
• Publication Number:
  US 20070214184A1
• Time in Patent Office: 1,033 Days
• Field of Search: 707/103.R, 707/204, 707/200, 707/206, 715/500.1, 709/224, 711/117
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A mechanism minimizes the management issues of the participant objects of the logical target set, such as an application set. The mechanism maps the current physical implementation. The mechanism then identifies the target and extraneous object set locations to facilitate isolation. Thereafter, the mechanism optimizes the logical target set placement for best manageability and performance. The mechanism minimizes the management issues by providing a small application footprint. This is accomplished by placing the object set on the fewest necessary volumes to facilitate both application performance and independence of administrative action.

Claims

1. A computer implemented method for resolving intermixed application objects comprising application objects related to an application and application objects unrelated to the application in storage, the computer implemented method comprising:

identifying an application set, wherein the application set comprises a grouping of application objects related to an application;

determining application objects unrelated to the application;

determining on which physical storage units the application objects reside;

obtaining a growth rate for the application objects;

setting free space requirements and projections based on the growth rate for the application objects;

determining a layout of the application objects based on the determined physical storage units where the application objects reside, wherein the layout increases manageability of the application, and wherein the determined layout of the application objects isolates application objects related to an application from application objects unrelated to the application;

determining a layout of tablespaces, containers, and volumes for the application set based on the free space requirements and projections to recommend an accommodation of the application set on a minimum number of volumes;

creating tasks to implement the determined layout of the application objects; and

resolving intermixing of the application objects in storage by executing the tasks.

2. The computer implemented method of claim 1, further comprising:

determining a current size of the application objects.

3. The computer implemented method of claim 1, further comprising:

mapping an infrastructure of the physical storage units.

4. The computer implemented method of claim 1, wherein the layout of tablespaces, containers, and volumes for the application set is based on usage and performance requirements.

5. The computer implemented method of claim 1, wherein determining the layout of tablespaces, containers, and volumes for the application set comprises:

setting volume sizes according to the volume size recommendation.

6. The computer implemented method of claim 1, wherein the tasks created to implement the layout of application objects comprise:

unloading the application objects currently residing the physical storage units;

re-defining infrastructure of the physical storage units based on the layout of the application objects;

creating new data description language tasks; and

loading the application objects in the defined infrastructure using the data description language task.