Results 1 to 1 of 1

Thread: Find Table size

  1. #1
    Join Date
    Jul 2005
    Posts
    19

    Unanswered: Find Table size

    OS: IBM AIX
    DB: DB2 9.0

    Iam trying to find the size of the table using the following query.

    select char(date(t.stats_time))||' '||char(time(t.stats_time)) as
    statstime
    ,substr(t.tabschema,1,4)||'.'||substr(t.tabname,1, 24) as tabname
    , card as rows_per_table
    , decimal(float(t.npages)/ ( 1024 / (b.pagesize/1024)),9,2) as used_mb
    , decimal(float(t.fpages)/ ( 1024 / (b.pagesize/1024)),9,2) as
    allocated_mb
    from syscat.tables t

    - Edited: Working fine. Pls cancel this thread
    Last edited by sgmane; 04-11-09 at 01:55.

Posting Permissions

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