. de IX . ds #H ((1u-(\\n(.fu%2u))*.13m) . ds ’ \k:' test veritas logo


vxsfadm-db2(1M)

NAME

vxsfadm - Generic Utility which does various point in time copy operations for various applications (including DB2) using storage foundation features.

SYNOPSIS

vxsfadm -s <service_type> -a db2 -o <operation>
[ -c config-file ]
[ -r Respository-host ]
[ service specific parameters ]
[ db2 specific parameters ]

vxsfadm [-s <service-type>] -a db2 -o list
[ service specific parameters ]
[ db2 specific parameters ]

vxsfadm -s <service-type> -a db2 -o setdefaults
[ service specific parameters ]
[ db2 specific parameters ]

DESCRIPTION

vxsfadm is a single cli to execute the various point in time copy operation. Currently supported services for DB2 are flashsnap and checkpoint. Currently supported applicationss are Oracle and DB2 databases. The utility works for single partition DB2 database versions 9.5 and 9.7.

This command is expected to be run by the DB2 instance owner only.

PREREQUISITES

To be able to use the various snapshot services, some pre-requisites must be satisfied:

The following database layouts are supported:
o All database files must be on VxFS filesystems. These include all paths listed in the SYSIBMADM.DB_PATHS view. All the underlying volumes must be VxVM volumes. For Flashsnap, and when snapshotting archived logs, the archive log location must be on VxFS on a separate VxVM volume.

OPTIONS

Following are the paramters for a DB2 database. For other generic command-line options/ parameters, refer to vxsfadm (1M) man page.
<DB2 specific parameters >
APP_MODE The parameter APP_MODE specifies the snapshot mode to be used when taking a snapshot using any of the available snapshot services viz. Flashsnap or Checkpoint.

The available snapshot modes are summarized below and more information is available in the DB2 guide for Storage Foundation:

online This is the default and the recommended snapshot mode. In this mode, the DB2 database is put into write suspend mode during the snapshot operation.
offline In this mode, the database is required to be offline during the snapshot operation.
Note: To use offline snapshot mode, the user must validate the database configuration once when the database is online. Once the database configuration is validated, a snapshot can be taken after shutting down the database.

SEE ALSO

vxsfadm-flashsnap(1M), vxsfadm-checkpoint(1M) vxsfadm-db2-flashsnap(1M), vxsfadm-db2-checkpoint(1M)


Storage Foundation vxsfadm-db2(1M)