Veritas Storage Foundation for DB2 Administrator's Guide 5.0 RU3 - Linux for IBM Power

Article:DOC3049  |  Created: 2010-09-23  |  Updated: 2010-09-23  |  Article URL http://www.symantec.com/docs/DOC3049
Article Type
Documentation



Description



Table of Contents:
Technical Support
1. Introducing Veritas Storage Foundation for DB2
About Veritas Storage Foundation for DB2
Components of Veritas Storage Foundation for DB2
How Veritas Volume Manager works
About volumes
About disk groups
About volume layouts
About online relayout
About volume resynchronization
About dirty region logging
About volume sets
About volume snapshots
About Veritas FastResync
About disk group split and join
About hot-relocation
About DMP-supported disk arrays
About dynamic LUN expansion
About Storage Expert
About cluster functionality (optional)
About Veritas Volume Replicator (optional)
How Veritas File System works
About Veritas Concurrent I/O
About extent-based allocation
About fast file system and database recovery
About online system administration
About cross-platform data sharing
Support for multi-volume file systems
Support for large file systems and large files (optional)
About Storage Checkpoints and Storage Rollback
About restoring file systems using Storage Checkpoints
About quotas
About cluster functionality (optional)
How Veritas Storage Mapping works
How Veritas Database FlashSnap works
How Database Dynamic Storage Tiering works
About the vxdbd daemon
About Veritas Storage Foundation for DB2 graphical user interface
About Veritas NetBackup (optional)
About Veritas Storage Foundation/High Availability for DB2 (optional)
2. Setting up databases
Tasks for setting up new databases
About setting up a disk group
Disk group configuration guidelines
Creating a disk group
Adding disks to a disk group
About selecting a volume layout
How to choose appropriate stripe unit sizes
How to choose between mirroring and RAID-5
Volume configuration guidelines
Creating a volume
Creating a volume set
Adding a volume to a volume set
File system creation guidelines
Creating a VxFS file system
Large file system and large file support
Multi-volume support
Mounting a file system
Unmounting a file system
About fragmentation
How to control fragmentation
Types of fragmentation
How to monitor fragmentation
Defragmenting a file system
Resizing a file system
Resizing a file system and the underlying volume
3. Managing the SFDB repository
About the SFDB repository
Runtime management tasks for the SFDB repository
Starting, stopping, and checking the SFDB repository with sfua_db_config
Backing up and restoring the SFDB repository with sfua_rept_adm
Monitoring free space for the SFDB repository
Adding a new system to an HA configuration
Accessing an off-host repository in a non-VCS environment
4. Using Veritas Concurrent I/O
About Concurrent I/O
How Concurrent I/O works
Enabling and disabling Concurrent I/O
Enabling Concurrent I/O
Disabling Concurrent I/O
5. Using Storage Mapping
About Storage Mapping
Verifying Veritas Storage Mapping setup
Using vxstorage_stats
Finding container information for DB2 UDB
Displaying Storage Mapping information for DB2 containers
Displaying I/O statistics information
About arrays for Storage Mapping and statistics
6. Converting existing database configurations to VxFS
About converting LVM volume groups to VxVM disk groups
Upgrading from earlier VxFS version layouts
Converting from raw devices
7. Using Storage Checkpoints and Storage Rollback
About Storage Checkpoints and Storage Rollback
How Storage Checkpoints and Storage Rollback work
Space requirements for Storage Checkpoints
Performance of Storage Checkpoints
Storage Checkpoint allocation policies
Using Storage Checkpoint allocation policies
Partitioned databases and Version Checkpoints
Backing up and recovering the database using Storage Checkpoints
Verifying a Storage Checkpoint using the command line
Backing up using a Storage Checkpoint
Recovering a database using a Storage Checkpoint
Cloning the DB2 database using db2ed_clonedb
Guidelines for DB2 recovery
Using the GUI to perform Storage Checkpoint-related operations
8. Using Database Dynamic Storage Tiering
About Database Dynamic Storage Tiering
Database Dynamic Storage Tiering building blocks
Database Dynamic Storage Tiering in a High Availability (HA) environment
Configuring Database Dynamic Storage Tiering
Database Dynamic Storage Tiering command requirements
Defining database parameters
Setting up storage classes
Converting a VxFS file system to a VxFS multi-volume file system
Classifying volumes into a storage class
Displaying free space on your storage classes
Adding new volumes to a storage class
Removing volumes from a storage class
Dynamic Storage Tiering policy management
Relocating files
Relocating tablespaces
Using preset policies
Running Database Dynamic Storage Tiering reports
Viewing modified allocation policies
Viewing audit reports
Extent balancing in a database environment
Extent balancing file system
Database Dynamic Storage Tiering use cases for DB2
Creating a preset placement policy for a DB2 SMS tablespace and DB2 automatic storage path
Migrating existing partitioned data in a DB2 database
Scheduling the relocation of archive logs
9. Using Database FlashSnap for backup and off-host processing
About Veritas Database FlashSnap
Typical database problems solved with Database FlashSnap
About Database FlashSnap applications
Database FlashSnap
Database FlashSnap commands
Database FlashSnap options
How to plan for Database FlashSnap
Snapshot mode
One or two snapshot hosts
Hosts and storage for Database FlashSnap
Single-host configuration
Two-host configuration
Host and storage requirements
Creating a snapshot mirror of a volume or volume set used by the database
Upgrading existing volumes to use with Database FlashSnap for DB2
Summary of database snapshot steps
Creating a snapplan (db2ed_vmchecksnap)
Creating multi-mirror snapshots
Validating a snapplan (db2ed_vmchecksnap)
Displaying, copying, and removing a snapplan (db2ed_vmchecksnap)
Creating a snapshot (db2ed_vmsnap)
Backing up the database from snapshot volumes (db2ed_vmclonedb)
Mounting the snapshot volumes and backing up
Restoring from backup
Cloning a database (db2ed_vmclonedb)
Using Database FlashSnap to clone a database
Shutting down the clone database and unmounting file systems
Restarting a clone database
Resynchronizing the snapshot to your database
Resynchronizing your database to the snapshot
Removing a snapshot volume
Using Database FlashSnap in an HA environment
10. Using Veritas NetBackup for database backup
Components of Veritas NetBackup
About using Veritas NetBackup for backup and restore
About performing a backup
About configuring Veritas NetBackup for a DB2 EEE (DPF) environment
11. Tuning for performance
Additional documentation
About tuning VxVM
About obtaining volume I/O statistics
About tuning VxFS
How monitoring free space works
How tuning VxFS I/O parameters works
About tunable VxFS I/O parameters
About I/O statistics
About tuning DB2 databases
DB2_USE_PAGE_CONTAINER_TAG
DB2_PARALLEL_IO
PREFETCHSIZE and EXTENTSIZE
INTRA_PARALLEL
NUM_IOCLEANERS
NUM_IOSERVERS
CHNGPGS_THRESH
Table scans
Asynchronous I/O
Memory allocation
TEMPORARY tablespaces
DMS containers
Data, indexes, and logs
Database statistics
A. Veritas Storage Foundation for DB2 command line interface
Overview of commands
Command support
About the command line interface
Updating the repository using db2ed_update
Checking the database configuration environment using db2ed_checkconfig
Saving the database configuration environment using db2ed_saveconfig
Creating Storage Checkpoints using db2ed_ckptcreate
Displaying Storage Checkpoints using db2ed_ckptdisplay
Mounting Storage Checkpoints using db2ed_ckptmount
Unmounting Storage Checkpoints using db2ed_ckptumount
Creating and working with Storage Checkpoint allocation policies using db2ed_ckptpolicy
Administering Storage Checkpoint quotas using db2ed_ckptquota
Performing Storage Rollback using db2ed_ckptrollback
Removing Storage Checkpoints using db2ed_ckptremove
Cloning the DB2 database using db2ed_clonedb
Creating and working with snapplans using db2ed_vmchecksnap
Creating, resynchronizing, or reverse resynchronizing a snapshot database using db2ed_vmsnap
Creating or shutting down a clone database using db2ed_vmclonedb
Managing log files using edgetmsg2
Displaying I/O mapping and statistics using vxstorage_stats
Defining database parameters for Database Dynamic Storage Tiering using dbdst_admin
Setting up storage classes for Database Dynamic Storage Tiering using dbdst_admin
Converting a VxFS file system to a VxFS multi-volume file system for Database Dynamic Storage Tiering using dbdst_convert
Classifying volumes into a storage class for Database Dynamic Storage Tiering using dbdst_classify
Displaying free space on storage classes for Database Dynamic Storage Tiering using dbdst_show_fs
Adding new volumes to a storage class for Database Dynamic Storage Tiering using dbdst_addvol
Removing volumes from a storage class for Database Dynamic Storage Tiering using dbdst_rmvol
Relocating files for Database Dynamic Storage Tiering using dbdst_file_move
Relocating tablespaces for Database Dynamic Storage Tiering using dbdst_tbs_move
B. Veritas Database FlashSnap status information
Database FlashSnap snapshot status and database status
Snapshot status details
Database status details
Glossary
Index

Attachments

sf_db2_admin_lin_50ru3.pdf (2.6 MBytes)

Article URL http://www.symantec.com/docs/DOC3049


Terms of use for this information are found in Legal Notices