RE: Regarding Non-Default Page Sizes
Yes, you can create it in non-default pagesizes, just be careful with IO levels, making sure your page size is available to fit all your data pages, instead of wasting unused space, ok? Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator - Cleartech Ltda BRIUG website administrator Informix independent consultant From: art.kagel@gmail.com Date: Tue, 31 Jul 2012 07:43:52 -0400 Subject: Re: Regarding Non-Default Page Sizes To: smiley73@gmail.com CC: informix-list@iiug.org Keith, Good questions! For me, I've never thought about it and just use default page sizing for temp dbspaces. I'm not saying that's right, just that I haven't done any testing and I wonder if the IBMers here have an opinion or can report on any testing on this that was done at the labs. 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, Jul 31, 2012 at 6:52 AM, Keith Simmons <smiley73@gmail.com> wrote: I have IDS 10.00.FC5 running on Solaris 5.8 thus I have a default page size of 2k. One of the table (NOT my design !!) has a row size of 1079 so I can only get one row per page. Fragmentation is difficult so I am limited to around 16.77 million rows and I am wasting almost half the allocated space. My intention is to create some dbspaces with 8k page size, thus increasing the number of potential rows seven fold and significantly reducing the wasted space and thus I/O. Question is, what do I do with regard temp dbspaces. Admin Guide says all temp dbspaces must be the same page size, so should I make them 2k (O/S default, current size and the same size as the majority of the dbspaces in the database), or 8k (same size as the new spaces). Is there any advantage/disadvantage either way from a performance or space point of view ? How does an 8k page size map down to a 2k temp dbspace page ? How does a 2k data page map to an 8k temp page space ? ( I think I've may have just answered this one, it doesn't matter as it's the data that is placed in temp not the pages so large temp pages have the same dis/advantages as large dbspace pages and there is no conflict between data and temp page sizes - can someone confirm ? ) I can find nothing relevant either online or in the documentation. Keith _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list