Overview of commands<a class="indexterm" name="id450941"></a>


Overview of commands
Prev	Appendix A. Veritas Storage Foundation for DB2 command line interface	Next

Overview of commands

Veritas Storage Foundation for DB2 provides a command line interface (CLI) to many key operations also supplied from within the GUI application. The command line interface lets you incorporate command operations into scripts and other administrative processes. These commands can be executed using the CLI or the Veritas Storage Foundation for DB2 GUI.

Note:

The Veritas Storage Foundation for DB2 command line interface depends on certain tablespace, datafile, or container information (depending on your database) that is collected and stored in the SFDB repository. Some CLI commands update the repository by default. It is important to regularly ensure the repository is up-to-date by using the db2ed_update command.

All Veritas Storage Foundation for DB2 commands supported in the command line interface are located in the /opt/VRTS/bin directory. Online manual pages are located in the /opt/VRTS/man directory. Follow the installation instructions provided in the Veritas Storage Foundation Installation Guide to ensure you can use these commands and view the online manual pages.

Note:

The commands ending with _all apply to multiple partitions of a partitioned DB2 database on the same host.

Table: Veritas Storage Foundation for DB2 commands summarizes the commands available to you from the command line.

Table: Veritas Storage Foundation for DB2 commands

Command

Description

db2ed_update and db2ed_update_all

Updates the repository in Veritas Storage Foundation for DB2.

db2ed_update_all updates the repository in Veritas Storage Foundation for DB2 for a partitioned DB2 database in a symmetric multiprocessing (SMP) environment.

db2ed_checkconfig and db2ed_checkconfig_all

Checks the configuration of a DB2 database in a Veritas Storage Foundation environment.

db2ed_checkconfig_all checks the configuration of the DB2 database for a partitioned DB2 database in an SMP environment.

db2ed_saveconfig and db2ed_saveconfig_all

Saves the configuration of a DB2 database in a Veritas Storage Foundation environment.

db2ed_saveconfig_all saves the configuration of a DB2 database for a partitioned DB2 database in an SMP environment.

db2ed_ckptcreate and db2ed_ckptcreate_all

Creates a Storage Checkpoint for a DB2 database.

db2ed_ckptcreate_all creates a Checkpoint for a partitioned DB2 database.

db2ed_ckptdisplay and db2ed_ckptdisplay_all

Displays Storage Checkpoints for a DB2 database.

db2ed_ckptdisplay_all displays Checkpoints for the current partitioned DB2 database.

db2ed_ckptmount and db2ed_ckptmount_all

Mounts a Storage Checkpoint for a DB2 database.

db2ed_ckptmount_all mounts all Storage Checkpoints for a Checkpoint for a partitioned DB2 database.

db2ed_ckptpolicy

Creates and administers Storage Checkpoint allocation policies for a Multi-Volume File System (MVS). You can display, create, update, assign, and remove Storage Checkpoint allocation policies using this command.

db2ed_ckptquota

Administers quotas for Storage Checkpoints.

db2ed_ckptremove and db2ed_ckptremove_all

Removes a Storage Checkpoint for a DB2 database.

db2ed_ckptremove_all removes a Checkpoint for a partitioned DB2 database.

db2ed_ckptrollback and db2ed_ckptrollback_all

Rolls back a DB2 database to a Storage Checkpoint point-in-time image.

db2ed_ckptrollback_all rolls back a a partitioned DB2 database to a Checkpoint.

db2ed_ckptumount and db2ed_ckptumount_all

Unmounts a Storage Checkpoint for a DB2 database.

db2ed_ckptumount_all unmounts a Checkpoint for a partitioned DB2 database.

db2ed_clonedb

Creates a copy of a DB2 database by cloning all existing database containers. This cloned database can only be started on the same host as the existing database.

qio_convertdbfiles

Note:

This command is not available on AIX and Linux.

Converts DB2 container files to Quick I/O files.

Note:

Storage Foundation for DB2 does not support Quick I/O for DB2 9.5.

qio_getdbfiles

Extracts information on files used by the database and stores the names of these files in mkqio.dat.

The mkqio.dat file is used by the qio_convertdbfiles command.

qio_recreate

Automatically recreates Quick I/O files when the database is recovered. The command expects to find a mkqio.dat file in the directory where the qio_recreate command is run.

db2ed_vmchecksnap

Creates and validates a snapplan that the db2ed_vmsnap command uses to create a volume snapshot of a DB2 database. The snapplan specifies snapshot scenarios (such as online_snapshot, online_mirror, or offline). The command can also be used to validate, list, copy, and remove a snapplan.

db2ed_vmsnap

Creates a snapshot image of a DB2 database by splitting the mirror volumes used by the database. You can also use this command to resynchronize the snapshot image back to the current database. The command also allows you to reverse resynchronize a snapshot image of an DB2 database.

db2ed_vmclonedb

Mounts the file systems on the snapshot volumes and starts a clone database from snapshot volumes. You can also use this command to shut down or restart the clone database, unmount the file systems, or deport the clone database's volumes.

edgetmsg2

Manages message log files. You can use this utility to display and list message log files. You can also use this utility to write a message to a log file or to the console, or read the log file and print to the console.

vxstorage_stats

Displays storage object I/O statistics.