Database management tasks in the Veritas Storage Foundation for DB2 GUI

If you are using Veritas Storage Foundation for DB2 to set up a new database, complete these tasks in the order listed below:

Determine the number and sizes of file systems you need for the database you want to create.

See the Veritas File System Administrator's Guide.

Create volumes to meet your file system needs. You can use disk mirroring as a safeguard against disk failures and striping for better performance.

See "Tuning for Performance" in the Veritas Storage Foundation for DB2 Administrator's Guide.

If you plan to create volume snapshots for the database and use them on either the same host or a secondary one, ensure that your volume layout is consistent with Database FlashSnap requirements.

See Database FlashSnap in the GUI.

Create the VxFS file systems you need on the volumes

See "Setting up databases" in the Veritas Storage Foundation for DB2 Administrator's Guide.

Install and configure your database.

For best OLTP performance, use Quick I/O.

You must create Quick I/O files before creating the tablespaces.

Note:

The Quick I/O feature is not available on the Linux operating system.

See the Veritas Storage Foundation for DB2 Administrator's Guide.

If you would like the ability to view detailed storage stack topology information to ensure your storage stack configuration is optimized for the database, configure and use Storage Mapping.

See Viewing Storage Mapping.

If you are using Quick I/O, convert all database files to Quick I/O files.

See Converting regular containers to Quick I/O Files.

If using ODM, link the ODM library.

See the Veritas Storage Foundation for DB2 Administrator's Guide.

If you are not currently running on VxVM and VxFS, make sure Veritas Storage Foundation for DB2 is installed and covert your existing database configuration.

See the Veritas Storage Foundation for Oracle DB2 Installation Guide.

See the Veritas Storage Foundation forDB2 Administrator's Guide.

For backup and recovery on the same host, you can use the Storage Checkpoint facility to create file system snapshots of the database. A Storage Checkpoint creates an exact image of a database instantly and provides a consistent image of the database from the point in time the Storage Checkpoint was created.

See Creating a Storage Checkpoint.

For off-host processing or backup, you can use the Database FlashSnap feature to create a volume snapshot for the database. Database FlashSnap lets you capture an online image of an actively changing database at a given instant, known as a snapshot. You can perform backups and off-host processing tasks on snapshots while providing continuous availability of your critical data.

See Database FlashSnap in the GUI.