Re: Loading ASCII data
On Tue, 15 Nov 1994, Dan Madvig - Bethel College & Sem. wrote:
> load from "/tmp/ASCIIfile"
> insert into so_and_so_rec> # ^
> # 271: Could not insert new row into the table.
> # 847: Error in load file line 42836. <<<------ This number varies
> slightly each time
> I try the load.
>
> Though you might not think so from the error messages, I'm quite sure
> I'm running out of locks. When I start the process, tbstat -k shows
> about 3000 locks. Near the time the load fails the tbstat shows over
> 240,000 locks (260,000 max). After it fails the number of locks drops
> immediately back to ~3000.
Dan,
If you are really runnig out of locks, lock table in exclusive mode
before loading. It`s only one lock (I think).
lock table so_and_so_rec in exclusive mode
load from "/tmp/ASCII_file"
insert into so_and_so_rec
unlock table so_and_so_rec
KrucifiX UniX
Honza
Jan Musil
e-mail: musil@leo1.zlin.vutbr.cz