Home > Veritas Storage Foundation™ for DB2 Manual Pages

DBDST_FILE_MOVE (1)

User Commands

Table of contents


NAME

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.

SYNOPSIS

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


AVAILABILITY

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


DESCRIPTION

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.

OPTIONS

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.

Real Application Clusters (RAC) Considerations

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.

EXAMPLES

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.



NOTES

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.


ENVIRONMENT

Please set LIBPATH to include /opt/VRTSdbms3/lib32


EXIT STATUS

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

SEE ALSO

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.