Home > Veritas Storage Foundation™ for DB2 Manual Pages

DBDST_ADDVOL (1)

User Commands

NAME
SYNOPSIS
AVAILABILITY
DESCRIPTION
OPTIONS
NOTES
Real Application Clusters (RAC) Considerations
EXAMPLES
ENVIRONMENT
EXIT STATUS
SEE ALSO

NAME

dbdst_report - displays either the policy information or the audit information which are reported on the specified dates.

SYNOPSIS

dbdst_report -D DB2DATABASE [-I DB2INSTANCE] -o policy

dbdst_report -D DB2DATABASE [-I DB2INSTANCE] -o audit [startdate=<time_in_secs|YYYY-MM-DD>, enddate=<time_in_secs|\YYYY-MM-DD>]

dbdst_report -D DB2DATABASE [-I DB2INSTANCE] -o audit [startdate=<YYYY-MM-DD>] | [enddate= <\YYYY-MM-DD>]

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_report command is used to display policy information, which consists of plan name, plan type, rule name, directory, and rule description or to display TSDB reported audit information based on the specified dates. If no date is specified, all audit information will be displayed.

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 owner.
-o policy: Specifies to display policy information.
-o audit: Specifies to display all of the reported audit information in the repository.
-o audit [startdate=<time_in_secs | YYYY-MM-DD>,: enddate=<time_in_secs | \YYYY-MM-DD>]

Specifies to display audit information reported based specified start date and end date. Dates can be specified in UNIX time stamp (the number of seconds between a particular date and the Unix Epoch), or in date format of YYYY-MM-DD.
-o audit [startdate=<YYYY-MM-DD>] | [enddate= <\YYYY-MM-DD>]: Specifies to display audit information which are reported from the start date, or to display reported audit information up to the end date but not included the end date.

NOTES

dbdst_report 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_report -D suzi -o policy 

TSDB Database Policy Report
-----------------------------------------------------
Plan Name = archivelog:archive1
Plan Type = ARCHIVE LOG
Rule Name = DBED_relocate_age_ino63_
Directory=/susanvset/archive1
Rule Description = THREE >= 15 days


$  /opt/VRTS/bin/dbdst_show_fs -D suzi -o audit 

AUDIT DATETIME            AUDIT DESCRIPTION
-------------------       -------------------------------------------
02/10/2006-23:28:15       ADMIN;Added;class name=ONE
02/10/2006-23:28:16       ADMIN;Added;class name=TWO
02/10/2006-23:28:17       ADMIN;Added;class name=THREE
02/10/2006-23:28:18       ADMIN;Modified Successfully;max/min class=4/2, 
statinterval=30, sweeptime=22:0, purgetime=20:0, swp/prg freq=1:30
02/10/2006-23:28:35       Convert;SUCCESS;Converting device 
/dev/vx/dsk/eeedg/myvset mounted at /susanvset/myvset
02/10/2006-23:28:38       Addvol;SUCCESS;volume susan1 belongs to storage_class ONE
02/10/2006-23:28:41       Addvol;SUCCESS;volume susan3 belongs to storage_class TWO

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

DBDST_ADDVOL (1)

Table of contents