Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2009
    Posts
    62

    Unanswered: Manual/Automatic Maintenance Tasks

    Guys, part of the DB2s I'm responsible of are configured to run tasks for Reorgs and Runstats. It's OK, they are fine this way, the tasks run OK and they meet the purpose they were created for.

    Recently I needed to change two of my servers, and I decided to leave the maintenance configuration as follows:

    Automatic maintenance (AUTO_MAINT) = ON
    Automatic database backup (AUTO_DB_BACKUP) = OFF
    Automatic table maintenance (AUTO_TBL_MAINT) = ON
    Automatic runstats (AUTO_RUNSTATS) = ON
    Automatic statement statistics (AUTO_STMT_STATS) = ON
    Automatic statistics profiling (AUTO_STATS_PROF) = OFF
    Automatic profile updates (AUTO_PROF_UPD) = OFF
    Automatic reorganization (AUTO_REORG) = ON

    Now that I'm revising the tasks, I ask you: do I still need to run tasks on Reorg and Runstats, or does the DB will take care of these for me?

    thanks

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    what you control yourself, it is always better
    if autom.maint. it will run in a pre-defined maint.window (default 0-24hrs)
    if you have a script - continue to use the script and decide which table, when needs runstats and reorg..
    auto might be good for dev-env. but not for acc or prd..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2011
    Posts
    45
    It only does online maintenance of the tables(in which indexes are not rebuilt).
    For that purpose you have to manually perform offline reorg.

  4. #4
    Join Date
    Dec 2009
    Posts
    62
    Thanks guys. Will do ;-)

  5. #5
    Join Date
    Dec 2009
    Posts
    62
    Hi all,

    I already configured tasks for REORG and RUNSTATS on the main tables, at least the tables with indexes, as follows:

    reorg indexes all for table SIEM.PJ_TRAN;

    runstats on table SIEMTR.PJ_TRAN with distribution and detailed indexes all allow read access;

    REORG happens once a week, sundays at night.
    RUNSTATS every day also late at night.

    Is there any problem or conflict if I leave the Automatic Maintenance configured as in my first post above along with the new tasks?

    If so, what options of the Automatic Maintenance should I keep ON to work with the new tasks? (or maybe none?)

    thanks

Posting Permissions

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