Database Size
Deepak Joshi asked how to check database and table size on Informix 7.13. R Fo suggested sysmaster syschunks for space and sysfragments for tables. Art Kagel supplied a query joining sysmaster:sysptnheader and systabnames to show nrows, npused and npdata for a table, noting that multiple rows mean detached indexes or fragments.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Can anybody help me to check the Database size, size of a particular table? We are using Informix 7.13 running on HP-UNIX 10.01.
Hi is the version 7.13 or 7.31 ? In the sysmaster database, exists a table called syschunks (if I'm not wrong) ... There is the total pages of the chunk and the free pages... you should multiply it by the page size... For a specific table, take a look in the sysfragments table ... BR R Ferronato > To: ids@iiug.org > From: djoshih@hotmail.com > Subject: Database Size [17218] > Date: Mon, 28 Sep 2009 11:27:57 -0400 > > Can anybody help me to check the Database size, size of a particular table? > > We are using Informix 7.13 running on HP-UNIX 10.01. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ More than messagescheck out the rest of the Windows Live. http://www.microsoft.com/windows/windowslive/
Its an version 7.13. Please let me know
select st.partnum, nrows, npused, npdata from sysmaster:sysptnheader sp,sysmaster:systabnames st
where st.dbsname = 'mydatabase' and st.tabname = 'mytable'
and st.partnum = sp.partnum;
If you get multiple rows, some will be detached indexes for the table and
others will be table/index fragments if the table/index is fragmented.
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 Mon, Sep 28, 2009 at 11:27 AM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
> Can anybody help me to check the Database size, size of a particular table?
>
> We are using Informix 7.13 running on HP-UNIX 10.01.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0023545bd658a7b2880474adfb6b