Oninit cdi / Archive
Talk to an expert →

Database Size

Posted in 2009

Topics: General Discussion

DEEPAK JOSHI — — source: IIUG Forums & Mailing Lists

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.

↪ replying to DEEPAK JOSHI
R Fo — — source: IIUG Forums & Mailing Lists

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 messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

↪ replying to R Fo
DEEPAK JOSHI — — source: IIUG Forums & Mailing Lists

Its an version 7.13. Please let me know

↪ replying to DEEPAK JOSHI
Art Kagel — — source: IIUG Forums & Mailing Lists

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

Related threads