To preset policy for SMS tablespace

1. Access the Database Dynamic Storage Tiering Preset Policy for SMS Tablespace wizard.

   See “To access the tiered storage policy wizards in the Java GUI”.

2. In the Preset Policy for Directory for SMS Tablespacepage, select one SMS Tablespace from the drop-down list.

3. Select Create or modify policy.

4. Click Next. The storage classes and file name patterns display for the selected SMS tablespace.

5. To add a file pattern to a storage class, double-click the cell in the File Pattern column, and enter a file pattern such as *.log, or *.dbf. Use commas to separate each file pattern.

6. To modify a file pattern for a storage class, double-click the cell corresponding to the file pattern and edit the file pattern.

7. To remove a file pattern for a storage class, double-click the cell corresponding to the file pattern and click Remove File Pattern.

8. To remove the policy, select Remove Policy.

9. To set the policy, click Finish.

10. Click Yes to confirm.