Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    3

    Unanswered: Calculating Informix DB Size

    Hi,

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

    Please help. Thanks in advance.

  2. #2
    Join Date
    Jul 2011
    Posts
    2

    DB-Size for 2k-Pages

    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;

  3. #3
    Join Date
    Sep 2010
    Location
    Germany, Brunswick
    Posts
    55
    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;
    WilhelmW

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •