(420) Get QMirror/DB status log

There are four kinds of status logs kept in system table QMIRROR.ZJBLOG. Please refer to (A50) Job log file (ZJBLOG) / Job status file (ZJBSTS) for table structure and field comments.

1. Delay status log
2. Download status log
3. SQL status log
4. Recovery status log

When you set configuration, you can choose to keep or omit these logs. Through QMIRROR.ZJBLOG, you can do tracking or other things that you want to do.

For example, use following SQL to get mirror status per day:

SELECT ZJRPDT AS AS400_DATE,
SUM(ZJRCDS) AS TOTAL_RCDS,
MAX(ZJTIME) AS MAX_DELAY,
AVG(ZJTIME) AS AVG_DELAY,
COUNT(*) AS CYCLES,
AVG(ZJRCDS) AS AVG_RCDS
FROM QMIRROR.ZJBLOG
WHERE ZJTYPE=’ ‘ AND ZJRCDS>0 AND ZJBSTS=’ ‘
GROUP BY ZJRPDT

QMirror/DB purges its own log tables at the end of each month. Entries in log tables QMIRROR.ZPCLOG, QMIRROR.ZJBLOG, and QMIRROR.ZJMLOG, that are created earlier than the first date of the last month will be purged.

Previous (410) Get QMirror/DB running log and status
Next (430) Re-download specified AS400 physical files manually