DB2 :- crontab for DB2 DB backup and purging old logs

 

[db2inst1@hostname01 BKP]$ crontab -l

##Archive logs every 15 mins

*/15 * * * * sh /dbdata/db2inst1/dbbackup/script/archive_log.sh manoj

##Archive puging

30 21 * * * /dbdata/db2inst1/dbbackup/script/archlog_purge.sh >/dev/null 2>&1

## DB FULL backup

0 3 * * 0  sh /dbdata/db2inst1/dbbackup/script/backup_manoj.sh

## DB incremental backup

0 3 * * 1-6  sh /dbdata/db2inst1/dbbackup/script/backup_manoj_incr.sh

[db2inst1@hostname01 BKP]$

[db2inst1@hostname01 BKP]$ cat /dbdata/db2inst1/dbbackup/script/archive_log.sh

. /dbdata/db2inst1/sqllib/db2profile

DB=$1

LOGFILE=/dbdata/db2inst1/dbbackup/arch/archive_${DB}_`date +%Y-%m-%d`.log > $LOGFILE

db2 archive log for db $DB  >> $LOGFILE 2>&1

[db2inst1@hostname01 BKP]$

[db2inst1@hostname01 BKP]$ cat  /dbdata/db2inst1/dbbackup/script/archlog_purge.sh

. /dbdata/db2inst1/sqllib/db2profile

##Archivelogs purge for manoj

find /mnt/bludata0/db2/archive_log/db2inst1/manoj/NODE0000/LOGSTREAM0000/ -name "*.LOG" -mtime +7 -exec rm {} \; >> /dbdata/db2inst1/dbbackup/arch/arch_purge_test.log

[db2inst1@hostname01 BKP]$

[db2inst1@hostname01 BKP]$ cat /dbdata/db2inst1/dbbackup/script/backup_manoj.sh

. /dbdata/db2inst1/sqllib/db2profile

LOGFILE=/dbdata/db2inst1/dbbackup/full/backup_daily_manoj_`date +%Y-%m-%d`.log> $LOGFILE

cd /dbdata/db2inst1/dbbackup/full

find /dbdata/db2inst1/dbbackup/full/ -name '*.001' -mtime +30 -exec rm {} \;

db2 backup db  manoj online compress include logs  > $LOGFILE 2>&1

[db2inst1@hostname01 BKP]$

[db2inst1@hostname01 BKP]$ cat /dbdata/db2inst1/dbbackup/script/backup_manoj_incr.sh

. /dbdata/db2inst1/sqllib/db2profile

LOGFILE=/dbdata/db2inst1/dbbackup/incr/backup_daily_manoj_`date +%Y-%m-%d`.log> $LOGFILE

cd /dbdata/db2inst1/dbbackup/incr

find /dbdata/db2inst1/dbbackup/incr/ -name '*.001' -mtime +30 -exec rm {} \;

db2 backup db  manoj online incremental compress include logs  > $LOGFILE 2>&1

[db2inst1@hostname01 BKP]$