Hi Charlotte,
Thanks for all this useful information I am just wondering what
happen if there is data in the original dbvol when you Reduce the DB
and delete the  original DBvol?

Best regards,

Luis Fernandez


>>> Charlotte Brooks <cbrooks AT AU1.IBM DOT COM> 12/07/98 08:29am >>>
Hello - yes you can easily define new database volumes. If you're
using the
V3.1.2 web administrative interface, under Object
View/Database/Database
Volumes, select Define Database volume. Specify which directory you
want
the new volume in, and how big you want to make it. ADSM will
automatically
format the volume at that size and add it to the total db size. If
you
don't have 3.1.2 (and don't want to download the update from the
ADSM
webpage), then you will first have to run a format command from the
AIX
prompt. eg to allocate a volume of 52MB (best to define in multiples
of 4MB
plus 1MB for overhead) in the /data directory,
# /usr/lpp/adsmserv/bin/dsmfmt  -m -db /data/logvol.dsm 53   (try
dsmfmt
for help on this command)
This prepares the volume. Then you have to tell ADSM to use this
volume
(through the web interface or at the ADSM administrative command
line)
adsm> DEFINE DBVOLUME /data/logvol.dsm
As I said, if you have ADSM V3.1.2 then this is done in one step.
Then extend the database to use the new space
adsm> EXTEND DB 52
If you want to free up the space in the original volume in
/usr/lpp/adsmserv/bin, use the REDUCE DB command (by the size of the
volume
you want to delete) then DELETE DBVOL (specify the name of the
volume you
want to delete)
Hope this helps...

Regards,
Charlotte
Email: cbrooks AT au1.ibm DOT com
Ph: 61-2-9353-3437, Fax 61-2-9353-3496, Mobile: 0411-117-538
AP ADSM Technical Support Manager