At 02:08 PM 2/2/2006, Dave Powell, MMfab wrote:
Dear All,

Just as an addition to the great information in this thread this technique
also speeds up large deletes as well, however, as Christian states I would
do this only if you have some sort of safety net.(either test db or have a 
backup)

BTW you typically need to open the db exclusively. (mode 3)

Neil


>We have used  dbcontrol mode 1 (which I think is equivalent) for about 20
>years, with no problems, but we use it only in one specific program.
>
>Our data base maintenance uses home-grown disk-to-disk versions of dbload /
>dbunload (similar to the old contrib-library db2disk & disk2db, but in Cobol
>instead of Fortran).  The reload part is WAAAY faster this way.
>
>
>----- Original Message -----
>From: "Kent Wallace" <[log in to unmask]>
>To: <[log in to unmask]>
>Sent: Thursday, February 02, 2006 10:36
>Subject: [HP3000-L] Enable AUTODEFER
>
>
>Listers:
>
>
>
>Before I enabled autodefer I loaded 6,367,539 in 154 minutes.
>
>
>
>After autodefer was enabled I loaded 6,220,800 in 52 minutes.
>
>
>
>The machine had many other processes running,
>
>
>
>Kent Wallace
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.1.375 / Virus Database: 267.15.0/248 - Release Date: 2/1/2006

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *