Hi

I have the row count for a table. Is there a way i could find the avergae row size and then use it to calculate table size

row count: X
avg. column size: Y

Table size = X * Y

Please let me know.

Thanks

kayur

sysibm.systables keeps the nbr of rows
syscolumns keeps average column length
make a sum of avg collength * rows

hi

Thanks.

syscolums is fine. i am a little new... can u give the detail SQl query.. that would be great

kayur

first runstats on table to keep real info
db2 "select sum(c.avgcollen)*t.card from sysibm.syscolumns c,sysibm.systables t where c.tbname='xxxx' and c.tbcreator='yyy' and c.tbname=t.name and c.tbcreator=t.creator group by t.card"

to get the real physical size I'd rather go with no of pages and pagesize.

I mean it could be that you have long rows and just using 2/3rd of a page - so then the result could be somewhat irritating.

do db2 'reorgchk update statistics on table tablename' ..look for TSIZE

this has been posted many times..please search the forum before posting