Scalable Database Server, HiRDB Version 8 Description

[Contents][Glossary][Index][Back][Next]

7.2.4 Backup-hold

When a backup is made with a command other than the pdcopy command (i.e., when another product's backup facility is used), the RDAREAs should be placed on backup-hold. An RDAREA on backup-hold can be backed up using the backup facility of another product while HiRDB is running. To place an RDAREA on backup-hold, you specify the -b option in the pdhold command.

Organization of this subsection
(1) Application example of backup-hold
(2) Backup-hold types

(1) Application example of backup-hold

If you execute the pdcopy command in updatable mode, you must place the RDAREA to be backed up on backup-hold (-b u or -b wu).

(2) Backup-hold types

Table 7-3 lists and describes the four types of backup-hold.

Table 7-3 Types of backup-hold

Backup-hold type Explanation
Referencing-permitted backup-hold During backup-hold, RDAREAs that have been backed up and held can be referenced; an updating attempt will result in an SQL error (-920).
Referencing-permitted backup-hold (update WAIT mode) During backup-hold, RDAREAs that have been backed up and held can be referenced; an updating attempt goes onto lock-release wait status until the backup-hold is released.
Updatable backup-hold During backup-hold, RDAREAs that have been backed up and held can be referenced and updated. Even while an updating transaction is being executed, an RDAREA is placed immediately on updatable backup-hold status without placing the pdhold command on wait status.
Updatable backup-hold (WAIT mode) During backup hold, RDAREAs that have been backed up and held can be referenced and updated. If an updating transaction is being executed, the pdhold command is kept waiting until the transaction terminates.

For details about how to make a backup using the backup shutdown, see the HiRDB Version 8 System Operation Guide.

Reference note
Reference-possible backup hold and reference-possible backup hold (update WAIT mode) are also referred to as committing a database.