Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  backup configuration in fs level

    Posted 01/23/23 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 01/24/23 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
    ------------------------------