Home > Veritas Storage Foundation™ for DB2 Manual Pages

DBDST_MAKELBFS (1)

User Commands

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

NAME

dbdst_makelbfs - Create a new Loadbalancing Filesystem

SYNOPSIS

dbdst_makelbfs -D DB2DATABASE \[ -I DB2INSTANCE -m mount_point -g dg_name

-C chnuk_size -v vol,vol,

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_makelbfs command is used to create a load balancing file system (LBFS). LBFS filesystem is a MVS filesystem residing on a volume-set. In LBFS, the file extents are distributed on every volume of the MVS. The extent size is specified as chunk_size. Every file is evenly distributed on volumes and hence will provide a good IO performance for database files. It is recommended that the volumes are mirrored either within disk array or by VxVM. There is no need to stripe individual volumes. When DBA need to add more space to LBFS, simply create more volumes and add the volumes to the LBFS using dbdst_addvol command. After adding extra volume, every file will be rebalnaced among all volumes again. This kind of rebalancing is much faster than VxVM relayout.

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_point: Specifies the mount point where the newly created LBFS need to be mounted. This mount point should exist and be owned by the user.
-g dg_name: Specifies the diskgroup name where the volumes reside.
-C chunk_size: The size in MB of each file extent. If not specified, the default chunk size is 1MB.
-v vol,vol,...: Specifies the list of volumes which will be used to create a volume-set and LBFS filesystem. All the volumes specified in the list must be owned by the user executing the command.

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 create an LBFS with volumes vol1,vol2,vol3 and vol4.


$ /opt/VRTS/bin/dbdst_makelbfs -S PROD -g db2dg -M  /db2_lbfs   -C 1M  -v vol1,vol2,vol3,vol4

This example shows how to add two more new volumes to LBFS

$ /opt/VRTS/bin/dbdst_addvol -S PROD -M /dev/vx/dsk/db2dg/vol1 -v new_vol1:BALANCE,new_vol2:BALANCE

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.

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_MAKELBFS (1)

Table of contents