Using preset policies

Use the dbdst_preset_policy command to set a policy based on file name patterns before the files are created.

Table: dbdst_preset_policy command options shows the dbdst_preset_policy command options.

Table: dbdst_preset_policy command options

Option

Description

-d directory

Indicates the directory on which the placement policy will be applied.

-o sms | ats

Specifies file placement for a SMS tablespace or DB2 automatic storage path.

-s

Displays the most commonly used file name patterns for DB2 SMS tablespaces or DB2 automatic storage paths. Use this option with the -o sms | ats option.

-t tablespace

Specifies the SMS tablespace when using the -o sms option.

-e

Enforces the file system of the specified directory. Use this option if there was an error in the previous enforcement that has been corrected and needs to be enforced again.

-R

Removes all pattern-based placement policies related to this directory.

-l

Lists the existing file placement that is set to the specified directory.

-P pattern_spec

Specifies file patterns and class assignment. This option will automatically place files in the desired class as soon as they are created. Existing files and newly created files will be moved immediately to the class specified.

-f pattern_file

Specifies a file that contains a particular class and pattern. New files with this pattern will be placed in the class immediately. Existing files will be moved as well.

-E

Specifies that existing files should be moved to the designated class in a one-time move to be scheduled at a later time, which is the sweeptime specified in the dbdst_admin command.

To create a preset policy

To create a preset policy for a SMS tablespace or automatic storage path

To display the most commonly used file name patterns for SMS tablespaces or automatic storage paths