#!/usr/bin/ksh
###############################################################################################################
# Script name: get_table.sh
# Script description: Get "db2pd -d <dbname> -tab" information
# Current Release Version: 1.0.0
# Script Owner: He ,Haibo
# Latest editor: He, Haibo
# Support platform:  Linux OS for Linux.
# Change log: None
# Description:Date 2022/3/7
#
#
###############################################################################################################
file_path="/tmp"
file_start="TCB Table Stats:"
file_end="TCB Index Information:"



get_db2pd_information(){
    for file in `ls $file_path/aaa_db2pd_tcbstats_$(date -d 'yesterday' +%Y%m%d)*.out | xargs`
    do
            file_start_num=`cat ${file} | grep -n "${file_start}" | cut -d ":" -f 1`
            file_end_num=`cat ${file} | grep -n "${file_end}" | cut -d ":" -f 1`
#            echo "file-start_num is ${file_start_num}"
#            echo "file_end_num is ${file_end_num}"
            file_start_num=$(($file_start_num-1))
            file_end_num=$(($file_end_num-1))
#            echo "file is ${file}"
#            echo "file-start_num is ${file_start_num}"
#            echo "file_end_num is ${file_end_num}"

            file_result="${file}.res"
#            echo "file_result is ${file_result}"
            for ((i=$file_start_num; i<=$file_end_num; i++))
            do
                sed -n "$i"p"" ${file} | awk -F ' ' {'print $3,$2,$4,$11,$12,$13'} >> ${file_result}
            done
    done 
}

main(){
    get_db2pd_information
}

main

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux