Hi Tim,
Can I have the doument please?
Thanks,
Can I have the doument please?
Thanks,
--- In vantage@yahoogroups.com, Tim Care <ecfmis@e...> wrote:
> You can also talk to Vantage support about this. There is
> a Progress procedure that can be used to copy your existing
> database into one with multiple extents. They helped us
> through this same thing.
>
> Tim Care
> Electro Chemical Finishing
>
> -----Original Message-----
> From: william [mailto:william@p...]
> Sent: Friday, September 21, 2001 12:18 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Maximum database file size is 2 GB
>
>
> While I have not dealt with the issue in this context, what you
need to
> do, pronto, is reconfigure your db into more extents. Since you are
on
> vantage 5, I am assuming Progress 9.1x.
>
> A little background. As you have discovered, Version 9 is muti-
volume,
> and version 9.1 adds the concept of Areas. Tables and indexes may be
> assigned to areas (indexes can be in a different area than the table
> they describe), and each area is made up of one or more extents.
Extents
> may be either fixed length, (when you create the database, a file
of the
> specified size is created immediately) or variable length (a small
file
> is created initially, and it grows as you add data to it). As
noted, no
> single extent can exceed 2Gb. The data area to which a table or
index is
> assigned is not part of the CRC of the table or index, so you can
> reconfigure you Data Base with invalidating the .r files. By default
> version 9 databases are created with only a schema area. You can put
> tables in this area, but PSC strongly recommends not to do so.
Also, you
> may have only one variable extent per data area, and it must be the
last
> one in the data area.
>
> So to address your problem. Get hold of the Database Admin Guide and
> Reference. Available in PDF format at www.progress.com, if you can't
> find the CD. Chapter 7 contains a detailed description of the steps
> needed to restructure a data base. The basic steps are:
>
> - MAKE A BACKUP.
> - MAKE ANOTHER BACKUP.
> - create a file containing the details of areas/extents that you
want to
> add.
> - using the prostrct add utility apply the new structure to the data
> base .
> - if you have created new data areas, use the proutil tablemove
and/or
> indexmove utilities to move tables and indexes to their new homes.
> - test the new structure.
> - if all is well, move it into production.
> - Note that if you apply new extents to your existing db, the
current
> variable length extent will become a fixed length extent, at its
current
> size.
>
> The above is a very brief summary of what need to be done. There
are, of
> course, many other options available. The ones you choose will
largely
> depend on you bravery (foolhardiness?), previous experience, and
> available resources. More help is available www.peg.com. Subscribe
to
> the DBA list where the heavy hitters in this subject hang out.
>
> HTH.
>
> Chris Lantz wrote:
> >
> > In the Pre-Installation Checklist for Vantage 5.10, at the bottom
of
> > page 11 it states
> >
> > "The maximum size for any Progress database file (Vantage.b1,
> > Vantage.d1, or Vantage.lg) is 2 GB. If any database file
approaches
> > this limit, please contact Vantage technical support for
assistance."
> >
> > Our Vantage.d1 file is currently 1.6 GB. Has anyone else dealt
with
> > this issue?
> >
> > 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/
>
> --
> /*
================================================================*/
>
> Specialists in Progress Databases and Software since 1986
>
> William E. Colls william@p...
> PROComputer Systems Tel 613 591 0079
> 67 Willow Glen Dr. Fax 613 591 3924
> Kanata Ontario Canada www.procomsys.com
> K2M 1T1
>
>
> 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/