Home > Veritas Storage Foundation™ for DB2 Manual Pages

DBDST_CLASSIFY (1)

User Commands

Table of contents


NAME

dbdst_classify - classify volumes in a DBDST ready filesystem into storage classes.

SYNOPSIS

dbdst_classify -D DB2DATABASE \[ -I DB2INSTANCE -M mount_device

     -vvol:class,vol:class,


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_classify command is used to classify an existing DBDST ready MVS filesystem. DBA need to specify which storage_class each volume belongs to. Storage classes used in in this command must be predefined using dbdst_admin. It is important to note that maxclass and minclass are not enforced and are advisory only. This command can be executed when database is online. The MVS filesystem indicated by the mount_device should be available and mounted.

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.
-M mount_device
Specifies the block device where the file system resides. This should be of the form '/dev/vx/dsk/<dgname>/<vsetname>'
-v vol:class,vol:class
Specifies a comma separated list of vol:class pairs which indicate the volume name and the storage class it belongs to. The storage_class specified by the class must be registered earlier using dbdst_admin comand.

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

This example shows how to classify volumes vol1 as storage class GOLD and vol2, vol3 as storage class SILVER for a filesystem on device /dev/vx/dsk/oradata/arch.


$ /opt/VRTS/bin/dbdst_classify -D PROD -M  /dev/vx/dsk/db2dg/arch   -v vol1:GOLD,vol2:SILVER,vol3:SILVER

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.

dbdst_admin must be run at least once before this command to ensure storage class is registered.

The mount_device must be converted to DBDST filesystem using dbdst_convert command before this command.


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_tbs_move(1M), db2_edition(7)

Veritas Storage Foundation for DB2 Administrator's Guide

Last updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.