######################################################################
# DB2CJTrace-Start.sh
######################################################################
clear
echo "Start DB2 CLI+JDBC Trace ..........."
echo "- enter path to trace file: (e.g. /db2inst1/db2/db2diag/$DB2INSTANCE)"
read tfp
datestr=`date +%Y-%m-%d-%H.%M.%S`
CLIFile=$tfp/CLI-Trace-$datestr.txt
JDBCFile=$tfp/JDBC-Trace-$datestr.txt
echo "* CLI Trace File : $CLIFile"
echo "* JDBC Trace File: $JDBCFile"
#
db2 UPDATE CLI CFG FOR SECTION COMMON USING TracePathName NULL
db2 UPDATE CLI CFG FOR SECTION COMMON USING TraceFileName $CLIFile
db2 UPDATE CLI CFG FOR SECTION COMMON USING TraceComm 1
db2 UPDATE CLI CFG FOR SECTION COMMON USING TraceFlush 1
db2 UPDATE CLI CFG FOR SECTION COMMON USING TraceTimeStamp 3
db2 UPDATE CLI CFG FOR SECTION COMMON USING TraceFlushOnError 1
db2 UPDATE CLI CFG FOR SECTION COMMON USING Trace 1
#
db2 UPDATE CLI CFG FOR SECTION COMMON USING JDBCTracePathName NULL
db2 UPDATE CLI CFG FOR SECTION COMMON USING JDBCTraceFileName $JDBCFile
db2 UPDATE CLI CFG FOR SECTION COMMON USING JDBCTraceFlush 1
db2 UPDATE CLI CFG FOR SECTION COMMON USING JDBCTrace 1
echo "DB2 CLI+JDBC Trace activated:"
db2 get cli cfg

######################################################################
# DB2CJTrace-Stop.sh
######################################################################
clear
echo "Stop DB2 CLI+JDBC Trace ..........."
db2 UPDATE CLI CFG FOR SECTION COMMON USING Trace 0
db2 UPDATE CLI CFG FOR SECTION COMMON USING JDBCTrace 0
echo "DB2 CLI+JDBC Trace stopped:"
db2 get cli cfg