Home > Veritas Storage Foundation™ for DB2 Manual Pages
VXSTORAGE_STATS (1) |
User Commands |
[-i interval -c count ] -f filenameFor DB2: /opt/VRTSdb2ed/bin/vxstorage_stats [-m] [-s]
[-i interval -c count ] -f filename
AVAILABILITY
This command is part of Veritas Storage Foundation for Databases.To determine whether Veritas Storage Foundation for Oracle is installed on a Solaris system, enter:
pkginfo -l VRTSdbed
To determine whether Veritas Storage Foundation for DB2 is installed on a Solaris system, enter:
pkginfo -l VRTSdb2ed
DESCRIPTION
The vxstorage_stats command prints I/O mapping and statistics about one or more Veritas File System files. The statistics are recorded only for VxFS files and VxVM volumes. These statistics show I/O activity.
OPTIONS
The following options are supported:
- -m
- Displays the I/O stack mapping topology for the specified file.
- -s
- Displays the file statistics for the specified file.
- -c count
- Specifies the number of times to print statistics. -i interval is required to use -c count.
- -i interval
- Specifies the interval frequency for printing updated I/O statistics. If the -i interval option is supplied, statistics are prefaced with a time stamp showing the current local time on the system. If -i interval and -c count are not specified, the default is one count (that is, statistics will be printed a single time). Note: I/O topology information is printed first; subsequent refreshes display statistics only.
- -f filename
- Specifies the file to print I/O mapping and statistics for.
NOTES
In vxstorage_stats command output, I/O topology information appears first followed by summary statistics for each object. Summary statistics are printed in single line output records, preceded by two header lines. The output line consists of the following space-separated fields:
- file name
- number of read operations
- number of write operations
- number of blocks read
- number of blocks written
- average time spent on read operations in the interval
- average time spent on write operations in the interval
The vxstorage_stats command exits with a non-zero status if the attempted operation fails. A non-zero exit code is returned for the first condition that prevented execution of the utility.
EXAMPLES
Note that for Oracle, the command is located under /opt/VRTSdbed/bin. For DB2, it is located under /opt/VRTSdb2ed/bin.To print the entire I/O mapping:
# /opt/VRTSdbed/bin/vxstorage_stats -m -f /data/system01.dbf TY NAME NSUB DESCRIPTION SIZE OFFSET PROPERTIES fi /data/system01.dbf 1 FILE 262146048 1172128 Extents: 6 Sparse Extents:0 v data_vol 2 MIRROR 8388608 0 pl vxvm:mapdg/data_vol-01 1 CONCAT_VOLUME 8388608 0 rd /dev/vx/rdmp/c1t10d0s2 1 PARTITION 8388608 0 sd /dev/rdsk/c1t10d0s2 1 PARTITION 35368272 0 da c1t10d0 0 DISK 35368272 0 pl vxvm:mapdg/data_vol-03 1 CONCAT_VOLUME 8388608 0 rd /dev/vx/rdmp/c1t13d0s2 1 PARTITION 8388608 0 sd /dev/rdsk/c1t13d0s2 1 PARTITION 71127180 0 da c1t13d0 0 DISK 71127180 0To print the entire I/O mapping and statistics of each I/O stack:
# /opt/VRTSdbed/bin/vxstorage_stats -m -s -f /data/system01.dbf TY NAME NSUB DESCRIPTION SIZE OFFSET PROPERTIES fi /data/system01.dbf 1 FILE 262146048 1172128 Extents: 6 Sparce Extents:0 v data_vol 2 MIRROR 8388608 0 pl vxvm:mapdg/data_vol-01 1 CONCAT_VOLUME 8388608 0 rd /dev/vx/rdmp/c1t10d0s2 1 PARTITION 8388608 0 sd /dev/rdsk/c1t10d0s2 1 PARTITION 35368272 0 da c1t10d0 0 DISK 35368272 0 pl vxvm:mapdg/data_vol-03 1 CONCAT_VOLUME 8388608 0 rd /dev/vx/rdmp/c1t13d0s2 1 PARTITION 8388608 0 sd /dev/rdsk/c1t13d0s2 1 PARTITION 71127180 0 da c1t13d0 0 DISK 71127180 0 OPERATIONS FILE BLOCKS(512 byte) AVG TIME(ms) OBJECT READ WRITE B_READ B_WRITE AVG_RD AVG_WR /data/system01.dbf 615 19 20752 152 3.53 24.74 /dev/vx/rdsk/mapdg/data_vol 19444 33318 895903 1376825 9.26 16.14 vxvm:mapdg/data_vol-01 19444 33318 895903 1376825 9.24 14.00 /dev/rdsk/c1t10d0s2 19444 33318 895903 1376825 9.24 14.00 c1t10d0 19444 33318 895903 1376825 9.24 14.00 vxvm:mapdg/data_vol-03 0 33318 0 1376825 0.00 14.18 /dev/rdsk/c1t13d0s2 0 33318 0 1376825 0.00 14.18 c1t13d0 0 33318 0 1376825 0.00 14.18To print statistics two times with a time interval of two seconds:
\$# /opt/VRTSdbed/bin/vxstorage_stats -s -i2 -c2 -f /data/system01.dbf OPERATIONS FILE BLOCKS(512 byte) AVG TIME(ms) OBJECT READ WRITE B_READ B_WRITE AVG_RD AVG_WR /data/system01.dbf 615 19 20752 152 3.53 24.74 /dev/vx/rdsk/mapdg/data_vol 19386 33227 895692 1376438 9.27 16.18 vxvm:mapdg/data_vol-01 19386 33227 895692 1376438 9.26 14.03 /dev/rdsk/c1t10d0s2 19386 33227 895692 1376483 9.26 14.03 c1t10d0 19386 33227 895692 1376483 9.26 14.03 vxvm:mapdg/data_vol-03 0 33227 0 1376483 0.00 14.21 /dev/rdsk/c1t13d0s2 0 33227 0 1376483 0.00 14.21 /c1t13d0 0 33227 0 1376438 0.00 14.21 OPERATIONS FILE BLOCKS(512 byte) AVG TIME(ms) OBJECT READ WRITE B_READ B_WRITE AVG_RD AVG_WR /data/system01.dbf 0 0 0 0 0.00 0.00 /dev/vx/rdsk/mapdg/data_vol 0 1 0 2 0.00 0.00 vxvm:mapdg/data_vol-01 0 1 0 2 0.00 0.00 /dev/rdsk/c1t10d0s2 0 1 0 2 0.00 0.00 c1t10d0 0 1 0 2 0.00 0.00 vxvm:mapdg/data_vol-03 0 1 0 2 0.00 0.00 /dev/rdsk/c1t13d0s2 0 1 0 2 0.00 0.00 c1t13d0 0 1 0 2 0.00 0.00
SEE ALSO
Veritas Storage Foundation for Oracle Administrator's Guide Veritas Storage Foundation for Oracle RAC Installation and Configuration Guide
Veritas Storage Foundation for DB2 Administrator's GuideLast updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.