US 2021/0279142 A1 · DATABASE BACKUP PERFORMANCE

Abstract

The indication of a database backup process starting is received. A plurality of buffer manipulator threads are marked as active. A determination is made whether any of the plurality of buffer manipulator threads marked as active in the database backup process become idle. In response to determining that at least one buffer manipulator thread in the database backup process becomes idle, the at least one idle buffer manipulator thread is reassigned to a first largest tablespace in the database that has not completed the database backup process. The first largest tablespace has a largest storage capacity relative to other tablespaces in the database.

Claims20

Dependent claims

A method, the method comprising:

receiving, by one or more computer processors, an indication of a database backup process starting;
marking, by one or more computer processors, a plurality of buffer manipulator threads as active;
determining, by one or more computer processors, whether any of the plurality of buffer manipulator threads marked as active in the database backup process become idle;
and
responsive to determining that at least one buffer manipulator thread in the database backup process becomes idle, reassigning, by one or more computer processors, the at least one idle buffer manipulator thread to a first largest tablespace in the database that has not completed the database backup process, wherein the first largest tablespace has a largest storage capacity relative to other tablespaces in the database.

2 more elements

A computer program product, the computer program product comprising:

one or more computer readable storage media;
and
program instructions stored on the one or more computer readable storage media, the program instructions comprising:
program instructions to receive an indication of a database backup process starting;
program instructions to mark a plurality of buffer manipulator threads as active;
program instructions to determine whether any of the plurality of buffer manipulator threads marked as active in the database backup process become idle;
and
responsive to determining that at least one buffer manipulator thread in the database backup process becomes idle, program instructions to reassign the at least one idle buffer manipulator thread to a first largest tablespace in the database that has not completed the database backup process, wherein the first largest tablespace has a largest storage capacity relative to other tablespaces in the database.

5 more elements

A computer system, the computer system comprising:

one or more computer processors;
one or more computer readable storage media;
and
program instructions stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising:
program instructions to receive an indication of a database backup process starting;
program instructions to mark a plurality of buffer manipulator threads as active;
program instructions to determine whether any of the plurality of buffer manipulator threads marked as active in the database backup process become idle;
and
responsive to determining that at least one buffer manipulator thread in the database backup process becomes idle, program instructions to reassign the at least one idle buffer manipulator thread to a first largest tablespace in the database that has not completed the database backup process, wherein the first largest tablespace has a largest storage capacity relative to other tablespaces in the database.

6 more elements

Dependencies are inferred from the claim text.

Database backup performance

Life of this patent

Database backup performance

Life of this patent

Abstract

Claims20