Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Question Unanswered: replication capture tablespace

    hi all

    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
    regds
    Paul

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    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).

  3. #3
    Join Date
    Oct 2007
    Posts
    246

    Cool

    thanx bella

    no i don,t have LOB/long column
    yes capture tables do have indexes and
    as you said non leaf indexes details don,t go in into catalog tables
    could be the reason
    regds
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •