$ ./z2.ksh
- timestamp = 15-DEC-2016 10:19:24
  TS2 = 2016-12-15 10:19:24
- connectstring =  (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=testuser))(SERVER=DEDICATED)(SERVICE_NAME=test_app.x.y.z))
  program = JDBC Thin Client
  user = testuser
  service_name = test_app.x.y.z
- host =  (ADDRESS=(PROTOCOL=tcp)(HOST=60.11.22.123)(PORT=55440))
  app_protocol = tcp
  app_host = 60.11.22.123
  app_port = 55440
- result =  establish
- service =  test_app.x.y.z
- returncode =  12666
-------------------------------------------------------------

$ cat z2.ksh
#!/bin/ksh

#15-DEC-2016 10:19:24 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=testuser))(SERVER=DEDICATED)(SERVICE_NAME=test_app.x.y.z)) * (ADDRESS=(PROTOCOL=tcp)(HOST=60.11.22.123)(PORT=55440)) * establish * test_app.x.y.z * 12666

#LOG=y.out
LOG=x.out

while IFS="*" read TS CS HOST RESULT SERVICE RETURNCODE
do
   timestamp=`echo $TS | awk '{ print $2 }'`
   year=`echo $TS | awk '{ print $1 }' | awk -F"-" '{ print $3 }'`
   day=`echo $TS | awk '{ print $1 }' | awk -F"-" '{ print $1 }'`
   month=`echo $TS | awk '{ print $1 }' | awk -F"-" '{ print $2 }'`

   case $month in
      "JAN" ) mm="01" ;;
      "FEB" ) mm="02" ;;
      "MAR" ) mm="03" ;;
      "APR" ) mm="04" ;;
      "MAY" ) mm="05" ;;
      "JUN" ) mm="06" ;;
      "JUL" ) mm="07" ;;
      "AUG" ) mm="08" ;;
      "SEP" ) mm="09" ;;
      "OCT" ) mm="10" ;;
      "NOV" ) mm="11" ;;
      "DEC" ) mm="12" ;;
   esac
   TS2="$year-$mm-$day $timestamp"

   program=`echo $CS | awk -F"(" '{ print $4 }' | awk -F"=" '{ print $2 }' | awk -F")" '{ print $1}'`
   user=`echo $CS | awk -F"(" '{ print $6 }' | awk -F"=" '{ print $2 }' | awk -F")" '{ print $1}'`
   service_name=`echo $CS | awk -F"(" '{ print $8 }' | awk -F"=" '{ print $2 }' | awk -F")" '{ print $1}'`

   app_protocol=`echo $HOST | awk -F"(" '{ print $3 }' | awk -F"=" '{ print $2 }' | awk -F")" '{ print $1}'`
   app_host=`echo $HOST | awk -F"(" '{ print $4 }' | awk -F"=" '{ print $2 }' | awk -F")" '{ print $1}'`
   app_port=`echo $HOST | awk -F"(" '{ print $5 }' | awk -F"=" '{ print $2 }' | awk -F")" '{ print $1}'`

   echo "- timestamp = $TS"
   echo "  TS2 = $TS2"
   echo "- connectstring = $CS"
   echo "  program = $program"
   echo "  user = $user"
   echo "  service_name = $service_name"
   echo "- host = $HOST"
   echo "  app_protocol = $app_protocol"
   echo "  app_host = $app_host"
   echo "  app_port = $app_port"
   echo "- result = $RESULT"
   echo "- service = $SERVICE"
   echo "- returncode = $RETURNCODE"
   echo "-------------------------------------------------------------"
   echo
done <  $LOG

###########
# THE END #
###########

$