Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2013
    Posts
    20

    Question Unanswered: Tablespace fragmentation

    Hello,

    I was wondering, is there any way to check the level of tablespace fragmentation? If bigger tables are compressed in the tablespace, some tablespace extents become free. They can easily be reused by other tables as they grow, but if they don't - tablespace stays highly fragmented. This may increase the backup time drastically.. So I want to know if I need to look at tablespace fragmentation reduction at all.
    db2 9.7.0.8 on Linux.

    Regards,

    Tomas

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    You can dump the HWM info for this tablespace:
    Code:
    db2dart dbname /DHWM /TSI tbsp_id
    and look into the report file.
    There will be info on which extend belongs to which object including '== EMPTY ==' extents.
    Regards,
    Mark.

  3. #3
    Join Date
    Jan 2013
    Posts
    20
    Hi Mark,

    Many thanks! This was exactly what I was looking for

    Thanks and Regards,

    Tomas

Tags for this Thread

Posting Permissions

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