Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    115

    Unanswered: sybase reorg script

    Hi

    Does somebody have a script to identify the tables that would benefit from a reorg.
    And then generate a script to reorg the tables

    regards

  2. #2
    Join Date
    Mar 2009
    Location
    Sydney, Australia
    Posts
    258
    Sure, we have such a script. It does the following:
    - checks the actual fragmentation (various) status of the tables and its indices
    - it also handles partitionsos , that it only reorgs the partition required
    - given input parameters, one per each derived status, if these are exceeded, it writes a reorg_<type> <table> <index> <partition> script for either the table/index/partition (without doubling up)
    - designed for minimising teh maintenance window
    - with a generic script name (useful for a standing crontab entry) or specific name
    - alloing for parallel execution (one script is split into eg. 8 balanced scripts) on eg. 8 engines
    - optionally executes the script
    - also reports on the various fragmentation statuses without producing a script (useful for watching growth, fragmentation and capacity planning).

    We have a similar script for update statistics (again table/index/partition/column). This requires a small structure in the db to keep track of the growth/change of each column, which it uses as the basis for deciding that stats need to updated. High performance, no repetition, minimised execution time.

    Both are highly configurable and commercial. If you are interested send us an email.

    Otherwise, I am happy to remain here and answer questions.
    Regards
    Derek Asirvadem (Formerly DerekA)
    Information Architect / Senior Sybase DBA
    Copyright 2009 Software Gems Pty Ltd

    I answer questions from the Original Poster only. If you have a genuine question, as the moderators have requested, start a new thread.

    http://www.softwaregems.com.au

Posting Permissions

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