Oninit cdi / Archive
Talk to an expert →

pagesize for INFORMIX 10 fc4 on solaris

Posted in 2006

Topics: Platform-Specific Issues

Rajiv Jhaveri — — source: IIUG Forums & Mailing Lists

Folks, What is the database page size of INFORMIX 10.00 FC4 (64 bit) on Sun Solaris 10? Thanks and all help appreciated. -- Rajiv Jhaveri rajiv_jhaveri_06@hotmail.com _________________________________________________________________ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

↪ replying to Rajiv Jhaveri
Richard Snoke — — source: IIUG Forums & Mailing Lists

Hi, The default pagesize is 2048 bytes per page. However, you may create dbspaces and buffer pools with different page sizes. Its a new feature in IDS v10. So a more correct answer is "whichever of 2K, 4K, 6K, 8K, 10K or 12K you want." You are allowed to have dbspaces with different page sizes, but there must be a bufferpool with the corresponding page size. Cheers, Dick Snoke Sr. Consulting IT Specialist dsnoke@us.ibm.com 404 487 1595 "Rajiv Jhaveri" <rajiv_jhaveri_06@hotmail.com> Sent by: ids-bounces@iiug.org 02/23/2006 03:32 PM Please respond to ids To ids@iiug.org cc Subject pagesize for INFORMIX 10 fc4 on solaris [6439] Folks, What is the database page size of INFORMIX 10.00 FC4 (64 bit) on Sun Solaris 10? Thanks and all help appreciated. -- Rajiv Jhaveri rajiv_jhaveri_06@hotmail.com _________________________________________________________________ Don?t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Richard Snoke
Rajiv Jhaveri — — source: IIUG Forums & Mailing Lists

Rich, Thanks for the information. -- Rajiv Jhaveri >From: "Richard Snoke" <dsnoke@us.ibm.com> >Reply-To: ids@iiug.org >To: ids@iiug.org >Subject: Re: pagesize for INFORMIX 10 fc4 on solaris [6440] >Date: Thu, 23 Feb 2006 15:55:59 -0500 (EST) > >Hi, > >The default pagesize is 2048 bytes per page. However, you may create >dbspaces and buffer pools with different page sizes. Its a new feature in >IDS v10. So a more correct answer is "whichever of 2K, 4K, 6K, 8K, 10K or >12K you want." You are allowed to have dbspaces with different page >sizes, but there must be a bufferpool with the corresponding page size. > >Cheers, >Dick Snoke >Sr. Consulting IT Specialist >dsnoke@us.ibm.com >404 487 1595 > >"Rajiv Jhaveri" <rajiv_jhaveri_06@hotmail.com> >Sent by: ids-bounces@iiug.org >02/23/2006 03:32 PM >Please respond to >ids > >To >ids@iiug.org >cc > >Subject >pagesize for INFORMIX 10 fc4 on solaris [6439] > >Folks, > >What is the database page size of INFORMIX 10.00 FC4 (64 bit) on Sun >Solaris 10? > >Thanks and all help appreciated. > >-- >Rajiv Jhaveri >rajiv_jhaveri_06@hotmail.com > >_________________________________________________________________ >Don?t just search. Find. Check out the new MSN Search! >http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > >******************************************************************************* > >Forum Note: Use "Reply" to post a response in the discussion forum. > > >******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/