Point-in-time copy solutions supported by SFDB tools
Prev Understanding point-in-time copy methods Next

Point-in-time copy solutions supported by SFDB tools

Storage Foundation for Databases (SFDB) tools provide a database-specific command line to create point-in-time copies of your DB2 database. SFDB tools use the underlying features of Storage Foundation to perform these operations.. For ease of use, the SFDB command line enables you to perform the point-in-time copy operations on the DB2 database with fewer steps. Also, the SFDB command line enables you to perform functions specific to DB2 databases.

Table: Comparison of Point-in-time Copy Solutions provides a comparison of the point-in-time copy solutions supported by SFDB tools.

Table: Comparison of Point-in-time Copy Solutions

FlashSnap

Database Storage Checkpoints

Underlying technology

Volume snapshots (third-mirror break-off snapshots)

File system checkpoints

Possibility of off-host processing

Yes

Yes (requires Cluster File System)

Additional storage requirements

Additional mirror plexes are required. Plexes are full copies of the original data.

Minimal (uses copy-on-write)

Performance impact after taking the point-in-time copy

None

Copy-on-write penalty

Support for multiple clones from a single point-in-time copy

No. However, different mirrors with different snapshots can be used to create multiple clones.

Yes

Supported snapshot modes

Online, Offline

Online, Offline
Prev Up Next
About Storage Foundation point-in-time copy technologies Home About snapshot modes supported by Storage Foundation for Databases (SFDB) tools