db2 online backup shell

href="file:///C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/msohtml1/01/clip_filelist.xml" rel="File-List" />

#!/bin/sh

usage()

{

    echo "usage: $0 <DatabaseName>"

    exit 1;

}

 

log_message()

{

    message=$1

    timestamp=`date "+%m/%d/%Y %H:%M:%S"`

    echo "$timestamp $message" >> $LOG

}

 

# Database name is the first argument.

if [ $# -eq 0 ]

then

    usage

fi

 

# Set DB2 environment

. $HOME/sqllib/db2profile

 

DBNAME=$1

BACKUPDIR=/home/db2inst1/db2backup

LOG=/home/db2inst1/db2backup/db2backup.log

 

log_message "*********************************************************************************************************";

log_message "********************************Begin********************************************************************";

log_message "*********************************************************************************************************";

# Make sure there are no active applications

 

NUM=`db2 get db cfg for $DBNAME | grep '(LOGRETAIN) = RECOVERY' | wc -l`

if [ $NUM -ne "1" ]

then

   log_message "The value of LOGRETAIN is 'OFF'. Terminate 30 seconds for changing it's value to 'RECOVERY'"

   db2 update db cfg for $DBNAME using LOGRETAIN ON   >> $LOG 2>&1

   sleep 30

fi

 

NUM=`db2 get db cfg for $DBNAME | grep 'TRACKMOD = ON' | wc -l`

 

if [ $NUM -ne "1" ]

then

            log_message "The value of TRACKMOD is 'OFF'. Terminate 30 seconds for changing it's value to 'ON'"

            db2 update db cfg for $DBNAME using TRACKMOD ON

            sleep 30

fi

 

# Connect to database

log_message "Connecting to database $DBNAME"

db2 connect to $DBNAME >> $LOG 2>&1

 

# Take Backup

log_message "Backing up database to $LOG (online incremental)....This will take a while";

db2 backup database $DBNAME online incremental to $BACKUPDIR compress include logs without prompting >> $LOG 2>&1

 

 

log_message "*********************************************************************************************************";

log_message "********************************End**********************************************************************";

log_message "*********************************************************************************************************";