Changes between Version 1 and Version 2 of jmdDebug

Timestamp:

02/24/15 13:50:26 (10 years ago)

Author:

joe

Comment:

--

jmdDebug

@@ -4 +4 @@
 
 **note** : Joe H. wrote up some notes a while back re: the queues / sum service, etc.
+
+== Useful Aliases ==
+
+I use these (note, bash shell) aliases to help with debugging things.  You may need to adjust some of the variables to match your system.  (see the NetDRMS file 'config.local')
+
+{{{
+export PROMPT_COMMAND='echo -ne "\033]0;${USER}@${HOSTNAME%%.*}"; echo -ne "\007"'
+
+export JSOC_ROOT=/opt/netdrms/
+export JSOC_DBHOST=sdo4localhost
+export JSOC_DBNAME=sdac_drms
+export JSOC_DBUSER=[CENSORED]
+
+export DRMS=$JSOC_ROOT
+export SUMSSERVER=sdo4localhost
+export PATH=$PATH:/home/sums/bin:/home/sums/scripts
+
+alias drms="psql -U $JSOC_DBUSER -d $JSOC_DBNAME"
+alias sums="psql -U $JSOC_DBUSER -d ${JSOC_DBNAME}_sums -p 5434"
+# alias jetty='sudo /opt/jetty/bin/jetty.sh'
+# alias apachectl='sudo /usr/sbin/apachectl'
+
+export DERBY_HOME=/opt/derby
+# alias ij=/opt/derby/bin/ij
+alias ij=/opt/JMD/bin/jmdij
+alias jmd='sudo /opt/JMD/bin/JMD.sh'
+
+alias sumtail='tail -f `ls -1t /usr/local/logs/SUM//sum_svc*| head -1`'
+alias drmsq='drms -c "select count(*) from sunum_queue"'
+alias drmsq2='drms -c "select count(*), series_name from sunum_queue group by series_name"'
+export IJCMD='/usr/bin/java -classpath '`ls -1t /opt/JMD/jar/*.jar | head -1`' -Dij.connection.jmdDB=jdbc:derby://localhost:31001//opt/derby/derbyDB
+org.apache.derby.tools.ij'
+
+alias jmdq='echo "select count(*) as count, request_type as type, substr(series_name,1,20) as series from drms.su_cache group by request_type, series_name" | '$IJCMD;
+alias jmdq2='echo "select count(*) as count, state, request_type as type, substr(series_name,1,20) as series from drms.su_cache group by state,request_type, series_name" | '$IJCMD;
+alias jmdstale='echo "select count(*),substr(series_name,1,20),request_type, min(elapse_Time), max(elapse_time) from drms.su_cache where elapse_time > 1200 group by series_name, request_type" | '$IJCMD;
+alias jmdspeed='tail -n 2000 `ls -1t /opt/JMD/log/*stderr* | head -1` | grep DONE | cut -d: -f1-2 | uniq -c'
+alias jmdspeedxl='grep DONE `ls -1t /opt/JMD/log/*stderr* | head -1` | tail -n 2000 | cut -d: -f1-2 | uniq -c'
+alias jmdspeed2='grep DONE `ls -1tr /opt/JMD/log/*stderr*  | tail -3`  | cut -d: -f2 | uniq -c'
+alias jmdtail='tail -f `ls -1t /opt/JMD/log/*stderr* | head -1`'
+alias jmdcat='cat `ls -1t /opt/JMD/log/*stderr* | head -1`'
+}}}
+
 
 == Restarting the JMD ==