Re: Can the 32 bit version of Informix 9.4 (9.40.UC3) use chunks over 2 gig, and

Posted in 2004

Rajib Sarkar — Fri, 27 Aug 2004 14:49:47 -0700 — source: Usenet: comp.databases.informix

--0__=88BBE46EDFE442938f9e8a93df938690918c88BBE46EDFE44293 Content-type: multipart/alternative; Boundary="1__=88BBE46EDFE442938f9e8a93df938690918c88BBE46EDFE44293" --1__=88BBE46EDFE442938f9e8a93df938690918c88BBE46EDFE44293 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Using chunks > 2GB has nothing to do whether its 32-bit or 64bit engine= .. we had to change our page structure in order to accomodate > 2GB chunks= in 9.40.xx .. so to answer ur question ..yest 32bit version will be able t= o address > 2GB chunk in the version u mentioned. Thanx much, Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = "Ostrar, Michael = \\(GEI, GEFA\\)" = <Michael.Ostrar@g = To e.com> <informix-list@iiug.org> = Sent by: = cc owner-informix-li = st@iiug.org Subj= ect Can the 32 bit version of Inform= ix 9.4 (9.40.UC3) use chunks over 2= 08/27/2004 10:23 gig, and if so, any = AM recommendations? = = = = = = = My group is preparing to move our Informix 9.40.UC3 instances running u= nder Solaris 2.6 to newer, more powerful Sun servers running under Solaris 2= .8. We currently (using Veritas volume manager) have or chunks defined as 2= gig on one server from which we plan to migrate and 1 gig on the rest from which we'll be migrating. I know that chunks up to 4 terabytes are possible with 9.4. However, = I have only seen references to this using 9.40.FC3 (the 64 bit version) a= nd not 9.40.UC3 (the 32 bit version). So, the first question I have is if chunks 4 gig or greater are possib= le with 9.40.UC3. The second question I have, regardless of the answer to the first is if= there are any guidelines for chunk sizes? We don't do enough with blob= spaces for them to be much of a factor in any decision we'd make. Howe= ver, we do a fair amount of separating tables into different dbspaces, as we= ll as always keeping root, physical log, logical log, temp and data/index spaces separate from each other. I'd be interested in what the tradeoff= s are in terms of performance versus possibly wasting space by going to larger chunks. sending to informix-list = --1__=88BBE46EDFE442938f9e8a93df938690918c88BBE46EDFE44293 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> Using chunks > 2GB has nothing to do whether its 32-bit or 64bit = engine .. we had to change our page structure in order to accomodate &g= t; 2GB chunks in 9.40.xx .. so to answer ur question ..yest 32bit versi= on will be able to address > 2GB chunk in the version u mentioned.<b= r> Thanx much, Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison <img src=3D"cid:10__=3D88BBE46EDFE442938f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Ostrar, Micha= el \\(GEI, GEFA\\)" <Michael.Ostrar@ge.com>">"Ostrar, Mic= hael \\(GEI, GEFA\\)" <Michael.Ostrar@ge.com> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE46= EDFE442938f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul>"Ostrar, Michael \\(GEI, GEFA\\)" <M= ichael.Ostrar@ge.com> Sent by: owner-informix-list@iiug.org 08/27/2004 10:23 AM</ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE46EDFE442938f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">To</div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE46EDFE442938f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> <informix-list@iiug.org></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE46EDFE442938f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">cc</div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE46EDFE442938f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE46EDFE442938f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">Subject</div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D88BBE46EDFE442938f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> Can the 32 bit version of Informix 9.4 (9.40.UC3) use = chunks over 2 gig, and if so, any recommendations?</td></tr> </ta