BackupFailThreshold
The BackupFailThreshold
connection attribute enables you to ensure the safe completion of your backup.
This connection attribute controls the number of transaction log files that accumulate in the directory defined by the value of the LogDir
attribute after a backup starts before TimesTen releases the hold on checkpoint operations. If a checkpoint is initiated before the completion of a backup, the backup is invalidated.
TimesTen temporarily ignores the CkptFrequency and CkptLogVolume attributes (controlling background checkpoints) while a backup is in progress if this attribute is not set or is set to 0
.
Set the attribute to a value that is high enough to ensure the safe completion of your backup. For example, if a backup typically takes n seconds to complete and your database creates m transaction log files per second, set BackupFailThreshold
to a value greater than n*
m.
The number of log files generated by your database per any given unit of time is directly proportional to your write workload and inversely proportional to the value set for the LogFileSize attribute.
Required Privilege
Only the instance administrator can change the value of this attribute.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.Setting
Set BackupFailThreshold
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
Enter a non-zero integer value that indicates the number of transaction log files that are allowed to accumulate before the backup fails. The default is |
Windows ODBC Data Source Administrator |
Not applicable |