Re: Loading ASCII data

Posted in 1994

DBA Resources — 16 Nov 1994 10:27:06 -0700 — source: Informix-list mailing list archive (1991-1998)

Jan Musil (musil@Leo1.Zlin.VUTbr.cz) wrote: : On Tue, 15 Nov 1994, Dan Madvig - Bethel College & Sem. wrote: : 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 Be careful here if you're using a database with logging enabled -- you will have to begin a transaction to lock a table. Depending on how *much* data you are loading you could fill your logical logs and cause a highwater mark rollback. Locking a table in exclusive mode only puts a couple of locks out that I've seen--less than 5 I think. HOWEVER, I've seen it put a lock on the row in systables containing the information on the locked table. This has prevented users from running apps as the app can't read the systables table. -- Carlton Doe DBA Resources, Inc. "It's not over until I win!" Salt Lake City, UT -- Les Brown dbaresrc@xmission.com