IP Library Granted Patent US 8,195,604
Granted Patent B2
US 8,195,604 · App. 12/392,346 · Granted Jun 5, 2012

System and method for verifying IMS databases on a mainframe computer

Assignee: CenturyLink Intellectual Property LLC
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,195,604
App. No.
12/392,346
Granted
Jun 5, 2012
Kind
B2
Abstract

A system and method for ensuring existence all IMS database components operating on a mainframe computer may include a storage unit configured to store multiple IMS databases and multiple respective sets of IMS database components. A processing unit may be in communication with the storage unit. Software, when executed on the processing unit, may cause the processing unit to (i) access multiple IMS database libraries, (ii) identify each set of IMS database components that is missing at least one IMS database component in the IMS database libraries, and (iii) generate a report listing each set of IMS database components missing at least one IMS database component.

Claims (45)

1. A system for ensuring existence all information management system (IMS) database components, a system comprising:

on a mainframe computer:

a storage unit configured to store a plurality of IMS databases and a plurality of sets of IMS database components, each set of IMS database components operable to manage a respective IMS database;

a processing unit in communication with said storage unit; and

software, when executed on said processing unit, causes said processing unit to:

access a plurality of IMS database libraries;

extract a list of IMS database components from each of the IMS database libraries;

append each list of IMS database components from each of the IMS database libraries;

sort the appended lists;

count the total number of IMS database components with the same name not including suffixes;

determine that the total number of IMS database components with the same name not including suffixes is a predetermined value;

identify each set of IMS database components that is missing at least one IMS database component in the IMS database libraries from the sorted, appended lists of IMS database components; and

generate a report listing each set of IMS database components missing at least one IMS database component.

2. The system according to claim 1 , wherein said software, when executed by said processing unit, is further configured to cause said processing unit to:

determine, from at least one of the extracted lists of IMS database components, whether a particular IMS database component exists; and

in response to determining that the particular IMS database component does not exist, including an indicia of the particular IMS database component in the report.

3. The system accordingly to claim 1 , wherein the predetermined value is 5.

4. The system accordingly to claim 1 , wherein said software, when executed by said processing unit, is further configured to cause said processing unit to count only one of each type of IMS database component.

5. The system accordingly to claim 1 , wherein said software, when executed by said processing unit, is further configured to cause said processing unit to access, identify, and generate on a periodic basis.

6. The system accordingly to claim 5 , wherein the periodic basis is once per month.

7. The system accordingly to claim 1 , wherein said software, when executed by said processing unit, is further configured to cause said processing unit to:

identify each set of IMS database components that are complete; and

generate a report listing each complete set of IMS database components.

8. The system accordingly to claim 1 , wherein said software, when executed by said processing unit, is further configured to cause said processing unit to identify any IMS database components that have been added or deleted since said software was previously executed by said processing unit.

9. A method for ensuring existence of all information management system (IMS) database components, said method comprising:

on a mainframe computer:

accessing a plurality of IMS database libraries;

extracting a list of IMS database components from each of the IMS database libraries;

appending each list of IMS database components from each of the IMS database libraries;

sorting the appended lists;

counting a total number of IMS database components with the same name; and

determining that the total number of IMS database components with the same name is a predetermined value;

identifying each set of IMS database components that is missing at least one IMS database component in the IMS database libraries from the sorted, appended lists of IMS database components; and

generating a report listing each set of IMS database components missing at least one IMS database component for notifying a database administrator.

10. The method according to claim 9 , further comprising:

determining, from at least one of the extracted lists of IMS database components, whether a particular IMS database component exists;

in response to determining that the particular IMS database component does not exist, including an indicia of the particular IMS database component in the report.

11. The method accordingly to claim 9 , wherein the predetermined value is 5.

12. The method accordingly to claim 9 , further comprising counting only one of each type of IMS database components.

13. The method accordingly to claim 9 , wherein accessing, identifying, and generating is performed on a periodic basis.

14. The method accordingly to claim 13 , wherein the periodic basis is once per month.

15. The method accordingly to claim 9 , further comprising:

identifying each set of IMS database components that are complete; and

generating a report listing each complete set of IMS database components.

16. The method accordingly to claim 9 , further comprising identifying any IMS database components that have been added or deleted since accessing, identifying and generating were last performed.

Assignments (2)
CHANGE OF NAME Recorded May 3, 2012
From: EMBARQ HOLDINGS COMPANY, LLC
To: CENTURYLINK INTELLECTUAL PROPERTY LLC
Reel/Frame 028154/0814 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 25, 2009
From: MEINSEN, DAVID
To: EMBARQ HOLDINGS COMPANY, LLC
Reel/Frame 022308/0782 →
Continuity (1)
Related Publication 20100228717A1 · Sep 9, 2010