Re: Create a temp table seen by all sessions ?!
In a thread on a temp table visible to all sessions, John Miller III noted that from IDS 10 raw tables can have indexes, though not constraints. He said IDS 11 non-blocking checkpoints do not block users while flushing buffers. Keith Simmons had said only temp tables can be unlogged and are private. Mars Chen understood the explanation.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Actually in version 10 and above you may place indexes on raw tables. So you can have a non-logged table with indexes. Now in version 11 checkpoint I/O does not occur while people are locked out, this should satisfy your second requirement.. The only thing you can not do it put constraints on raw tables. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) = "Keith Simmons" = <smiley73@googlem = ail.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Re: Create a temp table seen by = all 07/17/2008 04:25 sessions ?! [12739] = AM = = = Please respond to = ids@iiug.org = = = 2008/7/17 MARS CHEN <mars@jsun.com>: > Thanks you , Obnoxio ... > > I am now using IDS 7.31 , I know about raw table , > but I can not create index in raw table , and I can find > documents that raw table's dirty pages won't flush to chunk > while checkpoint ... > > The only table I know of is temp table , which won't do > flush dirty pages to chunk while do checkpoint , I wonder > if I have IDS 11.50 , is there a way I can have such kind of table ?!= > > Thanks for replying ... > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum. > Mars Only temp tables can be unlogged, but temp tables are only available to their creator. RAW tables have a low overhead but cannot have indexes or constraints. Even at 11.5 there is not the type of table you ar looking for. Rasie a feature request on IBM :-) Keith ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Thanks you , John ... Sorry for my english ... I can not catch what you mean in the following ">>>" Actually in version 10 and above you may place indexes on raw tables. So you can have a non-logged table with indexes. >>>Now in version 11 checkpoint I/O does not occur >>>while people are locked out May I ask what "While people are locked out" mean ?!
In version 11 of IDS there was a feature introduced which is called non-blocking checkpoints. This type of checkpoint does not block any user action when the data from the bufferpool is being flushed to disk (give the proper configuration). This is unlike previous version where either blocking checkpoints or fuzzy checkpoints existed. John = "MARS CHEN" = <mars@jsun.com> = Sent by: = To ids-bounces@iiug. ids@iiug.org = org = cc = Subj= ect 07/17/2008 06:03 Re: Create a temp table seen by = all PM sessions ?! [12776] = = = Please respond to = ids@iiug.org = = = Thanks you , John ... Sorry for my english ... I can not catch what you mean in the following= ">>>" Actually in version 10 and above you may place indexes on raw tables. So you can have a non-logged table with indexes. >>>Now in version 11 checkpoint I/O does not occur >>>while people are locked out May I ask what "While people are locked out" mean ?! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Thanks .... I got your point now ..^^