|
2006-10-18-00.51.23.786726+480 I5172512C421 LEVEL: Warning
PID : 372766 TID : 1 PROC : db2logmgr (KABUSR) 0
INSTANCE: kabusr1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180
MESSAGE : Successfully archived log file S0002904.LOG to
/kabusr1/arclog/kabusr1/KABUSR/NODE0000/C0000000/ from
/kabusr1/kabusr/actlog/NODE0000/.
2006-10-18-00.51.52.517843+480 I5172934C317 LEVEL: Event
PID : 1040480 TID : 1272 PROC : db2hmon 0
INSTANCE: kabusr1 NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:10
START : Automatic reorg evaluation has started on database KABUSR
2006-10-18-00.51.52.756192+480 I5173252C331 LEVEL: Event
PID : 1040480 TID : 1272 PROC : db2hmon 0
INSTANCE: kabusr1 NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:20
START : Automatic reorg evaluation has finished successfully on database KABUSR
myhost=`hostname`
Mail="ww@test.com"
filedate=`date +"%Y-%m-%d"`
[color="red"]grep -p "$filedate" /db2dump/db2diag.log > /tmp/db2diag.log # 这条语句只能取某个特定时间而不能针对某个时间范围
mail -s "$myhost log of $filedate" $Mail </tmp/db2diag.log
我的疑问是如果要抽取数据的要求是从昨天8点----今天8点,请问这个应该如何写?
谢谢 |
|