Information in partition header page
Posted in 2011
Topics: General Discussion
Hi, I want to know What's information being stored in partition header page, thanks for your help.
Look at the sysmaster:sysactptnhdr record and the sysmaster:sysextents records for a table. These are the two biggest parts of the partition header page (though in 11.70 the extents list can expand beyond the initial header page). The rest of the partition header page describes "special" column which includes UDT, BLOB, and SLOB type columns in the table and attached index keys (which only exist for legacy databases that have been upgraded over the years from 7.2x and before with indexes that have not been rebuilt since before the upgrade to 7.31or later). 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, Nov 15, 2011 at 10:18 PM, CHUAN LU <luchuan@cn.ibm.com> wrote: > Hi, > > I want to know What's information being stored in partition header page, > thanks for your help. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f3ba1fd8b91be04b1d1b0e1