Re: Loading ASCII data
Dan Madvig - Bethel College & Sem. (daniel@genesis.admin.bethel.edu) wrote:
: 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.
Depends on whether you are using row locking or page locking. How many
rows per page? = page size (usually 2048) / size of a row {rough measure}
Try using dbload insteat of load. Dbload uses periodic commits to get
around locking/long transaction limits.
: 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.
No way it will be taking 6 locks. You're probably getting both a long
transaction and lock exhaustion at the same time.
: 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
--
---------------------------------------------------------------------------
Joe Lumbley Dallas, Texas Hi, y'all
Watch for my INFORMIX DBA Survival Guide from Prentice-Hall/Informix Press
ISBN 0-13-124314-4 (12431-3) Due in bookstores October 28, 1994
orders: orders@prenhall.com (515) 284-6761 fax (515) 284-2607
----------------------------------------------------------------------------