DATABASE RECOVERY PROGRESS REPORT

• US 20130173558A1
• Filed: 12/29/2011
• Published: 07/04/2013
• Est. Priority Date: 12/29/2011
• Status: Active Grant

• Current Assignee: BMC Software Incorporated (KKR & Co., Inc.)
• Original Assignee: BMC Software Incorporated (KKR & Co., Inc.)
• Inventors: Whisenant, James L., Pothoff, William J., Price, Thomas G., Rabbitt, James T.
• Granted Patent: US 8,880,479 B2
• Time in Patent Office: Days
• US Class Current: 707/674
• CPC Class Codes: G06F 11/0793 Remedial or corrective actions recovery from an exception in an instruction pipeline G06F9/3861; by retry G06F11/1402; for recovering from a failure of a protocol instance or entity H04L69/40

Abstract

The present description refers to a computer implemented method, computer program product, and computer system for receiving a start time, selecting one or more database objects for which a database recovery progress report is to be provided, determining, based on an object recovery table generated by the database recovery utility, which of the selected database objects have been recovered since the start time, and outputting a database recovery progress report that identifies at least a number or percentage of the selected database objects that have been recovered by the database recovery utility since the start time.

Claims

1. A computer program product, the computer program product being tangibly embodied on a computer-readable storage medium and including executable code that, when executed, is configured to cause at least one data processing apparatus to:

receive a start time;

select one or more database objects for which a database recovery progress report is to be provided;

determine, based on an object recovery table generated by the database recovery utility, which of the selected database objects have been recovered since the start time; and

output a database recovery progress report that identifies at least a number or percentage of the selected database objects that have been recovered by the database recovery utility since the start time.

2. The computer program product of claim 1 wherein the database objects comprise at least one of tablespaces or tablespace partitions and indexes or index partitions.

3. The computer program product of claim 1 wherein the object recovery table comprises an IBM SYSCOPY table or a BMCXCOPY table.

4. The computer program product of claim 1 wherein the executable code being configured to cause at least one data processing apparatus to select comprises the executable code being configured to cause at least one data processing apparatus to receive a list of one or more databases, each database including a plurality of database objects.

5. The computer program product of claim 1 wherein the executable code being configured to cause at least one data processing apparatus to select comprises the executable code being configured to cause at least one data processing apparatus to receive a group name that is associated with a group of database objects for which a database recovery progress report is to be provided.

6. The computer program product of claim 1 wherein the object recovery table identifies for each of a plurality of database objects at least an object name, an activity performed on the object, and a date/time that the activity was performed, wherein the activity performed identifies object recovery as the activity performed for at least one database object in the object recovery table.

7. The computer program product of claim 6 wherein the executable code configured to cause at least one data processing apparatus to determine comprises the executable code being configured to cause at least one data processing apparatus to:

compare names from the selected database objects to names of the database objects in the database recovery table;

determine, based on the database recovery table, an activity performed and a time that the activity was performed for one or more of the selected database objects in the database recovery table;

determine, based on the object recovery table, which of the selected objects have been recovered on or after the start time.

8. The computer program product of claim 6 wherein the executable code being configured to cause at least one data processing apparatus to determine comprises the executable code being configured to cause at least one data processing apparatus to:

determine, based on the object name, an activity performed on the object, and a date/time that the activity was performed provided for each database object within the object recovery table, which of the selected objects have been recovered on or after the start time.

9. The computer program product of claim 1 wherein the executable code being configured to output comprises the executable code being configured to cause at least one data processing apparatus to output on a display a database recovery report that identifies at least a number of tablespace partitions and a number of index partitions that have been recovered between the start time and a time the database recovery report is output.

10. The computer program product of claim 1 wherein the executable code being configured to output comprises the executable code being configured to cause at least one data processing apparatus to output on a display a database recovery report that identifies at least a percentage of tablespace partitions and a percentage of index partitions that have been recovered between the start time and a time the database recovery report is output.

