Db2

 View Only
  • 1.  backup configuration in fs level

    Posted 15 days ago
    Hi Team,

    Can you please provide the steps for backup configuration in fs level 

    1> how to take the daily backup 
    2>how to take the weekly backup 
    3> how to delete the backup image every 3 days 
    3>how to take hourly transaction log 


    ------------------------------
    meghana m
    ------------------------------


  • 2.  RE: backup configuration in fs level

    Posted 14 days ago
    Hi Meghana
    You can use cron to schedule your backups at what ever interval you require.
    Db2 has the ability to delete recovery objects automatically by enabling the AUTO_DEL_REC_OBJ configuration parameter.  In conjunction with the REC_HIS_RETENT and NUM_DB_BACKUPS parameters you can have the database engine remove unwanted recovery objects.
    Enabling LOGARCHMETH1 will retain the log files, and the aforementioned parameters will also removed them after the specified period of time.

    Hope this helps

    ------------------------------
    Dale McInnis
    ------------------------------