Changes between Version 2 and Version 3 of jmdDebug

Timestamp:

03/06/15 08:47:28 (11 years ago)

Author:

joe

Comment:

--

jmdDebug

@@ -27 +27 @@
 
 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'
@@ -34 +33 @@
 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 jmdq='echo "select count(*) as count, request_type as type, substr(series_name,1,20) as series from drms.su_cache where state <> '"'DONE'"' group by request_type, series_name" |
+'`ijcmd`;
+alias jmdq0='echo "select count(*) from drms.su_cache where state <> '"'DONE'"'" | '`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 jmdstale='echo "select count(*) as count,substr(series_name,1,20) as series,request_type as type, min(elapse_Time) as min_time, max(elapse_time) as max_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'
@@ -45 +46 @@
 alias jmdtail='tail -f `ls -1t /opt/JMD/log/*stderr* | head -1`'
 alias jmdcat='cat `ls -1t /opt/JMD/log/*stderr* | head -1`'
+# alias jmdofln='echo "select su_cache.sunum, sum62.sunum from drms.su_cache as su_cache left join sum62 on su_cache.sunum = sum62.sunum where state='"'OFLN'"'; " | `ijcmd`'
+}}}
+
+And what they all do:
+
+{{{
+drms : connect to the DRMS database using psql (command line postgres client)
+sums : connect to the SUMS  database using psql (command line postgres client)
+ij : connect to the JMD database using ij (command line derby client)
+
+jmd : script to start/stop the JMD service.  (call using `jmd start` or `jmd stop`)
+
+sumtail : tail -f the most recent sums log
+jmdtail : tail -f the most recent jmd log
+jmdcat : cat the most recent jmd log
+
+drmsq : report the number of items in the DRMS sunum_queue table
+drmsq2 : report the number of items per series in the DRMS sunum_queue table
+
+jmdq : report the number of items per series in the JMD drms.su_cache table that are not marked 'DONE'.
+jmdq0 : report the number of items (a single number) in the JMD drms.su_cache table that are not marked 'DONE'.
+jmdq2 : report the number of items in the JMD drms.su_cache table, broken down by series & processing state.
+
+jmdspeed : a count of how many SCPs per minute have recently completed
+jmdspeedxl : a count of how many SCPs per minute have completed (looks further back through the JMD logs)
+jmdspeed2 : a count of how many SCPs per hour have completed over the last day or so.
+
+jmdstale : report on things in the JMD drms.su_cache table that have elapsed times of more than 20 min.
+jmdofln : (note, requires populating a 'sum62' table) : report on which items marked as 'ofln' were on the JSOC /SUM62 partition
 }}}
 
 
 == Restarting the JMD ==
+
+In your JMD directory, there should be a `bin/JMD.sh`.  It behaves like an rc script, so call it as root with either 'start' or 'stop' as an argument.  See the above 'jmd' alias which calls it using sudo, so you can do `jmd stop; jmd start`.