RE: Why does Informix lock tables

Sounds to me like your logs are already full. Try the following Set LTAPEDEV to NUL run ontape -a This should clear the logs to get you started after that you can run ontape -c which will clear a log as soon as it gets full. If you are only loading data via dbaccess you may want to investigate changing the database logging mode from logged to unlogged and then when you are finished loading data changing it back to logged. Some additional thoughts. 1. Keeping LTAPEDEV as NUL is the same as saying I don't care about any databases on this instance be prepared to lose the databases and all data in them. 2. Start reading that informix manual, especially the parts on import/export of data. Cheers David -----Original Message----- From: Daniel S. Bravo [mailto:dbravo@prolifics.com] Sent: Thursday, December 21, 2000 6:33 AM To: informix-list@iiug.org Subject: Re: Why does Informix lock tables This is a multi-part message in MIME format. --------------12EEB44A0FF9C704D0A0FEE1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 > > > > > > --------------12EEB44A0FF9C704D0A0FEE1 Content-Type: text/x-vcard; charset=us-ascii; name="dbravo.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Daniel S. Bravo Content-Disposition: attachment; filename="dbravo.vcf" begin:vcard n:Bravo;Daniel tel;cell:949-283-6734 tel;fax:949-951-8371 tel;home:949-859-8063 tel;work:949-951-9596 x-mozilla-html:TRUE url:http://www.prolifics.com org:Prolifics;Consulting version:2.1 email;internet:dbravo@prolifics.com title:Senior Consultant adr;quoted-printable:;;15707 RockField Boulevard=0D=0ASuite #217;Irvine;CA;92618;US note;quoted-printable:The world is immense=0D=0AAnd my time is brief=0D=0ASo my common sense=0D=0ATells me to leave=0D=0AAnd explore all things=0D=0Athat life has to give=0D=0AAnd forget inhibitions=0D=0AAnd truly LIVE!!=0D=0A fn:Daniel S. Bravo end:vcard --------------12EEB44A0FF9C704D0A0FEE1-- ************************************************************************This e-mail is intended for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify us immediately at helpdesk@lumley.com.au and destroy the original message. While this mail and any attachments have been scanned for common computer viruses and found to be virus free, we recommend you also perform your own virus checking processes before opening any attachments.

I would also change your load script to BEGIN WORK; LOCK TABLE customer; load from "customer.unl" insert into customer;COMMIT WORK; Quick and dirty way to PERHAPS use a smaller segment of locks... Just a thought... Rob Vorbroker David McPaul <dmcpaul@lumley.com.au> wrote in message news:91ri2a$k9d$1@news.xmission.com... > > Sounds to me like your logs are already full. > > Try the following > Set LTAPEDEV to NUL > run ontape -a > > This should clear the logs to get you started after that you can run ontape> -c which will clear a log as soon as it gets full. > > If you are only loading data via dbaccess you may want to investigate > changing the database logging mode from logged to unlogged and then when you > are finished loading data changing it back to logged. > > Some additional thoughts. > 1. Keeping LTAPEDEV as NUL is the same as saying I don't care about any > databases on this instance be prepared to lose the databases and all data in > them. > 2. Start reading that informix manual, especially the parts on > import/export of data. > > Cheers > David > > -----Original Message----- > From: Daniel S. Bravo [mailto:dbravo@prolifics.com] > Sent: Thursday, December 21, 2000 6:33 AM > To: informix-list@iiug.org > Subject: Re: Why does Informix lock tables > > > This is a multi-part message in MIME format. > --------------12EEB44A0FF9C704D0A0FEE1 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > 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 > > > > > > > > > > --------------12EEB44A0FF9C704D0A0FEE1 > Content-Type: text/x-vcard; charset=us-ascii; > name="dbravo.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Daniel S. Bravo > Content-Disposition: attachment; > filename="dbravo.vcf" > > begin:vcard > n:Bravo;Daniel > tel;cell:949-283-6734 > tel;fax:949-951-8371 > tel;home:949-859-8063 > tel;work:949-951-9596 > x-mozilla-html:TRUE > url:http://www.prolifics.com > org:Prolifics;Consulting > version:2.1 > email;internet:dbravo@prolifics.com > title:Senior Consultant > adr;quoted-printable:;;15707 RockField Boulevard=0D=0ASuite > #217;Irvine;CA;92618;US > note;quoted-printable:The world is immense=0D=0AAnd my time is brief=0D=0ASo > my common sense=0D=0ATells me to leave=0D=0AAnd explore all things=0D=0Athat > life has to give=0D=0AAnd forget inhibitions=0D=0AAnd truly LIVE!!=0D=0A > fn:Daniel S. Bravo > end:vcard > > --------------12EEB44A0FF9C704D0A0FEE1-- > ************************************************************************This e-mail is intended for the use of the individual or entity named above and may contain information that is confidential and privileged. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify us immediately at helpdesk@lumley.com.au and destroy the original message. While this mail and any attachments have been scanned for common computer viruses and found to be virus free, we recommend you also perform your own virus checking processes before opening any attachments.