Home > Veritas Storage Foundation™ for DB2 Manual Pages
-o enable | disable | display [-q] | set=hardlimit,softlimit[,enable | disable] [-f listfile | filesystem]
lslpp -L VRTSdb2ed
Quotas are specified in file system blocks. There are two quota limits: the soft limit and the hard limit. If the soft limit is exceeded, a warning message is displayed on the console. If the hard limit is exceeded, the oldest removable Storage Checkpoint is automatically deleted. If Storage Checkpoints have been created with the noremove option, the current operation will fail and the previously created Storage Checkpoints will be preserved.
To use db2ed_ckptquota, the VxDBA repository entry for the database must exist. See the db2ed_update(1M) man page for more information. The DBA must be the owner of all file systems to be affected.
- enable | disable
- Enables or disables Storage Checkpoint quotas for the specified file systems. When quotas are enabled, Storage Checkpoints are automatically removed when the hard limit is exceeded. If no file systems are specified, all file systems in the database will be affected.
- display [-q]
- Displays quota values (soft limit and hard limit) as well as current usage for all file systems specified. If no file systems are specified, quota values for all file systems in the database will be displayed. All values are represented as file system blocks. If -q is specified, the header row is suppressed.
- set=hardlimit,softlimit[,enable | disable]
- Sets the quota soft limit and hard limit for the specified file systems. If no file systems are specified, all file systems in the database will be set with the given quota limits.
- -f listfile | filesystem
- Specifies the listfile containing the list of file systems to administer. An individual file system may also be specified. If neither a list file nor a file system is specified, all file systems in the database will be affected.
$ /opt/VRTS/bin/db2ed_ckptquota -D PROD -o set=50000,40000,enable
This example sets the hard limit and soft limit for all file systems specified in the list file quotacfg:
$ /opt/VRTS/bin/db2ed_ckptquota -D PROD -o set=25000,20000 -f quotacfg
This example disables quota limits for a single file system:
$ /opt/VRTS/bin/db2ed_ckptquota -D PROD -o disable /db2/testvol03
This example displays quota values for all file systems in the database:
$ /opt/VRTS/bin/db2ed_ckptquota -D PROD -o display Filesystem Hardlimit Softlimit CurrentUse /db2/prod 50000 40000 136 /db2/testvol01 25000 20000 128 /db2/testvol02 50000 40000 128 /db2/testvol03 50000 40000 0 /db2/testvol04 25000 20000 128 /db2/testvol05 50000 40000 128
CurrentUse displays the number of file system blocks currently used by all Storage Checkpoints in the file system. If there are no Storage Checkpoints or if quotas have been disabled, CurrentUse will display 0.
Veritas Storage Foundation for DB2 Administrator's Guide
Last updated: 3 Nov 2004
Copyright ©2009 Symantec Corporation
All rights reserved.