Archival management of database logs

1. A method for preventing suspension of transactions in a database computing system by monitoring active database logs of the database computing system, the method comprising the steps of:

switching, by one or more processors, archive units of the database computing system due to full database log condition occurring during system operations of the active database logs;

maintaining, by the one or more processors, a database log history table, wherein the database log history table captures a threshold count of the active database logs generated by system threads of the database computing system;

defining, by the one or more processors, a temporary location for archiving the active database logs based on the switched archive units of the database computing system, and the maintained threadhold count of active database logs in the database log history table due to full database log condition occurring during system operations of the database computing system;

determining, by the one or more processors, if a system failure or database log condition is caused by the system threads that generates active database logs faster than the database computing system; and

suspending, by the one more or more processors, generation of the active database logs by the system threads, if the system threads generates final active database logs of the active database logs faster than the database computing system.

2. The method according to claim 1 , further including the step of:

determining, by the one or more processors, a cause of a system failure or database log condition due to the full database log condition occurring during system operations of the active database logs, wherein archiving of the active database logs to the temporary location occurs without suspending or halting system operations of the database computing system.

3. The method according to claim 2 , wherein the cause of the system failure or database log condition is not addressed until the active database logs reaches a final active database log status, wherein the active database logs are archived in the temporary location when the active database logs reaches the final active database log status.

4. The method according to claim 3 , wherein the final active database log status is based on another threadhold count of active database log records.

5. The method according to claim 3 , wherein the temporary location includes a record of dataset that includes the active database logs, and a record of dataset that includes boot strap data of the archived active database logs of the temporary location.

6. The method according to claim 1 , wherein the system thread with the highest number of active database logs is suspended based on a threadhold of a count of the active database logs in a database log history table, and wherein a database log history table maintains a record of active and suspended system threads.

7. The method according to 1 , wherein the step of determining, by the one or more processors, if a system failure or database log condition is caused by the system threads that generates active database logs faster than the database computing system, further includes the steps of:

searching, by the one or more processors, a database log history table for a record of active and suspended system threads of the database computing system; and

archiving, by the one or more processors, final active database logs in the temporary location.

8. A computer system for preventing suspension of transactions in a database computing system by monitoring active database logs of the database computing system, the computer system comprising:

one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage devices and program instructions which are stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, the program instructions comprising:

program instructions to switch archive units of the database computing;

system due to full database log condition occurring during system operations of the active database logs;

program instructions to maintain a database log history table, wherein the database log history table captures a threshold count of the active database logs generated by system threads of the database computing system;

program instructions to define a temporary location for archiving the active database logs based on the switched archive units of the database computing system, and the maintained threadhold count of active database logs in the database log history table due to full database log condition occurring during system operations of the database computing system, program instructions to determine if a system failure or database log condition is caused by the system threads that generates active database logs faster than the active database logs are archived in the temporary location; and

program instructions to suspend generation of the active database logs by the system threads, if the system threads generates final active database logs of the active database logs faster than the database computing system.

9. The computer system according to claim 8 further includes:

program instructions to determine a cause of a system failure or database log condition due to the full database log condition occurring during system operations of the active database logs, wherein archiving of the active database logs to the temporary location occurs without suspending or halting system operations of the database computing system.

10. The computer system according to claim 9 , wherein the cause of the system failure or database log condition is not addressed until the active database logs reaches a final active database log status, wherein the active database logs are archived in the temporary location when the active database logs reaches the final active database log status, and wherein the final active database log status is based on another threadhold count of active database log records.

11. The computer system according to claim 10 , wherein the temporary location includes a record of dataset that includes the active database logs, and a record of dataset that includes boot strap data of the archived active database logs of the temporary location.

12. The computer system according to claim 8 , wherein the system thread with the highest number of active database logs is suspended based on a threadhold of a count of the active database logs in a database log history table.

13. The computer system according to claim 12 , wherein a database log history table maintains a record of active and suspended system threads.

14. The computer system according to claim 8 , wherein program instructions to determine if a system failure or database log condition is caused by the system threads that generates active database logs faster than the active database logs are archived in the temporary location, further includes:

program instructions to search a database log history table for a record of active and suspended system threads of the database computing system; and

program instructions to archive final active database logs in the temporary location.

15. A computer program product for preventing suspension of transactions in a database computing system by monitoring active database logs of the database computing system, the computer program product comprising:

one or more computer-readable tangible storage devices and program instructions stored on at least one of the one or more storage devices, the program instructions comprising:

program instructions to switch archive units of the database;

computing system due to full database log condition occurring during system operations of the active database logs;

program instructions to maintain a database log history table, wherein the database log history table captures a threshold count of the active database logs generated by system threads of the database computing system;

program instructions to define a temporary location for archiving the active database logs based on the switched archive units of the database computing system, and the maintained threadhold count of active database logs in the database log history table due to full database log condition occurring during system operations of the database computing system;

program instructions to determine if a system failure or database log condition is caused by the system threads that generates active database logs faster than the active database logs are archived in the temporary location; and

program instructions to suspend generation of the active database logs by the system threads, if the system threads generates final active database logs of the active database logs faster than the database computing system.

16. The computer program product according to claim 15 further includes:

program instructions to determine a cause of a system failure or database log condition due to the full database log condition occurring during system operations of the active database logs, wherein archiving of the active database logs to the temporary location occurs without suspending or halting system operations of the database computing system.

17. The computer program product according to claim 15 , wherein the cause of the system failure or database log condition is not addressed until the active database logs reaches a final active database log status.

18. The computer program product according to claim 17 , wherein the active database logs are archived in the temporary location when the active database logs reaches the final active database log status, and wherein the final active database log status is based on another threadhold count of active database log records.

19. The computer program product according to claim 15 , wherein the temporary location includes a record of dataset that includes the active database logs, and a record of dataset that includes boot strap data of the archived active database logs of the temporary location.

20. The computer program product according to claim 17 , wherein program instructions to determine if a system failure or database log condition is caused by the system threads that generates active database logs faster than the active database logs are archived in the temporary location, further includes:

program instructions to search a database log history table for a record of active and suspended system threads of the database computing system; and

program instructions to archive final active database logs in the temporary location.