Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2011
    Posts
    43

    Red face Unanswered: Testing Automaintenace in db2

    Hi , Thanks in advance


    I enabled all automatic maintenace parameters but how can i check its working on my database or not?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version and OS? What did you turn on exactly?

    Andy

  3. #3
    Join Date
    Nov 2011
    Posts
    43

    Testing

    db2 V9.7 and os linux 6.1

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    And what exactly did you turn on?

    Andy

  5. #5
    Join Date
    Nov 2011
    Posts
    43
    Automatic maintenance (AUTO_MAINT) = ON
    Automatic database backup (AUTO_DB_BACKUP) = ON
    Automatic table maintenance (AUTO_TBL_MAINT) = ON
    Automatic runstats (AUTO_RUNSTATS) = ON
    Automatic statistics profiling (AUTO_STATS_PROF) = OFF
    Automatic profile updates (AUTO_PROF_UPD) = OFF
    Automatic reorganization (AUTO_REORG) = OFF


    Like that i did

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    To check if backup ran:

    LIST HISTORY BACKUP SINCE 20111101 for MyDB

    To check runstats:

    select tabschema,tabname,stats_time from syscat.tables where stats_time > {last check time}

    Now a comment on performing backups with automaint. I think it is a bad idea because you have better control of everything if you do it differently. What happens if automaint determines a backup is not needed for an extended time? This would greatly increase your risk and recovery time from a disaster. Can automaint do the backup exactly as you need?

    I have found it is just easier to use cron to schedule a regular backup. That way you know it always gets done.

    Andy

  7. #7
    Join Date
    Nov 2011
    Posts
    43
    Thank you andy for ur good suggetion but that is our requirement


    can u tel me how to check reorg information plsss?

  8. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    check db2diag.log - runstats/backup entry if auto has run
    if stats are up-to-date it can take some time/days..
    backup history can be found in history file also
    as indicated before : it might be possible that backup/runstats is running when system is highly used..
    it would be better to schedule this with a script at the time of day/night when low usage on db
    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

Posting Permissions

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