Posting from the Informix-list
--=====_9820735436334=_ Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Hello All: I have a situation that I don't think I understand. I have a fairly small= application written in C-ISAM. The application vendor said that they used= C-ISAM because it was fast.(I'm not sure why it matters our largest table= is less than .5 million rows) Anyway, I needed to create an index on a= table and this table was always locked by another user . So at about= midnight last night I had to edit the inittab to shut down the voice= response system and the Weblink application and kill all user sessions= just to create an index ! We are running the standard engine (SE 7.1)= under AIX. I've never had to go through such pain to create an index. Is it possible= or even likely that the application has a hold on all of the tables= (locked). I need to be able to use the DDL without killing user sessions= and applications. What do you think is causing this ? Thanks for your help --=====_9820735436334=_ Content-Type: text/html; charset="us-ascii" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/html; charset=iso-8859-1" http-equiv=Content-Type> <META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD> <BODY bgColor=#ffffff style="FONT-FAMILY: Arial" text=#000000> <DIV><FONT size=2>Hello All:</FONT></DIV> <DIV> </DIV> <DIV><FONT size=2> I have a situation that I don't think I understand. I have a fairly small application written in C-ISAM. The application vendor said that they used C-ISAM because it was fast.(I'm not sure why it matters our largest table is less than .5 million rows) Anyway, I needed to create an index on a table and this table was always locked by another user . So at about midnight last night I had to edit the inittab to shut down the voice response system and the Weblink application and kill all user sessions just to create an index ! We are running the standard engine (SE 7.1) under AIX.</FONT></DIV> <DIV> </DIV> <DIV><FONT size=2>I've never had to go through such pain to create an index. Is it possible or even likely that the application has a hold on all of the tables (locked). I need to be able to use the DDL without killing user sessions and applications. What do you think is causing this ?</FONT></DIV> <DIV> </DIV> <DIV> </DIV> <DIV><FONT size=2> Thanks for your help </FONT> </DIV> <DIV> </DIV> <DIV> </DIV></BODY></HTML> --=====_9820735436334=_--
Wayne Hansford wrote: > I have a situation that I don't think I understand. I have a fairly small > application written in C-ISAM. The application vendor said that they used > C-ISAM because it was fast.(I'm not sure why it matters our largest table > is less than .5 million rows) Anyway, I needed to create an index on a > table and this table was always locked by another user. There's a chklock program lurking about; if you can't find it on the IIUG web site, let me know and I'll get it put there. It can track down locks on C-ISAM files... > So at about > midnight last night I had to edit the inittab to shut down the voice > response system and the Weblink application and kill all user sessions > just to create an index! We are running the standard engine (SE 7.1) > under AIX. > > I've never had to go through such pain to create an index. It's seldom necessary to go through that much of a rigmarole. > Is it possible or even likely that the application has a hold on all > of the tables (locked). To create an index, you need an exclusive lock on the C-ISAM file. That means no-one else is allowed to have the file open at all. I'd guess there was a daemon of some sort monitoring the files. Or maybe the web application kept the files open even when no-one was using it. > I need to be able to use the DDL without killing user sessions > and applications. What do you think is causing this ? You'll need to have exclusive access to the table to be able to DDL operations on it. That may or may not involve killing user sessions and applications; at the least it involves making sure that none of them have the targeted file open for reading or writing. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"