Commandserver Status und Aliase

Linux Script zum Auslesen des Commandserver Status:

export INSTALLDIR=/opt/novastor/DataCenter
#
(echo connect \'jdbc:derby://localhost:1527/dc5\;user=dc5\;password=dc5\'\;
echo select count\(\*\) from active_job\;
echo select count\(\*\) from active_exec_plans\;
echo select count\(\*\) from executing_task_item\;
echo exit\;) > /tmp/sql.in
#
i=1
for port in 1527 32333 32334 32335 ; do
   tmp=$(netstat -anp | grep $port | grep LISTEN | awk '{print $7}')
   pid=$(echo $tmp | sed -e 's+/.*++')
   nam=$(echo $tmp | sed -e 's+.*/++')
   [ $i -eq 1 ] && nam="Derby DB"
   [ $i -eq 2 ] && nam="Open EJB"
   i=$((i+1))
   cnt=$(netstat -anp | grep $port | grep -v LISTEN | wc -l)
   cth=$(cat /proc/$pid/status | grep Threads | awk -F: '{print $2}')
   cvm=$(cat /proc/$pid/status | grep VmRSS   | awk -F: '{print $2}')
   echo "$cnt/$cth/$cvm ----------- $nam Connections/Threads/VmRSS"
done
#
echo "----------- active_job active_exec_plans executing_task_item"
export DERBY_HOME=$INSTALLDIR/db-derby
export JAVA_HOME=$INSTALLDIR/jre
$DERBY_HOME/bin/tools/ij < /tmp/sql.in | grep -v selected | grep -v '^$' | grep -v ij | grep -v -- "-----"
#
exit 0

Nützliche Aliase:

alias dbd='systemctl stop derby.service; systemctl start derby.service'

alias ejb='systemctl stop openejb.service; systemctl start openejb.service'

alias rcd='systemctl stop rcmd-dispatcher.service; systemctl start rcmd-dispatcher.service'

alias rce='systemctl stop rcmd-executor.service; systemctl start rcmd-executor.service'

alias sdc='/opt/novastor/DataCenter/db-derby/bin/tools/sql_show_dc5_activity.sh'