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

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.....

check th e formatting of database