#!/bin/bash

nodeNr=1
group=$1
testName="DB"
testSummary="sap hostagent reports status of the DB"

source ../get_test_values --group=$group

function test()
{
    local system=$1
    timeout 30 ssh -T root@$system <<EOF
       /usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseStatus -dbname $mySID  -dbtype $dbTYPE >/dev/null 1>&2;
EOF
    return $?
}


for system in $allSystems; do
    test $dbIP; rc=$?
    logger -t $LandscapeUseCase -s "Test $testName for $group on node $system rc:  $rc"
    case $rc in 
        124 | 255 ) # test timeout - set N/A
             rm -f $STATUS_BASE_DIR/.status/${group}_${testName}_OK
             rm -f $STATUS_BASE_DIR/.status/${group}_${testName}_FAIL
             res="NA";
             ;;
        0 )
             touch $STATUS_BASE_DIR/.status/${group}_${testName}_OK
             rm -f $STATUS_BASE_DIR/.status/${group}_${testName}_FAIL
             break
             ;;
        1 )  rm -f $STATUS_BASE_DIR/.status/${group}_${testName}_OK
             touch $STATUS_BASE_DIR/.status/${group}_${testName}_FAIL
             ;;
    esac
done
