Method and apparatus for performing a health check on a database system

• US 6,115,720 A
• Filed: 04/10/1998
• Issued: 09/05/2000
• Est. Priority Date: 12/15/1997
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bleizeffer, Terry M., Shough, David E., Church, Nathan D., Hughes, Virginia W. Jr., Devine, Kathryn W., Kilburn, Barbara J.
• Primary Examiner(s): Alam, Hosain T.
• Assistant Examiner(s): ALAM, SHAHID AL
• Application Number:
  US09/058,138
• Time in Patent Office: 879 Days
• Field of Search: 707/1, 707/3, 707/4, 707/5, 707/500, 707/513, 707/202, 707/203, 707/511, 707/8, 707/10, 707/200, 707/201, 707/205, 717/1, 717/5, 717/7, 711/2, 711/100, 345/349, 709/203, 709/220, 709/225-226
• US Class Current: 1/1
• CPC Class Codes: G06F 11/324 Display of status information
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 9/44505 Configuring for program initiating, e.g. using registry, configuration files
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method and apparatus for compensating for deficiencies existing in programs to assist a user through installing a program. Polling the status of jobs requested by the user of a workstation is done so that the user may eventually be provided with status reports regarding the jobs being executed. The user can set parameters during loading of SMPE libraries, install, migrate, fallback, remigrate and update procedures for the program. An indication is provided to a user of a workstation as steps of a task have been completed by the user. The health of catalog and directory databases may be verified before a migrate procedure is performed. The user of the program can be informed regarding parameters whose default values have changed, which parameters are of particular concern to the specific user.

Claims

1. A method for verifying integrity of a catalog and directory of a program on a computer system, the system including a workstation and a host, the catalog and directory of the program being disposed on the host, the workstation including a display, the method comprising the steps of:

a) displaying a map of at least one job on the display;

b) providing a user of the workstation with an ability to select and edit the job and add additional jobs, each of the jobs being executed on the host and comprising queries for verifying integrity of a different aspect of the catalog and directory;

c) creating a shadow of the catalog and directory; and

d) executing the at least one job against the shadow of the catalog and directory and executing any additional jobs added by the user for verifying the integrity of the catalog and directory.

2. The method according to claim 1, wherein steps a) through d) are performed prior to migrating from a first version of the program to a second version of the program.

3. The method according to claim 1, wherein the program is DB2™

.

4. The method according to claim 1, wherein the at least one job and any additional jobs are executed during one of install, migrate, fallback, remigrate and update program procedures.

5. The method according to claim 1, wherein in the step a) the map is displayed on the display in a graphical form using a graphical user interface.

6. A computer system for verifying integrity of a catalog and directory, the system comprising:

a workstation including a display;

a host, the catalog and directory being disposed on the host; and

a program providing on the display a map of at least one job, wherein a user of the workstation may select and edit the job and add additional jobs, each of the jobs being executed on the host and comprising queries for verifying integrity of a different aspect of the catalog and directory;

wherein in response to the user selecting, editing and adding jobs, a shadow of the catalog and directory are created and wherein in response to the creating of the shadow of the catalog and directory, the at least one job is executed against the shadow of the catalog and directory and any additional jobs are executed for verifying the integrity of the catalog and directory.

7. The computer system according to claim 6, wherein the verifying integrity of the database catalog and directory is performed prior to migrating from a first version of the program to a second version of the program.

8. The computer system according to claim 6, wherein the program is DB2™

.

9. The computer system according to claim 6, wherein the at least one job and any additional jobs are executed during one of install, migrate, fallback, remigrate and update program procedures.

10. The computer system according to claim 6, wherein the map is displayed on the display in a graphical form using a graphical user interface.

11. A computer program to be performed on or with the aid of a computer system for verifying integrity of a catalog and directory of a program on a computer system, the system including a workstation and a host, the workstation including a display, the catalog and directory of the program being disposed on the host, the computer program comprising the steps of:

a) displaying a map of at least one job on the display;

b) providing a user of the workstation with an ability to select and edit the job and add additional jobs, each of the jobs being executed on the host and comprising queries for verifying integrity of a different aspect of the catalog and directory;

c) creating a shadow of the catalog and directory; and

d) executing the at least one job against the shadow of the catalog and directory and executing any additional jobs added by the user for verifying the integrity of the catalog and directory.

12. The computer program according to claim 11, wherein steps a) through d) are performed prior to migrating from a first version of the program to a second version of the program.

13. The computer program according to claim 11, wherein the program is DB2™

.

14. The computer program according to claim 11, wherein the at least one job and any additional jobs are executed during one of install, migrate, fallback, remigrate and update program procedures.

15. The computer program according to claim 11, wherein in said step a) of said computer program the map is displayed on the display in a graphical form using a graphical user interface.

16. A computer-readable medium containing a computer program for performing the method of verifying integrity of a catalog and directory of a program on a computer system, the system including a workstation and a host, the catalog and directory of the program being disposed on the host, the workstation including a display, the computer program comprising the steps of:

a) displaying a map of at least one job on the display;

b) providing a user of the workstation with an ability to select and edit the job and add additional jobs, each of the jobs being executed on the host and comprising queries for verifying integrity of a different aspect of the catalog and directory;

c) creating a shadow of the catalog and directory; and

d) executing the at least one job against the shadow of the catalog and directory and executing any additional jobs added by the user for verifying the integrity of the catalog and directory.

17. The computer-readable medium according to claim 16, wherein steps a) through d) are performed prior to migrating from a first version of the program to a second version of the program.

18. The computer-readable medium according to claim 16, wherein the program is DB2™

.

19. The computer-readable medium according to claim 16, wherein the at least one job and any additional jobs are executed during one of install, migrate, fallback, remigrate and update program procedure.

20. The computer-readable medium according to claim 16, wherein in said step a) of said computer program the map is displayed on the display in a graphical form using a graphical user interface.