Db2

 View Only

  • 1.  backup configuration in fs level

    Posted Mon January 23, 2023 11:38 AM
    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 Tue January 24, 2023 07:12 AM
    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
    ------------------------------

    Original Message