Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013
    Posts
    3

    Unanswered: DEFRAGMENT+REPACK+SHRINK with IDS 11.7FC5

    Hi All,

    To keep the number of table extents low and to release some unused pages within the dbspace I use a self made script which does ...

    1. EXECUTE FUNCTION TASK("defragment","database:table")
    to reduce extents

    2. EXECUTE FUNCTION TASK("table repack","table","database","tab owner")
    to get rid of empty pages (if exist) and move to content to free pages

    3. EXECUTE FUNCTION TASK("table shrink","table","database","tab owner")
    to give free space back to dbspace

    This works fine apart from some exceptions I struggle with.
    In some cases every single command (mentioned above) ends up with OK/successful but at the end nothing changed, i.e. for a table called TAB1 which has the following properties:

    TAB1 (with pagesize 4K)
    14 pages used
    14 pages allocated
    fextsize 16
    nextsize 16
    3 extents

    Maybe I have some gaps in my knowledge, but for the moment I'm not able to logically combine in my head what to do to bring the no of extents down to 1

    Best regards from Germany and thanks in advance for any help

  2. #2
    Join Date
    Jun 2013
    Posts
    3

    Further option but no improvement

    Found out that a shrink before the defragment task my help but it didn't...

    Still need your help and ideas guys!

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
  •