Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Chris Salch — — source: Usenet: comp.databases.informix
On Fri, 2010-03-26 at 16:30 -0500, Kennedy, Randy wrote:
> IDS 9.4FC3
> HP/UX 11.11
>
> I am trying to create an index and get this error sometimes. I
> understand getting it during the day when the system is heavily
> utilized, but I am trying to create this off hours when there should be
> no activity. How can I see what process/session/etc is using a table
> and giving this error?
>
> Is there a way of creating an index that doesn't lock the table so I
> could create them during the day. The time to build it doesn't matter
> to me if I don't have to tie up the table.
>
> TIA,
> Randy
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
If you can't update as Art suggested, take a look at this:
http://informix-technology.blogspot.com/2006/10/when-exclusive-is-not-really-exclusive.html
The process is convoluted but it works rather well.
--
--------------------------------------------
Chris Salch
Programmer/Analyst
LeTourneau University
903-233-3537
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.