Tasks for setting up new databases

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.

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.

Create the VxFS file systems you need on the volumes.

See Creating a VxFS file system .

Install and configure your database.

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

See About Quick I/O.

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 About Storage Mapping .

If you want to use Database FlashSnap for off-host processing after converting your database files to use Quick I/O or ODM and your volume layout is inconsistent with Database FlashSnap requirements, you will need to "relayout" your volume manager configuration after your database files have been converted.

See the Veritas Volume Manager Administrator's Guide.

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

See the Veritas Storage Foundation for DB2 Installation 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 About Storage Checkpoints and Storage Rollback.

More Information

File system creation guidelines