Calculating Informix DB Size

suryaaravindh · #1 (**permalink**) 07-06-11, 02:46

Hi,

How do I find out the size of Informix db in Unix Solaris 8.

Please help. Thanks in advance.

estjump · #2 (**permalink**) 07-08-11, 10:34

try out this:

SET ISOLATION TO DIRTY READ;

SELECT dbsname,
round(sum(nptotal)*2/1024,2) total_mb,
round(sum(npused)*2/1024,2) used_mb,
round(sum(npdata)*2/1024,2) data_mb
FROM sysmaster:systabnames t1, sysmaster:sysptnhdr t2
WHERE t1.partnum = t2.partnum
AND dbsname != "HASHTEMP"
AND tabname != "TBLSpace"
GROUP BY dbsname
ORDER BY 2 desc;

InformixWilli · #3 (**permalink**) 07-11-11, 03:47

Use this for IDS 11.50 and above (pagesize doesn't matter):

Code:

SELECT    dbsname,
          round(sum(nptotal)*(t2.pagesize/1024)/1024,2) mb_total,
          round(sum(npused)*(t2.pagesize/1024)/1024,2) mb_used,
          round(sum(npdata)*(t2.pagesize/1024)/1024,2) mb_data
FROM      sysmaster:systabnames t1, sysmaster:sysptnhdr t2
WHERE     t1.partnum = t2.partnum
AND       dbsname != "HASHTEMP"
AND       dbsname != "BEFIMAGE"
AND       dbsname != "SORTTEMP"
AND       tabname != "TBLSpace"
GROUP BY  dbsname, t2.pagesize
ORDER BY  2 desc;

Internet Services

Web Development

Digital Marketing

Consumer Tech