RE: Why does Informix lock tables

READ_ARCHIVE_AND_BACKUP_GUIDE=ON ATTEND_TRAINING=ON How does your site perform Logical log backup? iecc, isa, ?? Do you have any notes from what the previous person did? If you dont want to backup these logs, set LTAPEDEV to NUL on your onconfig file, these restart your instance. -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Daniel S. Bravo Sent: Wednesday, December 20, 2000 1:42 PM To: informix-list@iiug.org Subject: Re: Why does Informix lock tables 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 > > > >

Well I went into the configuration file and set LTAPEDEV to NUL, I restarted the instance and then attemped to load data into the table, once again, everything just locks up. I have to control-break to get back to where I started. I still get error messages in the log file that the logical log files are full and need to be backed up. Dan Murray Wood wrote: > READ_ARCHIVE_AND_BACKUP_GUIDE=ON > ATTEND_TRAINING=ON > > How does your site perform Logical log backup? iecc, isa, ?? Do you have > any notes from what the previous person did? > If you dont want to backup these logs, set LTAPEDEV to NUL on your onconfig > file, these restart your instance. > > -----Original Message----- > From: owner-informix-list@iiug.iiug.org > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Daniel S. Bravo > Sent: Wednesday, December 20, 2000 1:42 PM > To: informix-list@iiug.org > Subject: Re: Why does Informix lock tables > > 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 > > > > > >

Because the logical logs are even too full to record the fact that they were dumped to NUL! Your only relief now is to call tech support who will truncate the last logical log and restart the engine then the rest will clear out. After that do the following: o Add more logical logs o Set LBU_PRESERVE to 1 (then if this happens again you can shutdown, reset it to 0 and restart now having a full logical logfile to use to records the archive backup or clearout. o Increase the LT parameters so large transactions rollback sooner and do not fill the logs. Art S. Kagel "Daniel S. Bravo" wrote: > > Well I went into the configuration file and set LTAPEDEV to NUL, I restarted the > instance and then attemped to load data into the table, once again, everything > just locks up. I have to control-break to get back to where I started. > > I still get error messages in the log file that the logical log files are full > and need to be backed up. > > Dan > > Murray Wood wrote: > > > READ_ARCHIVE_AND_BACKUP_GUIDE=ON > > ATTEND_TRAINING=ON > > > > How does your site perform Logical log backup? iecc, isa, ?? Do you have > > any notes from what the previous person did? > > If you dont want to backup these logs, set LTAPEDEV to NUL on your onconfig > > file, these restart your instance. > > > > -----Original Message----- > > From: owner-informix-list@iiug.iiug.org > > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Daniel S. Bravo > > Sent: Wednesday, December 20, 2000 1:42 PM > > To: informix-list@iiug.org > > Subject: Re: Why does Informix lock tables > > > > 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 > > > > > > > >