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 calls db2ed_update on every database partition 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 calls db2ed_checkconfig on every database partition 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 calls db2ed_saveconfig on every database partition 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 Version Checkpoint for a partitioned DB2 database. db2ed_ckptcreate_all calls db2ed_ckptcreate on every database partition.

db2ed_ckptdisplay and db2ed_ckptdisplay_all

Displays Storage Checkpoints for a DB2 database.

db2ed_ckptdisplay_all displays Version 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 Version 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 Version 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 Version Checkpoint. The db2ed_ckptrollback_all command calls db2ed_ckptrollback on every partition.

db2ed_ckptumount and db2ed_ckptumount_all

Unmounts a Storage Checkpoint for a DB2 database.

db2ed_ckptumount_all unmounts a Version 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.

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.