11. The computer program product of claim 1 wherein the executable code being configured to output comprises the executable code being further configured to cause at least one data processing apparatus to output on a display, as part of the database recovery report, a percentage of the data of the selected objects that have been recovered since the start time.

12. The computer program product of claim 1 wherein the executable code is further configured to cause at least one data processing apparatus to determine, based on an index partition rebuild table generated by the database recovery utility, a number and/or percentage of the selected database objects, including index partitions, that have been rebuilt by the database recovery utility since the start time;

and

wherein the executable code being configured to output comprises the executable code being further configured to cause at least one data processing apparatus to output on a display, as part of the database recovery report, the number and/or percentage of the selected database objects, including index partitions, that have been rebuilt since the start time.

13. The computer program product of claim 1 wherein the executable code is further configured to cause at least one data processing apparatus to determine, based on at least a portion of a log table generated by the database recovery utility that logs changes to a database since a backup copy of the database was made or based on a summary of the log table, a number and/or percentage of the log records that have been applied since the start time by database recovery utility to perform the database recovery;

wherein the executable code being configured to output comprises the executable code being further configured to cause at least one data processing apparatus to output on a display, as part of the database recovery report, the number and/or percentage of the log records that have been applied since the start time by database recovery utility to perform the database recovery.

14. The computer program product of claim 13 wherein the log table or summary of the log table comprises a SYSLGRNX table.

15. The computer program product of claim 1 wherein the executable code is further configured to cause at least one data processing apparatus to determine, based on at least a portion of a log table generated by the database recovery utility that logs changes to a database or based on a summary of the log table, which of the selected database objects have not changed and therefore do not need to be recovered;

wherein the executable code being configured to output comprises the executable code being further configured to cause at least one data processing apparatus to output on a display, as part of the database recovery report, the number and/or percentage of the database objects, including tablespace partitions and index partitions, which have not changed.

16. A computer implemented method comprising:

receiving a start time;

selecting one or more database objects for which a database recovery progress report is to be provided;

determining, based on an object recovery table generated by the database recovery utility, which of the selected database objects have been recovered since the start time; and

outputting a database recovery progress report that identifies at least a number or percentage of the selected database objects that have been recovered by the database recovery utility since the start time.

17. The computer implemented method of claim 16 wherein the start time is a start time identifying a time that a database recovery was started.

18. The computer implemented method of claim 16 wherein the outputting comprises outputting on a display a database recovery report that identifies at least a number of tablespace partitions and a number of index partitions that have been recovered since the start time.

19. The computer implemented method of claim 16 wherein the outputting comprises outputting on a display a database recovery report that identifies at least a percentage of tablespace partitions and a percentage of index partitions that have been recovered since the start time.

20. An apparatus comprising:

receiving logic configured to receive a start time;

selecting logic configured to select one or more database objects for which a database recovery progress report is to be provided;

determining logic configured to determine, based on an object recovery table generated by the database recovery utility, which of the selected database objects have been recovered since the start time; and

outputting logic configured to output a database recovery progress report that identifies at least a number or percentage of the selected database objects that have been recovered by the database recovery utility since the start time.

21. The apparatus of claim 20 wherein the outputting logic comprises outputting logic that is further configured to output on a display a database recovery report that identifies at least:

a number of tablespace partitions and a number of index partitions that have been recovered since the start time;

a percentage of tablespace partitions and a percentage of index partitions that have been recovered since the start time; and

a percentage of data of the selected objects that have been recovered since the start time.

22. The apparatus of claim 20 wherein the outputting logic comprises outputting logic that is further configured to output the number and/or percentage of the selected database objects, including index partitions, that have been rebuilt since the start time.

23. The apparatus of claim 20 wherein the outputting logic comprises outputting logic that is further configured to output the number and/or percentage of the log records that have been applied since the start time by database recovery utility to perform the database recovery.

24. The apparatus of claim 20 wherein the start time comprises a start time identifying a time that a database recovery was started by a database recovery utility.