Re: 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. Locks used are calculated as : number of rows * number of indicies. > > 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. Yeah, 256k is the max. Use dbload to load the rows, then you can specify the number of rows loaded between commits; or turn off logging, and exclusively lock the table while loading, so only one lock is used. -- Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona ----------------------------------------------------------------- Dyslexsics, Untie! | Visualize Whirled Peas