Command server status and aliases

Command server status and aliases

This guide is only applicable to DataCenter version 7.

NovaBACKUP DataCenter

Script for reading the command server 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 LISTS | 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

Useful aliases:
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'