Home > Veritas Storage Foundation™ for DB2 Manual Pages

DBDST_ADDVOL (1)

User Commands

Table of contents


NAME

dbdst_show_fs - displays class information, volume information and freespace for a given mount point.

SYNOPSIS


dbdst_show_fs
-D
DB2DATABASE
[-I DB2INSTANCE]
-m <mount_point>

dbdst_show_fs -D DB2DATABASE [-I DB2INSTANCE] -m <mount_point> -o <volume


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_show_fs command is used to display freespace, class information, and volumne information in each class for a given mount point. The filesystem should be mounted when this command is executed. The display information is sorted by class name and volume name. You can also specify -o volume to display only the volume information.

OPTIONS

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.
-m mount_point
Specifies mount point which you want to display its class, and volume information.
-o volume
Option to display just the volume information.

NOTES

dbdst_show_fs must be run as DB2 DBA user.


Real Application Clusters (RAC) Considerations

This command is supported in a RAC environment. This command can be run on any node of the RAC.

EXAMPLES

$  /opt/VRTS/bin/dbdst_show_fs -D suzi -m /susanvset

CLASS = ONE
        Name                Size      Used    Available
        v1                  1048576   394004  654572
        v2                  1048576   16      1048560
        =============================================================
        SUMMARY:            2097152   394020  1703132
CLASS = PRIMARY
        Name                Size      Used    Available
        susanvset-b4vset    1048576   70867   977709
CLASS = THREE
        Name                Size      Used    Available
        v5                  1048576   16      1048560
        v6                  1048576   16      1048560
        =============================================================
        SUMMARY:            2097152   32      2097120
CLASS = TWO
        Name                Size      Used    Available
        v3                  1048576   51216   997360
        v4                  1048576   16      1048560
        =============================================================
        SUMMARY:            2097152   51232   2045920
$ /opt/VRTS/bin/dbdst_show_fs -D suzi -m /susanvset -o volume Name Size Used Available Tag susanvset-b4vset 1048576 70867 977709 PRIMARY v1 1048576 394005 654571 ONE v2 1048576 16 1048560 ONE v3 1048576 51216 997360 TWO v4 1048576 16 1048560 TWO v5 1048576 16 1048560 THREE v6 1048576 16 1048560 THREE


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_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.