Reporting for database backups

A non-transitory computer readable medium comprising computer readable program code, which when executed by a computer processor enables the computer processor to perform a method for reporting database backup information, the method comprising:

• making a first determination, by a first child process of a plurality of child processes, that a monitoring process associated with the plurality of child processes has not been started by determining that a flag file for the database has not been created by the plurality of child processes;
• starting, by a first library instance of the first child process executing on a data source device, the monitor process, wherein the first child process comprises a first backup channel for performing a first portion of a database backup of a database;
• making a second determination, by the first library instance, that the flag file has still not been created by the plurality of child processes, wherein the first child process is first in time of the plurality of child processes to start the monitor process;
• generating, by the monitor process, the flag file for the database backup comprising a parent process identifier (PID) of a parent process of the first child process, wherein the flag file:
• further comprises child (PIDs) associated with the plurality of child processes and backup job names associated with backup jobs of the database backup, and
• specifies backup job start times, backup job end times, backup job successes, backup job failures, and the first child process started the monitoring process and generated the flag file;
• associating a second child process of the plurality of child processes with the monitor process by identifying the flag file using the parent PID, wherein the second child process comprises a second backup channel for performing a second portion of the database backup;
• receiving, by the monitor process, a first channel close alert corresponding to the second channel from the second child process;
• performing, by the monitor process and using a PID of the first child process, a check to confirm that the first child process is still executing;
• receiving, by the monitor process and separate from the first channel close alert, a second channel close alert corresponding to the first channel from the first child process;
• making a third determination, by the monitor process, that a first plurality of the backup jobs performed in the first channel were successful;
• making a fourth determination, by the monitor process, that a second plurality of the backup jobs performed in the second channel were successful;
• and
• transmitting, by the monitor process and based on the first determination and the second determination, a backup success report to a backup coordinator,
• wherein the first backup channel and the second backup channel include separate data streams for transferring data from the database to a backup storage device.

A system for reporting database backup information, the system comprising:

• a data source device operatively connected to a backup coordinator and comprising:
• a
• processor;
• memory;
• a storage device;
• a first library instance of a first child process of a plurality of child processes executing on the processor and comprising a first backup channel for performing a first portion of a database backup of a database, wherein the first library instance is configured to:
• make a first determination that a monitoring process associated with the plurality of child processes has not been started by determining that a flag file for the database has not been created by the plurality of child processes;
• in response to the first determination, start the monitor process;
• and
• the monitor process, executing on the processor, and configured to:
• make a second determination that the flag file has still not been created by the plurality of child processes, wherein the first child process is first in time of the plurality of child processes to start the monitor process;
• generate the flag file for the database backup comprising a parent process identifier (PID) of a parent process of the first child process, wherein the flag file:
• further comprises child (PIDs) associated with the plurality of child processes and backup job names associated with backup jobs of the database backup, and
• specifies backup job start times, backup job end times, backup job successes, backup job failures, and the first child process started the monitoring process and generated the flag file;
• associate a second child process of the plurality of child processes with the monitor process by identifying the flag file using the parent PID, wherein the second child process comprises a second backup channel for performing a second portion of the database backup;
• receive a first channel close alert corresponding to the second channel from the second child process;
• performing, using a PID of the first child process, a check to confirm that the first child process is still executing;
• receive, separate from the first channel close alert, a second channel close alert, corresponding to the first channel from the first child process;
• make a third determination that a first plurality of the backup jobs performed in the first channel were successful;
• make a fourth determination, by the monitor process, that a second plurality of the backup jobs performed in the second channel were successful;
• and
• transmit, based on the first determination and the second determination, a backup success report to the backup coordinator,
• wherein the first backup channel and the second backup channel include separate data streams for transferring data from the database to a backup storage device.