Database recovery progress report
View Patent ↗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.
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 a plurality of database objects including one or more tablespace partitions and one or more index partitions 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 one or more tablespace partitions and one or more index partitions have been recovered since the start time; and
output a database recovery progress report that identifies progress of database object recovery as database object recovery is performed based on the object recovery table, the database recovery progress report including at least a number or percentage of the selected one or more tablespace partitions and a number or percentage of the selected one or more index partitions that have been recovered by the database recovery utility since the start time.
2. The computer program product of claim 1 wherein the object recovery table comprises an IBM SYSCOPY table or a BMCXCOPY table.
3. 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 one or more tablespace partitions and one or more index partitions.
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 group name that is associated with a group of database objects for which a database recovery progress report is to be provided.
5. 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.
6. The computer program product of claim 5 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.
7. The computer program product of claim 5 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.
8. 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.
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 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.
10. 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.
11. 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.
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 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.
13. The computer program product of claim 12 wherein the log table or summary of the log table comprises a SYSLGRNX table.
14. 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.
15. A computer implemented method for executing instructions stored on a non-transitory computer-readable storage medium, the method comprising:
receiving a start time;
selecting a plurality of database objects including one or more tablespace partitions and one or more index partitions 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 one or more tablespace partitions and one or more index partitions have been recovered since the start time; and
outputting a database recovery progress report that identifies progress of database object recovery as database object recovery is performed based on the object recovery table, the database recovery progress report including at least a number or percentage of the selected one or more tablespace partitions and a number or percentage of the selected one or more index partitions that have been recovered by the database recovery utility since the start time.
16. The computer implemented method of claim 15 wherein the start time is a start time identifying a time that a database recovery was started.
17. The computer implemented method of claim 15 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.
18. The computer implemented method of claim 15 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.
19. An apparatus comprising:
at least one processor;
instructions recorded on a non-transitory computer-readable medium, and executable by the at least one processor, the apparatus including:
receiving logic configured to receive a start time;
selecting logic configured to select a plurality of database objects including one or more tablespace partitions and one or more index partitions 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 one or more tablespace partitions and one or more index partitions have been recovered since the start time; and
outputting logic configured to output a database recovery progress report that identifies progress of database object recovery as database object recovery is performed based on the object recovery table, the database recovery progress report including at least a number or percentage of the selected one or more tablespace partitions and a number of percentage of the selected one or more index partitions that have been recovered by the database recovery utility since the start time.
20. The apparatus of claim 19 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.
21. The apparatus of claim 19 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.
22. The apparatus of claim 19 wherein the start time comprises a start time identifying a time that a database recovery was started by a database recovery utility.