模板
教程
环境
性能
功能
管理
PRODUCT DB2 LOG SHELL
PRODUCT DB2 LOG SHELL
#! /bin/sh
DT=`date "+%Y%m%d"`
###### 1 week ######
###### DB2 logs ######
find /db/GAL/Prod/logs/NODE0000/* -mtime +7 -print -exec mv -f /db/GAL/Prod/logs/NODE0000/* /backup/GAL/UDB/logs/ \;
#find /db/GPC/Prod/logs/NODE0000/* -mtime +7 -print -exec mv -f /db/GPC/Prod/logs/NODE0000/* /backup/GPC/UDB/logs/ \;
find /db/GSI/Prod/logs/NODE0000/* -mtime +7 -print -exec mv -f /db/GSI/Prod/logs/NODE0000/* /backup/GSI/UDB/logs/ \;
find /db/GPC/Prod/logs/NODE0000/ -type f -mtime +7 -print -exec mv -f {} /backup/GPC/UDB/logs/ \;
###### TWS logs ######
###### remove logs ######
find /backup/GAL/UDB/logs/ -mtime +14 -print -exec rm {} \;
find /backup/GPC/UDB/logs/ -mtime +14 -print -exec rm {} \;
find /backup/GSI/UDB/logs/ -mtime +14 -print -exec rm {} \;
###### 6 months ######
mv -f /home/gpcp/sqllib/db2dump/db2diag.log /backup/GPC/UDB/db2dump/db2diag.log_$DT
mv -f /home/galp/sqllib/db2dump/db2diag.log /backup/GAL/UDB/db2dump/db2diag.log_$DT
mv -f /home/gsip/sqllib/db2dump/db2diag.log /backup/GSI/UDB/db2dump/db2diag.log_$DT
find /backup/GPC/UDB/db2dump/ -name "*.log_*" -mtime +180 -print -exec rm {} \;
find /backup/GAL/UDB/db2dump/ -name "*.log_*" -mtime +180 -print -exec rm {} \;
find /backup/GSI/UDB/db2dump/ -name "*.log_*" -mtime +180 -print -exec rm {} \;
PRODUCT DB2 LOG SHELL
#! /bin/sh
DT=`date "+%Y%m%d"`
###### 1 week ######
###### DB2 logs ######
find /db/GAL/Prod/logs/NODE0000/* -mtime +7 -print -exec mv -f /db/GAL/Prod/logs/NODE0000/* /backup/GAL/UDB/logs/ \;
#find /db/GPC/Prod/logs/NODE0000/* -mtime +7 -print -exec mv -f /db/GPC/Prod/logs/NODE0000/* /backup/GPC/UDB/logs/ \;
find /db/GSI/Prod/logs/NODE0000/* -mtime +7 -print -exec mv -f /db/GSI/Prod/logs/NODE0000/* /backup/GSI/UDB/logs/ \;
find /db/GPC/Prod/logs/NODE0000/ -type f -mtime +7 -print -exec mv -f {} /backup/GPC/UDB/logs/ \;
###### TWS logs ######
###### remove logs ######
find /backup/GAL/UDB/logs/ -mtime +14 -print -exec rm {} \;
find /backup/GPC/UDB/logs/ -mtime +14 -print -exec rm {} \;
find /backup/GSI/UDB/logs/ -mtime +14 -print -exec rm {} \;
###### 6 months ######
mv -f /home/gpcp/sqllib/db2dump/db2diag.log /backup/GPC/UDB/db2dump/db2diag.log_$DT
mv -f /home/galp/sqllib/db2dump/db2diag.log /backup/GAL/UDB/db2dump/db2diag.log_$DT
mv -f /home/gsip/sqllib/db2dump/db2diag.log /backup/GSI/UDB/db2dump/db2diag.log_$DT
find /backup/GPC/UDB/db2dump/ -name "*.log_*" -mtime +180 -print -exec rm {} \;
find /backup/GAL/UDB/db2dump/ -name "*.log_*" -mtime +180 -print -exec rm {} \;
find /backup/GSI/UDB/db2dump/ -name "*.log_*" -mtime +180 -print -exec rm {} \;
