Max No of Partitions

Posted in 2010

SHAHZAD SALAM KASI — Wed, 24 Feb 2010 13:51:27 — source: IIUG Forums & Mailing Lists

Hi, May i know what is the max no of partitions we can have on a table ? We are using 11.50.FC6 & 11.50.FC3W1. Thanks

↪ replying to SHAHZAD SALAM KASI

Alexandre Marini — Wed, 24 Feb 2010 15:42:52 — source: IIUG Forums & Mailing Lists

Hello, maybe the following link could help you... http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.a dref.doc/ids_adr_0718.htm Regards. Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf <http://www.iiug.org>; SHAHZAD SALAM KASI escreveu: > Hi, > May i know what is the max no of partitions we can have on a table ? > > We are using 11.50.FC6 & 11.50.FC3W1. > > Thanks > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > >

↪ replying to SHAHZAD SALAM KASI

Art Kagel — Wed, 24 Feb 2010 15:44:44 — source: IIUG Forums & Mailing Lists

32767 at least because that's the maximum number of dbspaces, but since 11.50 can have multiple partitions per dbspace, it's probably much larger than that. Don't think there is a hard limit. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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 Wed, Feb 24, 2010 at 8:51 AM, SHAHZAD SALAM KASI <skasi@i2cinc.com>wrote: > Hi, > May i know what is the max no of partitions we can have on a table ? > > We are using 11.50.FC6 & 11.50.FC3W1. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517479628609cac04805a8bd3

↪ replying to Art Kagel

Long Nguyen — Thu, 25 Feb 2010 02:50:10 — source: IIUG Forums & Mailing Lists

________________________________ From: Art Kagel <art.kagel@gmail.com> To: ids@iiug.org Sent: Thu, 25 February, 2010 2:44:45 AM Subject: Re: Max No of Partitions [19115] 32767 at least because that's the maximum number of dbspaces, but since 11.50 can have multiple partitions per dbspace, it's probably much larger than that. Don't think there is a hard limit. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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 Wed, Feb 24, 2010 at 8:51 AM, SHAHZAD SALAM KASI <skasi@i2cinc.com>wrote: > Hi, > May i know what is the max no of partitions we can have on a table ? > > We are using 11.50.FC6 & 11.50.FC3W1. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517479628609cac04805a8bd3 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.