1. User's Guide
  2. Using the CellCLI Utility
  3. CellCLI Command Reference
  4. ALTER
  5. ALTER IORMPLAN
  6. type Attribute

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

Parent topic: ALTER IORMPLAN