Sounds like the last sentence means before one does a mass-load, do a
backup, THEN turn AUTODEFER on.

But the caveat seems to be that if you want a robust transaction system,
you also need to turn AUTODEFER off after you're complete with the mass
load also.

Tracy Johnson
Measurement Specialties, Inc. 

BT







NNNN


> -----Original Message-----
> From: HP-3000 Systems Discussion 
> [mailto:[log in to unmask]] On Behalf Of Brian Donaldson
> Sent: Monday, January 22, 2007 1:23 PM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] strange error on HP3000
> 
> 
> This stalled transaction error is happening because your 
> Cobol program is  
> using 
> the DBX procedures. Not good for mass loads as I recently 
> indicated in a  
> previous posting to 
> another poster experiencing the same problem/error.
>  
> Do not use the DBXBEGIN/DBXEND combo for mass loads. The 
> Transaction  Manager 
> XM file
> will most likely get full up long before the program has 
> loaded everything  
> into the TurboIMAGE
> database.
>  
> Instead, use AUTODEFER. This can be enabled via DBUTIL. The 
> program must  
> DBOPEN the
> base in Mode3 (exclusive mode).
>  
> Make sure you have a full backup of your database before 
> using AUTODEFER  
> because -- if the system
> fails, or the program aborts, does not complete normally 
> etc., your  database 
> will be trashed.
>  
> Brian Donaldson.
> 
> * 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 *