Max No of Partitions
Shahzad Salam Kasi, on 11.50.FC6 and FC3W1, asked the maximum number of partitions on a table. Alexandre Marini pointed to the IBM documentation. Art Kagel said it is at least 32767, the maximum number of dbspaces, and probably much larger because 11.50 allows multiple partitions per dbspace, adding that he knew of no hard limit. No exact figure was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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. > > > >
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
________________________________ 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.