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.

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 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