Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    38

    Unanswered: Tablespace Size Estimation

    Hello All,
    I've planned to use the following steps to determine the DMS tablespace size. Pls correct me if I'm wrong else pls give your ack. Thanks

    Scenario:
    For a single table I've deceided to use a seperate tablespaces for Index & Data. hence
    Table Size = Avg Byte count per Row * No. of rows
    Avg Byte count per Row is derived using this query after runing the runstats against that table.
    SELECT sum(AVGCOLLEN) FROM SYSCAT.COLUMNS where tabname='TestTable'

    Hence in my case the mathematics involved is as follows..
    Table Size = Avg Byte count per Row * No. of rows
    = 262 * 132800000
    = 34793600000 bytes
    = 32.40406513214 GB

    Can you please let me know whether this inference is correct ? Any suggestions highly appreciated.

    Thanks,
    Vij

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    size

    should be
    take in account small overhead for varchar/nulls and also check if db is created with utf-8 and if using varchar / graphic.....
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Oct 2005
    Location
    pune(india)
    Posts
    24

    check format

    check th e formatting of database

Posting Permissions

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