::Batch file to check new error
@echo off
db2 connect to my_db
if errorlevel 1 goto no_connect

::-----------------Note down the current count
db2 -x select count(*) from exception_log >current_count.txt
if errorlevel 1 goto error_occured
set /p current_count=<current_count.txt


::-----------keep looping till new error

:loop_on

db2 -x select count(*) from exception_log >current_count.txt
if errorlevel 1 goto error_occured
set /p new_count=<current_count.txt

if  not "%current_count%" == "%new_count%" goto count_changed

::---------------------delay 1 minute
ping 127.1 -n 60 >nul
::---------------------keep looping
goto loop_on

::=====================================================



:count_changed

::---------------------take appropriate action here ; e.g. turn trace off



::--------------------TERMINATE --- exit /b
db2 -v connect reset 
exit /b
::-------------------OR--- jump back to loop :- loop_on 
goto loop_on



:error_occured

::----------------------- if here , it indicates the error ; handle it 
::------------------------and jump into loop or exit
echo. Error - %errorlevel%
::----------------------clear the error
type nul
::----------------------take action here




::--------------------TERMINATE --- exit /b
db2 -v connect reset 
exit /b
::-------------------OR--- jump back to loop :- loop_on 
goto loop_on

:no_connect

echo.
echo.              Could not connect to db2 - exiting . . . 

exit /b

::---------------------Complete