HP3000-L Archives

January 2007, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: strange error on HP3000
From:
Brian Donaldson <[log in to unmask]>
Reply To:
[log in to unmask]
Date:
Mon, 22 Jan 2007 13:23:06 EST
Content-Type:
text/plain
Parts/Attachments:
text/plain (26 lines) 
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 *

ATOM RSS1 RSS2