51 lines
1.2 KiB
Bash
Executable File
51 lines
1.2 KiB
Bash
Executable File
#!/bin/bash
|
|
#
|
|
#$1 = testDB
|
|
#$2 = start hour
|
|
#
|
|
if [ $# -ne 2 ]; then
|
|
echo Syntax: dwControlNightly.sh testDB startHour
|
|
echo Exiting.....
|
|
exit 1
|
|
fi
|
|
#
|
|
testDB=$1
|
|
startHour=$2
|
|
#
|
|
keepGoing=1
|
|
nightlyDone=0
|
|
while [ $keepGoing -eq 1 ]; do
|
|
vTime=$(date "+%H:%M:%S %x")
|
|
vHour=${vTime:0:2}
|
|
if [ $vHour -eq $startHour ]; then
|
|
if [ $nightlyDone -eq 0 ]; then
|
|
dirName=nightly
|
|
mkdir -p $dirName
|
|
cd $dirName
|
|
#
|
|
# group to run nightly stats, pre-DML
|
|
$MYRHOME/performance/groupTest/test/pfSubmitGroupTest.sh 204 $testDB 1 1 S 0 M
|
|
# rm -rf *
|
|
# group to delete and update lineitem rows
|
|
$MYRHOME/performance/groupTest/test/pfSubmitGroupTest.sh 203 $testDB 1 1 S 0 M
|
|
# rm -rf *
|
|
# group to run nightly stats, post-DML
|
|
$MYRHOME/performance/groupTest/test/pfSubmitGroupTest.sh 204 $testDB 1 1 S 0 M
|
|
# rm -rf *
|
|
#
|
|
# backup database
|
|
# /home/qa/srv/autopilot/stability/dwweek/test/dwBackup.sh
|
|
# /home/qa/srv/autopilot/stability/dwweek/test/dwDropPartitions.sh $testDB
|
|
cd ..
|
|
nightlyDone=1
|
|
fi
|
|
else
|
|
nightlyDone=0
|
|
fi
|
|
sleep 60
|
|
if [ -f continue.txt ]; then
|
|
keepGoing=`cat continue.txt`
|
|
fi
|
|
done
|
|
#
|