i have sql replication in which i have created a separate tablespace for
capture tables as currently as per syscat.tables
select npages/1024 as MB, tabname from syscat.tables where tbspaceid = 16
the size of npages is 1154
but the list tablespaces show detail shows like this
Total pages = 7119467
Useable pages = 7119467
Used pages = 7119467
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Minimum recovery time = 2009-09-07-01.05.17.000000
COULD this bcoz i have not done reorg on this tables since it was created.
could that be the reason its show this size
Do you have any indexes defined on your capture tables? If so, you need to include them in your calculation. Any tables with LOB/long columns?
The main reason why the numbers of pages in the catalog (assuming runstats are current) and list tablespaces won't match is because the catalog doesn't include storage occupied by LOBs/long (if you have them). It also doesn't include storage occupied by non-leaf index pages (if you have indexes).