使用用户出口程序使日志文件归档和检索自动进行

需要把脚本 db2uext2 在 root 下复制到  /home/db2inst1/sqllib/bin/ 目录下

并且修改权限，不知道不改能不能用，反正改改吧

chown bin:bin db2uext2

chmod 755 db2uext2

然后修改数据库配置

db2 get db cfg for DBNAME | grep LOGARCH

db2 update db cfg for DBNAME  using LOGARCHMETH1 USEREXIT

然后重启数据库生效

目前只实现了存档功能ARCHIVE，没有实现恢复功能，数据库恢复时靠指定日志路径进行恢复

db2uext2 脚本文件的内容

#!/bin/bash
#db2uext2 -OSLinux -RLSQL07020 -RQARCHIVE -DBDBNAME -NN0 -LP/data/archlog/ -LNS0000123.LOG
#copy archived log file to remote host, do not delete local log file!!!
#do not delete local log file!!!

RHOST=192.168.0.180
RROOT=/data/backup/

LROOT=/data/archlog/

DIR=/opt/admin/db2
LOG=$DIR/log/archive-log.log

RQ=""
DB=""
LP=""
LN=""

for arg in "$@"
do
    opt=${arg:1:2}
    val=${arg:3}

    if   [ "$opt" = "RQ" ]; then
        RQ="$val"
    elif [ "$opt" = "DB" ]; then
        DB="$val"
    elif [ "$opt" = "LP" ]; then
        LP="$val"
    elif [ "$opt" = "LN" ]; then
        LN="$val"
    fi
done

now=`date +'%Y-%m-%d %H:%M:%S'`
today=`date +%Y-%m-%d`

LPATH=$LROOT$DB/archlog/
LFILE=$LPATH$LN

if [ "$RQ" = "ARCHIVE" ]; then
    if [ ! -d $LPATH ]; then
        echo create local archive log path $LPATH
        mkdir -p $LPATH >> $LOG
    fi

    scp $LP$LN $LPATH  >> $LOG

    RPATH=$RROOT$DB/$today/archlog

    message="$now move $LFILE -> $RHOST:$RPATH"

    ssh $RHOST mkdir -p $RPATH >> $LOG
    rsync -q -auPv $LFILE $RHOST:$RPATH >> $LOG

    rm $LFILE

    #echo $message
    echo $message >> $LOG
else
    echo RESTORE
fi