Home > Veritas Storage Foundation™ for DB2 Manual Pages
DBDST_FILE_MOVE (1) |
|
User Commands |
Table of contents
dbdst_file_move - move the specified database object or a specific
list of files to the desired storage class if they have not been
accessed for certain period.
dbdst_file_move
-D
.I
\[ -I
DB2INSTANCE
-o archive[n] -c storage-class:days
dbdst_file_move
-D
.I
\[ -I
DB2INSTANCE
-o external -f spec-file -c storage-class:days
dbdst_file_move
-D
.I
\[ -I
DB2INSTANCE
-o datafile -f spec-file -c storage-class
dbdst_file_move
-D
.I
\[ -I
DB2INSTANCE
-o archive[n] -R
dbdst_file_move
-D
.I
\[ -I
DB2INSTANCE
-o external -f spec-file -R
This command is part of Veritas Storage Foundation for DB2.
To determine whether this product is installed on an \1 system, type:
lslpp -L VRTSdb2ed
The dbdst_file_move command is used to move the specified database object
or a specific list of files to the desired storage class if they have not been
accessed for certain period. For datafiles, this command relocates the specified
files in spec-file into the desired storage-class immediately. For
archive and external files, this command schedules a sweep task to be executed at
sweeptime specified via dbdst_admin. For external files and datafiles,
all the files and directories included in the spec-file should reside
on a single filesystem.
The archive[n], should corrospond to archive1 or archive2. This archive_dest path
must be valid and active.
The following options are supported:
-
.\" $Id: dbdst_options.inc,v 1.1 2006/02/16 01:33:08 susanl Exp $
-
-D DB2DATABASE
Specifies the name of the DB2 database for which information will be retrieved.
-
-I DB2INSTANCE
-
Specifies the name of the DB2 instance. If the instance is not specified,
the current user will be used as the instance name.
-
-o archive[n]
-
Specifies to move the archive log files. The values must be archive1 or archive2.
This option should not be used together with the -f option. The storage class
specified should be of the form -c <starage_class>:<days>.
-
-o external
-
Specifies to move external files or datafiles. This option should be used
together with -f option. The storage class specified should be of the form
-c <starage_class>:<days>.
-
-o datafile
-
This option specifies to do a immediate relocation of datafiles specified in spec-file
to the desired class.This option should be used together with -f option. The storage class specified
should be of the form -c <starage_class> only.
-
-f spec-file
-
Specifies a filename which contains a list of files or directories to move.
The command will check the access right of each file specified in listfile
before actually moving the files. If caller of this command does not have
access right on any of the file specified in the listfile, command will exit
with error. This option should not be used together with the
-o {archive | flashback}.
-
-c storage-class:days
-
Specifies the storage class that the files will be moved to. If days is
supplied, it will be moved to class if file has not been accessed in days
number of days.
-
-R
-
This option specifies to remove the current DBDST policy on archive, flashback, datafile or
external file.
This command is supported in a RAC environment. This command can be run on any
node of the RAC. In case of RAC, a common archive log destination for all instances using
clustered file system is recommended. If each instance has local archivelog destinations,
this command needs to be run on a node where the corrosponding archive destination is local.
Use following command to move archivelogs older than 7 days at LOG_ARCHIVE_DEST_1
to storacle tier SECONDARY. The next example shows moving flashback logs older than 2 days
to SECONDARY tier.
This command must be run as DB2 instance owner.
This command can be executed when the database is online.
db2ed_update
must be run at least once before this command to ensure an up-to-date repository.
Please set LIBPATH to include /opt/VRTSdbms3/lib32
-
0
-
Command executed successfully.
-
1
-
An Error Occured.
-
101
-
Licence check failed.
-
102
-
No license to execute this command.
-
103
-
Invalid Storage Class
-
104
-
The device or mount point is not owned by user
dbdst_classify(1M),
dbdst_admin(1M),
dbdst_convert(1M),
dbdst_tbs_move(1M),
dbdst_fstat(1M),
dbdst_makelbfs(1M),
dbdst_partition_move(1M),
dbdst_preset_policy(1M),
dbdst_report(1M),
dbdst_rmvol(1M),
dbdst_show_fs(1M),
dbdst_addvol(1M),
oracle_edition(7)
Veritas Storage Foundation for Oracle Administrator's Guide
Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.