InfoScale™ 9.0 Storage and Availability Management for DB2 Databases - AIX, Linux
- Section I. Storage Foundation High Availability (SFHA) management solutions for DB2 databases
- Overview of Storage Foundation for Databases
- About Veritas File System
- Overview of Storage Foundation for Databases
- Section II. Deploying DB2 with InfoScale products
- Deployment options for DB2 in a Storage Foundation environment
- Deploying DB2 with Storage Foundation
- Deploying DB2 in an off-host configuration with Storage Foundation
- Deploying DB2 with High Availability
- Deployment options for DB2 in a Storage Foundation environment
- Section III. Configuring Storage Foundation for Database (SFDB) tools
- Configuring and managing the Storage Foundation for Databases repository database
- Configuring the Storage Foundation for Databases (SFDB) tools repository
- Configuring authentication for Storage Foundation for Databases (SFDB) tools
- Configuring and managing the Storage Foundation for Databases repository database
- Section IV. Improving DB2 database performance
- About database accelerators
- Improving database performance with Quick I/O
- About Quick I/O
- Improving DB2 database performance with Veritas Concurrent I/O
- Section V. Using point-in-time copies
- Understanding point-in-time copy methods
- Volume-level snapshots
- Storage Checkpoints
- Considerations for DB2 point-in-time copies
- Administering third-mirror break-off snapshots
- Administering Storage Checkpoints
- Database Storage Checkpoints for recovery
- Backing up and restoring with Netbackup in an SFHA environment
- Understanding point-in-time copy methods
- Section VI. Optimizing storage costs for DB2
- Section VII. Storage Foundation for Databases administrative reference
- Storage Foundation for Databases command reference
- Tuning for Storage Foundation for Databases
- Troubleshooting SFDB tools
Backing up and recovering a VxVM volume using NetBackup
To enable NetBackup to backup objects on a VxVM volume, use the following procedure. This procedure enables an Instant Recovery (IR) using a VxVM volume.
To back up objects in a VxVM volume using NetBackup
- Create a VxVM disk group with six disks. The number of disks may vary depending on the volume size, disk size, volume layout, and snapshot method.
If the system this test is running on is a clustered system, create a shared disk group using the -s option.
# vxdg -s init database_dg disk1 disk2 disk3 \ disk4 disk5 disk6
- Create a "mirror-striped" VxVM volume with a size of 10 Gbytes or the maximum size of the disk, whichever is larger.
# vxassist -g database_dg make vol_name 10G \ layout=mirror-stripe init=active # vxvol -g database_dg set fastresync=on vol_name # vxassist -g database_dg snapstart nmirror=1 vol_name
Note:
There are three types of snapshots: mirror, full-size instant, and space-optimized instant shanpshots. The example uses an Instant Recovery (IR) snapshot. For snapshot creation details, refer to the NetBackup Snapshot Client Administrator's Guide.
- Make the file system on the volume.
- Mount a VxFS file system on the volume.
If the VxVM volume is a clustered volume, mount the VxFS file system with the "-o cluster" option.
- Fill up the VxFS file system up to the desired level. For example, you can fill to 95% full, or to whatever level is appropriate for your file system.
- Store the cksum(1) for these files.
- Un-mount the VxFS file system.
- Enable the following Advanced Client option:
Perform Snapshot Backup.
Set Advanced Snapshot Options to vxvm.
Enable Retain snapshots for instant recovery.
- Back up the VxVM volume with the NetBackup policy.
For details, refer to the NetBackup Snapshot Client Administrator's Guide.