Upper Limit on Extents

Hi, I read in the performance manual the procedure to obtain the upper limit of number of extens for a table, but it said that I have to run the oncheck command with two options, is there another way to obtain this limit without using the oncheck command? I don't have permission to run oncheck command and I'm usinig version 9.4. Thanks.

Hi, there should be a section in the release notes (check $INFORMIXDIR/release/en_us/0333 directory) about limits ... Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland Research & Development GmbH Chairman of the Supervisory Board: Martin Jetter Board of Management: Erich Baier Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 ids-bounces@iiug.org wrote on 03.07.2009 04:07:18: > Hi, > > I read in the performance manual the procedure to obtain the upper limit of > number of extens for a table, but it said that I have to run the oncheck > command with two options, is there another way to obtain this limit without > using the oncheck command? > > I don't have permission to run oncheck command and I'm usinig version 9.4. > > Thanks. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hi: You will get different upper limit of the number of extent, this is depended on your table's definition and which page size you used to store the table, so maybe you have to get the real information by oncheck or other tools only, you need to read the partition page's information.

You are running IDS 9.40 so there is only one pagesize, the default pagesize. That would be 2K unless you are running on AIX or Windows where the default pagesize is 4K. So, general rule, on a 2K pagesize machine the maximum number of extents that any partition (read partition as a table, a detached index, or a fragment of a table or index) can have is about 216. This is further reduced for tables with attached indexes (usually inherited from a 7.2x server that was upgraded in place) by the index key length over eight, and by the number of 'special' column (blobs, varchars, etc.). On a 4K pagesize machine use 472 as the maximum. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Thu, Jul 2, 2009 at 10:07 PM, PEDRO PEREZ <pedro2263@gmail.com> wrote: > Hi, > > I read in the performance manual the procedure to obtain the upper limit of > number of extens for a table, but it said that I have to run the oncheck > command with two options, is there another way to obtain this limit without > using the oncheck command? > > I don't have permission to run oncheck command and I'm usinig version 9.4. > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5adfe6f0143046df757e7