Thanks so much!!!
-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Thursday, November 29, 2001 1:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crash protection off
At 01:55 PM 11/29/2001, you wrote:
stuff that runs when you upgrade. But, if something goes wrong, your DB is
hosed. You have to restore from backup and re run it. Dialing up a decent
amount of memory cache with the -B parameter will help Vantage upgrades
even more.
Here's the description from the Progress manual:
Use No Crash Protection (-i) to tell Progress to run without using database
integrity or database
recovery. When running Progress without database integrity, it writes fewer
data and
before-image blocks to the disk. In this mode, some Progress procedures
(such as those that
create and delete large numbers of records) run significantly faster than
if they are running with
database integrity.
When running Progress with the -i parameter, transaction undo is supported.
Therefore, there
will still be a before-image file, which might grow quite large during very
long transactions.
Use this parameter to do bulk data loading or for large batch runs. It
reduces the number of disk
input or output operations. Loading a database for the first time is a good
example of a use for
this parameter.
CAUTION: If you run Progress with the -i parameter and Progress fails for
any reason, you
cannot recover the database.
Progress Database Administration Guide and Reference
Do not use the -i parameter unless you have a complete backup of the
database and can rerun
procedures in case of a system failure. If the system fails during a
Progress session started
without crash protection, restore the backup copy and rerun the necessary
procedures. For
information on restoring a database, see Chapter 6, "Backing Up and
Restoring."
-WC
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/
-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Thursday, November 29, 2001 1:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crash protection off
At 01:55 PM 11/29/2001, you wrote:
>What is crash protection all about please?Turning it off speeds up mass-updates, like schema changes and the other
stuff that runs when you upgrade. But, if something goes wrong, your DB is
hosed. You have to restore from backup and re run it. Dialing up a decent
amount of memory cache with the -B parameter will help Vantage upgrades
even more.
Here's the description from the Progress manual:
Use No Crash Protection (-i) to tell Progress to run without using database
integrity or database
recovery. When running Progress without database integrity, it writes fewer
data and
before-image blocks to the disk. In this mode, some Progress procedures
(such as those that
create and delete large numbers of records) run significantly faster than
if they are running with
database integrity.
When running Progress with the -i parameter, transaction undo is supported.
Therefore, there
will still be a before-image file, which might grow quite large during very
long transactions.
Use this parameter to do bulk data loading or for large batch runs. It
reduces the number of disk
input or output operations. Loading a database for the first time is a good
example of a use for
this parameter.
CAUTION: If you run Progress with the -i parameter and Progress fails for
any reason, you
cannot recover the database.
Progress Database Administration Guide and Reference
Do not use the -i parameter unless you have a complete backup of the
database and can rerun
procedures in case of a system failure. If the system fails during a
Progress session started
without crash protection, restore the backup copy and rerun the necessary
procedures. For
information on restoring a database, see Chapter 6, "Backing Up and
Restoring."
-WC
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/