7.7.1.7.25 type Attribute

Purpose

The type attribute enables you to create a profile, or template, to ease management and configuration of resource plans in environments with many databases.

Syntax

 ALTER IORMPLAN 
   dbplan=(( name=db_name, ... type={database|profile} ... ) ... )

Usage Notes

• type: Specifies the directive type. Valid values are database or profile:

  • type=database: Specifies a directive that applies to a specific database. If type in not specified, then the directive defaults to the database type.

  • type=profile: Specifies a directive that applies to a profile rather than a specific database. To associate a database with an IORM profile, you must set the database initialization parameter db_performance_profile to the value of the profile name. Databases that map to a profile inherit the settings specified in the profile.

    A profile directive can contain any attributes except level, allocation, asmcluster, and role.

    A profile name cannot be OTHER or DEFAULT.

• The dbplan can contain a combination of profile and database directives.

Example 7-56 Creating a Profile

This example shows how to specify profiles as part of a database plan.

CellCLI> ALTER IORMPLAN                                -
         dbplan=((name=gold, share=10, type=profile),  -
                 (name=silver, share=5, type=profile), -
                 (name=bronze, share=1, type=profile))