Veritas Storage Foundation for DB2 Administrator's Guide 5.0 MP3 - AIX

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



Description



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 Quick I/O
About Veritas Cached Quick I/O
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)
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
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
Reconfiguring virtual IP address for repository configuration
Accessing an off-host repository in a non-VCS environment
About Quick I/O
How Quick I/O works
How Quick I/O improves database performance
About Quick I/O requirements
How to set up Quick I/O
Creating database containers as Quick I/O files using qiomkfile
Preallocating space for Quick I/O files using the setext command
Accessing regular VxFS files as Quick I/O files
Converting DB2 containers to Quick I/O files
About sparse files
Displaying Quick I/O status and file attributes
Extending a Quick I/O file
Monitoring tablespace free space with DB2 and extending tablespace containers
Recreating Quick I/O files after restoring a database
Disabling Quick I/O
About Cached Quick I/O
How Cached Quick I/O works
How Cached Quick I/O improves database performance
How to set up Cached Quick I/O
Enabling Cached Quick I/O on a file system
Enabling and disabling the qio_cache_enable flag
Making Cached Quick I/O settings persistent across reboots and mounts
Using vxtunefs to obtain tuning information
Determining candidates for Cached Quick I/O
Collecting I/O statistics
About I/O statistics
Effects of read-aheads on I/O statistics
Other tools for analysis
Enabling and disabling Cached Quick I/O for individual files
Setting cache advisories for individual files
Making individual file settings for Cached Quick I/O persistent
Determining individual file settings for Cached Quick I/O using qioadmin
About Concurrent I/O
How Concurrent I/O works
Enabling and disabling Concurrent I/O
Enabling Concurrent I/O
Disabling Concurrent I/O
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
About converting LVM volume groups to VxVM disk groups
Upgrading from earlier VxFS version layouts
Converting from raw devices
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 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
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
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
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
About using Veritas NetBackup to backup and restore Quick I/O files
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 obtaining file I/O statistics using the Quick I/O interface
About I/O statistics data
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
Buffer pools
Memory allocation
TEMPORARY tablespaces
DMS containers
Data, indexes, and logs
Database statistics
About tuning AIX Virtual Memory Manager
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
Identifying VxFS files to convert to Quick I/O using qio_getdbfiles
Converting VxFS files to Quick I/O using qio_convertdbfiles
Recreating Quick I/O files using qio_recreate
About backing up and restoring Quick I/O files using Legato NetWorker
Database FlashSnap snapshot status and database status
Snapshot status details
Database status details

Attachments

sf_db2_admin_aix.pdf (3.2 MBytes)

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


Terms of use for this information are found in Legal Notices