Thank you for your response.
Just a few other questions.
Should the fix file size be for 2gb and than the extra to the variable or would it be better to have 3 or 4 1gb extends and 1 variable?
Also to you have an idea of how long this should take? Over the weekend or can I get it done in one night in case I have a problem.
Mark T
Just a few other questions.
Should the fix file size be for 2gb and than the extra to the variable or would it be better to have 3 or 4 1gb extends and 1 variable?
Also to you have an idea of how long this should take? Over the weekend or can I get it done in one night in case I have a problem.
Mark T
--- In vantage@yahoogroups.com, Ned <TechnoBabbly@...> wrote:
>
> Those commands are run from the PROENV tool.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> mjtonsing
> Sent: Wednesday, September 12, 2012 1:28 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Database size Limit
>
> Thank you for your response.
>
> Are all of these comands run from the windows comand line or somewhere else?
>
> Mark
>
> --- In vantage@yahoogroups.com, Ned <TechnoBabbly@> wrote:
> >
> > Progress's knowledge base covers this.
> >
> > http://knowledgebase.progress.com/articles/Article/P7697
> >
> > Before changing the database structure, backup your database. The
> > following procedure is extremely low-risk, but it's always a good
> > practice to back the database up before any change.
> > Make a copy of the dbname.st file. Run prostrct list dbname to get
> > the correct st file before starting the process.
> >
> > Steps
> >
> > 1) Create a new structure description (.st) file that contains only
> > information about the extents(s) being added. Be sure to avoid
> > overwriting the .st file for your existing database, by giving the .st
> > file a unique name that is different from the existing "database-name.st"
> file.
> >
> > Multiple extents can be added to multiple storage areas at the same
> > time and extents need not be in the same directory as the .db file.
> > Note that for all extent types, except after-image extents, there can
> > be only ONE variable length extent defined and it must be the last
> > extent of the Storage Area. If the current last extent ends with a
> > variable extent, it will become a fixed extent when you add another
> extent.
> >
> > Examples of a structure file that defines 1, 1GB fixed data extent and
> > 1 variable length extent to be added to a current area on disk.
> >
> > Note:You can add additional areas to a database by the same process
> > using a new storage area name instead of the current storage area
> > name. Those new storage areas would be empty and tables and/or
> > indexes could be moved into those areas when required. New tables
> > could also be created in those areas when desired.
> >
> > Progress 9.x
> > # V9: add.st
> > #
> > d "[your current storage area name]":[area number],64 /fsys2/data/ f
> > 1048576 d "[your current storage area name]":[area number],64
> > /fsys3/data/ Progress 7.x 8.x multi-volume database
> >
> > 2) Structure changes to the database need to be made offline, so shut
> > down the database and stop all batch jobs running against the database if
> needed.
> >
> > 3) Use the prostrct utility with the add qualifier, specifying the .st
> > file you created in step 1.
> >
> > $ prostrct add dbname add.st
> >
> > 4) After the extent(s) have been added, use the prostrct utility with
> > the list qualifier to display and verify the new database structure.
> > This will include storage area information: name, number, records per
> > block, blocks per cluster (V10 only) and extent information: type,
> > path, size, number and name to screen. This information is also
> > written to a text file which is named database-name.st by default
> > unless you specify another name, for
> > example: dbname2.st
> >
> > $ prostrct list dbname dbname2.st
> >
> > Note:You should copy the original .st file, for documentation of the
> > structure at the time, just prior to running: prostrct list dbname,
> > which will overwrite the current dbname.st file.
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of mjtonsing
> > Sent: Tuesday, September 11, 2012 3:52 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Database size Limit
> >
> > Thank you for your response, I left out that we are on Progress 9.1A
> > version
> > 5.00.35
> >
> > Mark
> >
> > --- In vantage@yahoogroups.com, Ned <TechnoBabbly@> wrote:
> > >
> > > Shut down the database.
> > >
> > > Open the Proenv command
> > >
> > > Run this on the folder with the database in it.
> > >
> > > Proutil mfgsys -C enablelargefiles
> > >
> > > This will allow your DB to grow in size beyond the initial size
> > limitation.
> > >
> > > Restart your database.
> > >
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of mjtonsing
> > > Sent: Tuesday, September 11, 2012 3:19 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Database size Limit
> > >
> > > Is there anyone out there who could help me. Recent upgrade of
> > > Server to
> > > 2003 standard. CPU Usage less than 5 percent, Network usage usually
> > > less than 2 percent jumping to 12.5 percent very rare. Database size
> > > is getting too big. Need help adding multiple extends and different
> > > placement of files on certain disk drives. Vantage d1 over 2.078gig
> > > in size. Have looked thru past posts and this is beyond my capabilities.
> > > Will need someone to walk me thru all of the steps, or send me
> > > detailed directions. Thank you in advance for your help.
> > >
> > > Mark T.
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > 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/linksYahoo! Groups Links
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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/linksYahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>