Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2007
    Posts
    33

    Unanswered: Getting table size in db2

    hi,

    Is there any way or db2 utility to get a table size in db2 db?

    thanks

    sanjai

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    yeah, there is a formula but I do not remember it now. google it.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Mar 2008
    Posts
    136
    http://database.ittoolbox.com/groups...in-db2-1691545

    go through by this link

    Regards
    Pawan

  4. #4
    Join Date
    Dec 2007
    Posts
    30
    if you have control center on your work station then right click on the table and click on the estimate size option.this will show u the size of the table and indexes separately in Mb or Kb as u wish.

Posting Permissions

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