how to find the table size?
any query is there to find out table size?
and without using query how to find table size?

What do you mean by table size? number of rows? number of bytes?

There is no way without a query to determine size.

Andy

i want no of bytes
without using query we can get by using runstats am i right...?


Thanks in advance

Hello

sorry not runstats.... by using reorgchk we get one column about table size.....is it useful to find the table size..

What does count to the table size? Do you include free space allocated in pages for the table? With simple tablespaces (DB2 z/OS), you can have rows from different tables on the same page - how do you deal with that? How about regular overhead like record headers, page headers, ...

Basically, for DB2 LUW you will find in the manual all the formulas to do space estimates for tables.