Oninit cdi / Archive
Talk to an expert →

RE: Create a temp table seen by all sessions ?!

Posted in 2008

Topics: Storage & Space Management, Logging & Checkpoints, Versions, Editions & End-of-Life

Plugge, Joe R. — — source: IIUG Forums & Mailing Lists

I think that with the advent of IDS 10.00 , RAW tables could be indexed, just no constraints placed on them. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Keith Simmons Sent: Thursday, July 17, 2008 6:26 AM To: ids@iiug.org Subject: Re: Create a temp table seen by all sessions ?! [12739] 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.

↪ replying to Plugge, Joe R.
Art Kagel — — source: IIUG Forums & Mailing Lists

Indexed yes (including unique indexes), referential and unique constraints no. Art On Thu, Jul 17, 2008 at 8:36 AM, Plugge, Joe R. <JRPlugge@west.com> wrote: > I think that with the advent of IDS 10.00 , RAW tables could be indexed, > just no constraints placed on them. > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Keith Simmons > Sent: Thursday, July 17, 2008 6:26 AM > To: ids@iiug.org > Subject: Re: Create a temp table seen by all sessions ?! [12739] > > 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. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Glossary