Thank you all. I had some off line reaction from Epicor as well. I will test
and try out their procedures. So, I will be prepared when the database grows
near 2 Gb.
Ronald van der Linden
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, March 07, 2002 2:29 PM
To: Vantage
Subject: Re: [vantage] Progress database question - volumes
I did a test on our database on the side, just to see what we would face
when we reached the 2GB size. Our database is about the same size as yours,
but is not growing quite so fast. I did some reading and found that there
are a couple commands you use. You start by editing the Vantage.st file and
adding how many extents you want and what size each should be, along with
the path of each extent. Moving extents across different SCSI hard drives
is supposed to speed up performance on your database. After editing the .st
file, there is a command (I can't remember) that will actually create the
extents that you designated in the .st file. They will be empty, but will
show the size on the hard drive that you specified. Lastly, you will copy
your current database into the new extents (where ever you may have
specified them). This copy portion takes the longest time, although
creating the extents takes some time as well.
Once you have done it once, it is not that difficult. From then on,
maintaining the database (such as backup and restores) is fairly straight
forward, just as if the database were one volume.
Troy
and try out their procedures. So, I will be prepared when the database grows
near 2 Gb.
Ronald van der Linden
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, March 07, 2002 2:29 PM
To: Vantage
Subject: Re: [vantage] Progress database question - volumes
I did a test on our database on the side, just to see what we would face
when we reached the 2GB size. Our database is about the same size as yours,
but is not growing quite so fast. I did some reading and found that there
are a couple commands you use. You start by editing the Vantage.st file and
adding how many extents you want and what size each should be, along with
the path of each extent. Moving extents across different SCSI hard drives
is supposed to speed up performance on your database. After editing the .st
file, there is a command (I can't remember) that will actually create the
extents that you designated in the .st file. They will be empty, but will
show the size on the hard drive that you specified. Lastly, you will copy
your current database into the new extents (where ever you may have
specified them). This copy portion takes the longest time, although
creating the extents takes some time as well.
Once you have done it once, it is not that difficult. From then on,
maintaining the database (such as backup and restores) is fairly straight
forward, just as if the database were one volume.
Troy
----- Original Message -----
From: Ronald van der Linden
To: vantage@yahoogroups.com
Sent: Wednesday, March 06, 2002 1:37 PM
Subject: [vantage] Progress database question - volumes
We have a database of 947 Mb growing 80 Mb per month. As I remember well a
storage area can have a maximum size of 2Gb so about 10 months from now I
have to add at least one storage area.
Has anyone added volumes (storage areas) to their database?
thanks,
Ronald van der Linden
Macroscoop BV
Yahoo! Groups Sponsor
ADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/