dbTalk Databases Forums  

lock table in exclusive mode

comp.databases.informix comp.databases.informix


Discuss lock table in exclusive mode in the comp.databases.informix forum.



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

Default lock table in exclusive mode - 01-24-2012 , 03:32 PM






hello all

the manual states "This mode denies other processes both read and
write access to the table".
Does it also affect the dynamic allocating of locks?

thanks

Reply With Quote
  #2  
Old   
Art Kagel
 
Posts: n/a

Default Re: lock table in exclusive mode - 01-24-2012 , 03:39 PM






I don't understand the question.

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 Tue, Jan 24, 2012 at 4:32 PM, Tom Lehr <tomcaml (AT) gmail (DOT) com> wrote:

Quote:
hello all

the manual states "This mode denies other processes both read and
write access to the table".
Does it also affect the dynamic allocating of locks?

thanks
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Reply With Quote
  #3  
Old   
Jonathan Leffler
 
Posts: n/a

Default Re: lock table in exclusive mode - 01-24-2012 , 09:53 PM



[Second send; omitted the list first time.]

On Tue, Jan 24, 2012 at 13:32, Tom Lehr <tomcaml (AT) gmail (DOT) com> wrote:

Quote:
the manual states "[Lock table in exclusive] mode denies other processes
both read and

write access to the table".
Does it also affect the dynamic allocating of locks?

If the table is locked exclusively, a single lock does for everything, so
you will be less likely to need to dynamically allocate more locks. On the
other hand, it reduces concurrency on the table to zero; no-one else can
use it while you are using it.

--
Jonathan Leffler <jonathan.leffler (AT) gmail (DOT) com> #include <disclaimer.h>
Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

Reply With Quote
  #4  
Old   
Tom Lehr
 
Posts: n/a

Default Re: lock table in exclusive mode - 01-25-2012 , 03:42 PM



thanks - that is what i was meaning
tom

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.