Relocating files for Database Dynamic Storage Tiering using dbdst_file


Relocating files for Database Dynamic Storage Tiering using dbdst_file_move
Prev	About the command line interface	Next

Use the dbdst_file_move command to relocate archive logs, datafiles, and external files if the files are no longer being used frequently.

Table: dbdst_file_move command options shows the dbdst_file_move command options.

Table: dbdst_file_move command options

Option	Description
-o external \| datafile	Specifies whether to move external files or datafiles. Use this option with the -f option.
-o archive1 \| archive2	Specifies which archive logs to move. Do not use this option with the -f option. This is supported by DB2 8.2 or later.
-f listfile	Specifies a listfile that contains a list of files or directories to be moved.
*-c class[:days]*	Specifies the storage class to which the files should be moved. If the days option is used, the files will be moved to the class specified if they have not been accessed in the number of days specified. Do not specify days if you are using the -o datafile option.
-R	Removes the policy for the specified object.

Before relocating a file, review the following information:

Prerequisites	The database must be up when you run this command.
Usage notes	Multiple partitions cannot reside on the same tablespace.

To relocate a file

Use the dbdst_file_move command as follows:

/opt/VRTS/bin/dbdst_file_move -D DB2DATABASE -o datafile \
-f listfile -c storage_class:days [-c storage_class:days]

Prev	Up	Next
Removing volumes from a storage class for Database Dynamic Storage Tiering using dbdst_rmvol	Home	Relocating tablespaces for Database Dynamic Storage Tiering using dbdst_tbs_move