Loading ASCII data

Anybody know how many locks are used per row when one is loading data into a table? I'm trying to load 110,000 rows from a pipe-delimited ASCII file into a table. 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. But the process only loaded ~42,000 rows! Am I to conclude that each row loaded takes six locks? For what? I've heard of "locking twins", but ... -- Dan Madvig e-mail: d-madvig@bethel.edu Bethel College & Seminary phone: (612) 638-6414 3900 Bethel Drive fax: (612) 638-6001 St. Paul, MN 55112 " , ." - Marcel Marceau -- Dan Madvig e-mail: d-madvig@bethel.edu Bethel College & Seminary phone: (612) 638-6414 3900 Bethel Drive fax: (612) 638-6001 St. Paul, MN 55112 " , ." - Marcel Marceau