Data Director system administrators convert base DBVMs into base DB templates to provide the blueprints for creating databases.

When you convert a base DBVM to a DB template, you can define the storage structure and disk layout that best suits your database deployment's workloads and use cases. Before converting a base DBVM to a DB template, carefully consider the storage requirements for the database you are deploying. Refer to the database vendor's documentation for information on storage capacity planning as it relates to storage usage, I/O, and redundancy.

The running status of a base DB template depends upon the status of the base DBVM from which it is created. When you convert a running base DBVM to a base DB template, after conversion the status of the base DB template is Running. When you convert a base DBVM that is powered-off to a base DB template, after conversion the status of the base DB template is Powered-off.

The operating system and database software is installed in the base DBVM.

You know the file path location of the virtual disks available for use by Data Director, and understand the vSphere disk provisioning types. See Disk Configuration for DBVMs.

Understand how to assign your database's data and log files to the specified virtual disks for optimal storage usage and performance.

1

Log in to Data Director as a system administrator.

2

Click the Manage and Monitor tab and expand Templates.

3

Select Base DBVMs.

4

Select the base DBVM to convert.

5

Click the gear icon and select Convert to Base DB Template.

6

In the Convert to Base DB Template wizard, provide the appropriate information.

Option

Action

Name

Enter a unique name for the base DB template.

Description

(Optional) Enter a description of the base DB template.

Save the source DBVM (clone before converting)

Click the checkbox to retain the source base DBVM for future use.

Disk Layout

Specify the virtual disks to use for this DB template.

Display Name

Type a name to identify the virtual disk within Data Director.

Disk Type

From the drop-down menu, select the type of disk , either Data or Log, to assign to this virtual disk.

Path

Type the location of the virtual disk.

Minimum Storage Size

Specify the minimum storage size to allocate for each disk during provisioning.

Provisioning Type

From the drop-down menu, select the virtual disk provisioning type. The provisioning options are Thick Provision Eager Zeroed and Thin Provision.

7

Click OK.

When conversion is finished, the base DB template appears in the Base DB Templates list.

You can validate the base DB templates you create for Oracle, MySQL, and vFabric Postgres databases. For more information see Validate a Base DB Template. Template validation is optional.