Hi , Thanks in advance


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

What DB2 version and OS? What did you turn on exactly?

Andy

db2 V9.7 and os linux 6.1

And what exactly did you turn on?

Andy

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

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

Thank you andy for ur good suggetion but that is our requirement


can u tel me how to check reorg information plsss?

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