Hi all,

we are using db2 luw 9.7 on linux. We want to use automatic maintenance in our test- and acceptance-Tests-environments.

Im looking for configuration possibilities for automatic backup,pls can you help how to enable automatic backups. I already enabled the db cfg parameters Like below
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 statement statistics (AUTO_STMT_STATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = ON
But the automatic backup process conn’t takes place how to set that db2automaintpolicysample.xml file .


Thanks in advance

have a look here
Configure automatic maintenance in DB2 for Linux, UNIX, and Windows with SQL interface

thanks to helping me
ur posts are very hepling to me

pls tell me how to restore a backup in a different server means

For example I have taken a backup (with include logs option) in some server 112.1.1.5 and i have to restore it on 112.1.1.10 server both are having same confg. AIX 6.1 and db2 V9.7


Regards
Siddhu

if different questions - open new entry in forum ..

have also a look at infocenter about backup-restore and limitations and pre-req..
IBM DB2 9.7 for Linux, UNIX and Windows Information Center

i go through that Przytula
but i didnt get those topics in that yar pls help me i have to do that to day

and also am getting normal backup taking and restoring process in IBM info center

but that is not my requirement na thats y am asking to help

I can help if you have a specific question/problem
teaching you DB2 is not my role (now.. because I could if needed)
reading is something you have todo, to understand how db2 backup/restore operates..