RE: Alter Table non-exclusive
If an exclusive lock is required it is impossible to do the job while the table is in use. And some tables in our environment are in use of one or more session permanently. So it doesn't matter how long the alter job lasts. It cannot be accomplished without a downtime of production. That is what we (better: my boss) wish(es) to improve. @Fernando: To find the sessions that use a table I found a tool in the IIUG software corner long ago: 1 #!/usr/bin/ksh 2 # who-access.sh - Find out who is accessing a specified table. 3 # 4 # Author: Jacob Salomon 5 # Date: 07/15/1999 6 # Credits: Original idea from a script by: 7 # Rick Bernstein ... It's really very usefull and reliable. Reinhard. From: Art Kagel [mailto:art.kagel@gmail.com] Sent: Wednesday, August 17, 2011 1:26 PM To: Habichtsberg, Reinhard Cc: informix-list@iiug.org Subject: Re: Alter Table non-exclusive Some things already only require an exclusive lock momentarily. Most alters that add or drop a column or change it's type, adding or dropping an index, and others are accomplished in-place or online and do not lock that table for long. What are you trying to do that's causing you trouble? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Aug 17, 2011 at 6:17 AM, Habichtsberg, Reinhard <RHabichtsberg@arz-emmendingen.de> wrote: Hi all We have 24 x 7 production with our Informix databases. We all heard of Informix Server that ran a year or longer without interruption <http://dict.leo.org/ende?lp=ende&p=Ci4HO3kMAA&search=interruption&trest r=0x8001> . What we wish is the ability to do "Alter tables" and other administrative tasks that needs "exclusive locks" without this need. Each change on the table structures which come continuous from our software developement causes trouble with our production: Workflows has to be stopped, dialog programs can't run. Is there any chance do these tasks without exclusive locks, perhaps in futur? Or, is there any other way to do these tasks without a production break? TIA, Reinhard. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list