#! /bin/sh


txsql -q "select nodename, poll_time from clu_poll" | \
awk -F '|' '
{
	nodename = $1
	poll_time = $2

	pHH = 0 + substr(poll_time,1,2)
	pMM = 0 + substr(poll_time,3,2)
	pMM = pMM + 30
	if ( pMM >= 60 ) {
		pMM -= 60
		++pHH
		if ( pHH >= 24 )
			pHH = 0
	}
	new_poll_time = sprintf("%02d%02d", pHH, pMM)
	print "nodename=[" nodename "]" "  poll_time=[" poll_time "]" "  new_poll_time=[" new_poll_time "]"
	sqlcmd = "update clu_poll set poll_time = \"" new_poll_time "\" where nodename = \"" nodename "\";"
	print "sqlcmd=[" sqlcmd "]"
	print sqlcmd | "runisql"
}
'