sysptnext

IDS 11.7 Sysptnext Column Data Type Description pe_partnum integer partnum for this partition pe_extnum smallint extent number pe_phys integer physical addr for this extent pe_size integer size of this extent .................. in what UNIT is this ? pe_log integer logical page for start NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx

Hi Dirk, I would say the unit is pages. I have a table fragmented across 8K dbspaces. Initial extent size is defined in the CREATE TABLE statement as 2097120 and sysptnext.pe_size = 262140. 2097120/262140 = 8 Cheers, Stuart --- Ardenta Ltd is a company registered in England and Wales. Registered number: 4181041. Registered office: Saxon House, Downside, Sunbury on Thames, Middlesex, TW16 6RT. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Dirk Cornel.... Sent: 22 May 2012 09:46 To: ids@iiug.org Subject: sysptnext [27187] IDS 11.7 Sysptnext Column Data Type Description pe_partnum integer partnum for this partition pe_extnum smallint extent number pe_phys integer physical addr for this extent pe_size integer size of this extent .................. in what UNIT is this ? pe_log integer logical page for start NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

pe_size is in pages relative to the pagesize of the dbspace holding the partition. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ 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 Tue, May 22, 2012 at 4:46 AM, Dirk Cornel.... <moolma_dc@mtn.co.za>wrote: > IDS 11.7 > > Sysptnext > > Column Data Type Description > > pe_partnum integer partnum for this partition > > pe_extnum smallint extent number > > pe_phys integer physical addr for this extent > > pe_size integer size of this extent .................. in what UNIT is > this ? > > pe_log integer logical page for start > > NOTE: This e-mail message is subject to the MTN Group disclaimer see > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f83a129044f4f04c09d38a7