Archival management of database logs

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 determine a cause of system failure or database log condition due to the full database log condition occurring during system operations of the active database logs;
• program instructions to archive the active database logs to a temporary location without suspending or halting system operations of the database computing system, 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;
• and
• program instructions to define a position in the 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, 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.

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 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 determine a cause of system failure or database log condition due to the full database log condition occurring during system operations of the active database logs;
• program instructions to archive the active database logs to a temporary location without suspending or halting system operations of the database computing system, 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;
• and
• program instructions to define a position in the 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, 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.