Table locking during indexing

#1

Would normally simply test this but I don't have my test system at
present due to hardware failure, and I'm not going to have it for a
few weeks.

When Informix IDS 11.7 is indexing a table, does it take out an
exclusive lock? I have a big table to amend indexes on and I've been
saying the user can't access it while I'm doing that but I'm not sure
I'm right.

#2

When you issue the CREATE INDEX statement, the table is locked in
exclusive mode, however, see The ONLINE keyword of CREATE INDEX.)

http://publib.boulder.ibm.com/infoce...v117/index.jsp

#3

On Jan 12, 11:04*am, scottishpoet <drybur... (AT) yahoo (DOT) com> wrote:

Quote:

When you issue the CREATE INDEX statement, the table is locked in
exclusive mode, *however, see The ONLINE keyword of CREATE INDEX.)

http://publib.boulder.ibm.com/infoce...v117/index.jsp

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Table locking during indexing

comp.databases.informix comp.databases.informix

Table locking during indexing - 01-12-2012 , 04:02 AM

Re: Table locking during indexing - 01-12-2012 , 05:04 AM

Re: Table locking during indexing - 01-12-2012 , 09:09 AM