I'm wondering if there is a way to calculate or estimate the table sizes for tables under a specific schema?
For example I extracted the data from the follow sql into a excel file:
select * from SYSSTAT.TABLES where TABSCHEMA = "TEST"
Now I would like to calculate the sizes of each table or at least to have an estimate. I do not have access to DBA Tools.
I'm asking because I found some calculations on the web that make me think is posible.
"Calculating table space size with AVGROWLEN
Using the maximum row size, you get the following results:
Usable page size = 4074 × 0.95 = 3870 bytes
Records per page = MIN(MAXROWS, FLOOR(3870 / 130)) = 29
Pages used = 2 + CEILING(100000 / 29) = 3451
Total pages = FLOOR(3451 × 21 / 20) = 3624
Estimated number of kilobytes = 3624 × 4 = 14496 KB"
P.S. I'm new with DB2