Hi Thanks in advance ,


I have a small doubt , actually am trying to activate automatic maintenance for my database (siddhu) by enabling the parameter auto_maint .

To do this, is there any prerequisite steps to perform on data base ?

and one more thing after enabling the auto_maint paramter, is there any steps to perform on the data base ? please give me a fast reply


I want to enable automatic backups ,reorgs,runstats on my data base .

My db2 version is 9.7

please give me reply with all commands in sequence

From
Siddhu

on these pages and related - all info is available
Automatic features - IBM DB2 9.7 for Linux, UNIX, and Windows

Thanks

One more thing i have to know .


in the link

"Automatic database backups

A database can become unusable due to a wide variety of hardware or software failures. Ensuring that you have a recent, full backup of your database is an integral part of planning and implementing a disaster recovery strategy for your system. Use automatic database backups as part of your disaster recovery strategy to enable the database manager to back up your database both properly and regularly."

I saw this but i didn't get proper meaning of this . can you pls tel me when , the automatic backup process is going on for our database with example pls pls

never rely on defaults or ...
ALWAYS schedule the backup yourself with all needed options and settings
in that case you get what you need....
for all syntax look at infocenter for details.. or do some reading on DB2 and HA..
there is a special manual for this..