dbTalk Databases Forums  

Table locking during indexing

comp.databases.informix comp.databases.informix


Discuss Table locking during indexing in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Cats
 
Posts: n/a

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






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.

Reply With Quote
  #2  
Old   
scottishpoet
 
Posts: n/a

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






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

Reply With Quote
  #3  
Old   
Cats
 
Posts: n/a

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



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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.