Why does Informix lock tables

I am trying to run this script that contains statements like the following: load from "customer.unl" insert into customer; I use dbaccess to run these scripts and what happens is that it doesn't get past loading the first table. It just freezes there and I have to control-break to get out of the thing. What the hell is going on? I need to load these tables in this database and Informix just won't do it. Help, please!! Chaos

Perhaps you've used up the available number of locks in your system (because you don't seem to have locked the table). Or maybe you've filled up your transaction logs. Maybe someone else in using the customer table. Who knows? We don't. But if you send the output from onstat -k, onstat -m, onstat -l, plus an indictaion of the version of Informix that you're using,we can figure it out. Daniel S. Bravo <dbravo@prolifics.com> wrote in message news:3A3FD121.EDB92980@prolifics.com... > I am trying to run this script that contains statements like the > following: > > load from "customer.unl" > insert into customer;> > I use dbaccess to run these scripts and what happens is that it doesn't > get past loading the first table. > It just freezes there and I have to control-break to get out of the > thing. What the hell is going on? > I need to load these tables in this database and Informix just won't do > it. Help, please!! > > Chaos > >

Well we are using Informix 7.31 for Windows NT. I have noticed an error some log somewhere saying the following: <<Informix Dynamic Server>>> Logical Log Files are Full -- Backup is Needed I don't know where or what logical log file it is talking about. I'm new to Informix I ran onstat and it indicated that I certainly had full logical files and that I needed to back them up. I just don't know where they are so that I can clean them up. Dan Neil Truby wrote: > Perhaps you've used up the available number of locks in your system (because > you don't seem to have locked the table). Or maybe you've filled up your > transaction logs. Maybe someone else in using the customer table. > > Who knows? We don't. But if you send the output from onstat -k, onstat -m, > onstat -l, plus an indictaion of the version of Informix that you're using,> we can figure it out. > > Daniel S. Bravo <dbravo@prolifics.com> wrote in message > news:3A3FD121.EDB92980@prolifics.com... > > I am trying to run this script that contains statements like the > > following: > > > > load from "customer.unl" > > insert into customer;> > > > I use dbaccess to run these scripts and what happens is that it doesn't > > get past loading the first table. > > It just freezes there and I have to control-break to get out of the > > thing. What the hell is going on? > > I need to load these tables in this database and Informix just won't do > > it. Help, please!! > > > > Chaos > > > >