UDB 8.2 FP7
OS: Sol 2.8

HI , I got a couple of questions.

How do i find the total size of an existing table ? I mean how much space it occupied currently.

2) How do i estimate the growth for a new table?

Try out the TSIZE result from a reorgchk.

Or do runstats and check table size from the Control Center

Concerning growth:

Estimate how many new rows you get pr. day and multiply it
by row storage requirement, i.e. the sum of space requirements
for all columns in your table.

If you have varchar columns the porcess migth be a little harder
because ypu have to assigne probalilties to the length of the
string inserted in each variable column

Good Luck

There are other considerations as well ... Eg. max number of rows in a page is 255 ...
Have a look at the documentation

http://publib.boulder.ibm.com/infoce...n/c0004924.htm

HTH

Sathyaram