Veritas Storage Foundation 5.1 SP1 Advanced Features Administrator"s Guide (5900-1503, April 2011)

Multiple criteria in file placement policy rule

statements

In certain cases, file placement policy rule statements may contain multiple clauses

that affect their behavior. In general, when a rule statement contains multiple

clauses of a given type, all clauses must be satisfied in order for the statement to

be effective. There are four cases of note in which multiple clauses may be used.

Multiple file selection criteria in SELECT statement clauses

Within a single SELECT statement, all the selection criteria clauses of a single type

are treated as a selection list. A file need only satisfy a single criterion of a given

type to be designated.

In the following example, files in any of the db/datafiles, db/indexes, and

db/logs directories, all relative to the file system mount point, would be selected:

<DIRECTORY Flags="nonrecursive">db/datafiles</DIRECTORY>

<DIRECTORY Flags="nonrecursive">db/indexes</DIRECTORY>

</SELECT>

This example is in direct contrast to the treatment of selection criteria clauses of

different types. When a SELECT statement includes multiple types of file selection

criteria, a file must satisfy one criterion of each type in order for the rule's action

statements to apply.

In the following example, a file must reside in one of db/datafiles, db/indexes,

or db/logs and be owned by one of DBA_Manager, MFG_DBA, or HR_DBA to be

designated for possible action:

<DIRECTORY Flags="nonrecursive">db/datafiles</DIRECTORY>

<DIRECTORY Flags="nonrecursive">db/indexes</DIRECTORY>

<USER>DBA_Manager</USER>

</SELECT>

If a rule includes multiple SELECT statements, a file need only satisfy one of them

to be selected for action. This property can be used to specify alternative conditions

for file selection.

373Administering SmartTier

Multiple criteria in file placement policy rule statements