Home > Veritas Storage Foundation™ for DB2 Manual Pages
DBDST_ADDVOL (1) |
|
User Commands |
Table of contents
dbdst_fstat - starts or stops I/O statistic collection on one or more
files in the database.
dbdst_fstat
-D
DB2DATABASE
[-I DB2INSTANCE]
-o start|stop <file-name>
dbdst_fstat
-D
DB2DATABASE
[-I DB2INSTANCE]
-o start|stop -f <spec-file>
dbdst_fstat
-D
DB2DATABASE
[-I DB2INSTANCE]
-o start|stop -t <tablespace-name>
dbdst_fstat
-D
DB2DATABASE
[-I DB2INSTANCE]
-o\fp stopall|list
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
dbdst_fstat must be run as
DB2 DBA user.
This command is used to start or stop I/O statistic
collection on one or more files in the database. Statistics are collected
once every 30 minutes, and it only collects statistics for data files
in a database. The command also supports SMS tablespace but only collects
I/O statistic for data files with extension of *.DAT, *.INX, and *.LB.
Any of the specified data file name which are not found in the repository,
the command will returns error.
The following options are supported:
-
-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.
-
-o start
-
Add specified file(s) into repository file statistic table, and
schedules statistic collection task to start collecting I/O statistic
on data files for every 30 minutes.
-
-o stop
-
Remove specified files(s) from repository file statistic table, TSDB_File.
If there is no more entry in the file statistic table, the command will stop
scheduling statistic collection task.
-
-o stopall
-
stop statistic collection and remove all statistic file entries from repository.
table, TSDB_File.
-
-o list
-
Display data files which has statistic collection set.
-
filename | -t tablespace-name | -f filename
-
user can specify either one file name, or use -f option to supply a file name
which contains a list of files, or use -t option to supply a tablespace name,
to start or stop statistic collection. For the specified tablespace name,
statistic will be collected for data files belong to the specified table space name.
This command is supported in a RAC environment. This command can be run on any
node of the RAC. The stats are collected on the same node where the command is run.
dbdst_fstat
must be run as DB2 DBA user.
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_file_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)
db2_edition(7)
Veritas Storage Foundation for DB2 Administrator's Guide
Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.