7.7.1.7.5 share Attribute

Purpose

The share attribute controls share-based resource allocation, which specifies the relative priority for a database in a dbplan or a cluster in a clusterplan. A higher share value implies higher priority and more access to the I/O resources.

Syntax

 ALTER IORMPLAN 
   dbplan=(( name=db_name, ... share=number ... ) ... )

 ALTER IORMPLAN 
   clusterplan=(( name=cluster_name, ... share=number ... ) ... )

Usage Notes

• share: Specifies the resource allocation share.

  Valid values are 1 to 32, with 1 being the lowest share, and 32 being the highest share. The share value represents the relative importance of each entity. A higher share value implies higher priority and more access to resources. The sum of all share values in a plan cannot be greater than 32768.

• For share-based resource allocation, name=DEFAULT is used to define the default share for each entity that is not specified in the IORM plan.

• Share-based resource allocation is the recommended method for a database plan (dbplan). For a cluster plan (clusterplan), share-based resource allocation is the only option.

Example 7-43 Setting a Database Plan Using the share Attribute

This example shows how to configure dbPlan using the share attribute.

CellCLI> ALTER IORMPLAN                                                 -
         dbplan=((name=sales01, share=4),                               -
                 (name=sales02, share=4),                               -
                 (name=fin01, share=3),                                 -
                 (name=fin02, share=2),                                 -
                 (name=dev01, share=1, limit=50, flashLog=off),         -
                 (name=dev02, share=1, limit=25, flashCache=off),       -
                 (name=DEFAULT, share=2))