(410) Get QMirror/DB running log and status

The current states of QMirror/DB are kept in the system table QMIRROR.ZJBSTS. Please refer to (A50) Job log file (ZJBLOG) / Job status file (ZJBSTS) for table structure and field comments.

Administrator may monitor the running log and status of QMirror/DB on any PC at any location with the following three methods.

Method 1 – Use a web browser to monitor QMirror/DB status

Opening ‘QMirror Dashboard’ from the Windows program menu list, you will get a display similar to the one below.

Steps to setup QMirror Dashboard

1. Turn on Internet Information Services (IIS) on Windows

2. Open Internet Information Services (IIS) Manager

3. Remove Sites ‘Default Web Site’

4. Add Sites ‘QMirror’

4.1 Site Name – ‘QMirror’ 4.2 Physical Path – ‘C:\QMirrorDB’ 4.3 Binding Type – http 4.4 Binding IP Address – All Unassigned 4.5 Binding Port – 80

5. For PCs in the intranet – open browser by http://IP address/dashboard.html

6. If the web server port 80 is blocked, open Windows firewall for HTTP

http://www.supergeotek.com/ SGS10.0_ENG_HTML /firewallsetup.htm

7. Input configuration ID

7. Double click navigators to enlarge a particular chart

8. Double click the chart to return to the navigators

9. Click the configuration ID at upper-right corner to show the status report

Steps to setup SSL QMirror Dashboard

1. Open Internet Information Services (IIS) Manager

2. Remove Sites ‘Default Web Site’

3. Create personal Self-Signed Certificate ‘QMirror’

4. Add Website ‘QMirror_https’

4.1 Site Name – ‘QMirror_https’ 4.2 Physical Path – ‘C:\QMirrorDB’ 4.3 Binding Type – https 4.4 Binding IP Address – All Unassigned 4.5 Binding Port – 443 4.6 Select SSL certificate – QMirror

5. For PCs in the intranet – by https://IP address/dashboard.html

6. If the web server port 443 is blocked, open Windows firewall for HTTPS

http://www.supergeotek.com/SGS10.0_ENG_HTML/firewallsetup.htm

7. Input configuration ID

8. Double click navigators to enlarge a particular chart

9. Double click the chart to return to the navigators

10. Click the configuration ID at upper-right corner to show status report

Method 2 – Monitor QMirror by QMirror/DB command (not recommended)

1. To monitor QMirror/DB running log and status, the operators need to have the ‘SELECT’ privilege on the following tables:

QMIRROR.ZSERVR
xxxx_QMIRROR.ZAMTBF
xxxx_QMIRROR.JBSTS
xxxx_QMIRROR.ZPCLOG2

‘xxxx_’ is the configuration ID for Multiple AS400s / PC databases configurations.

2. Execute QMirror/DB on a Windows command prompt. Take command option L – ‘Log Monitoring’.

3. Execute QMirror/DB on a Windows command prompt. Take command option S – ‘Status Monitoring’.

4. The monitor displays are refreshed every five seconds. For security reason, the only way to stop a monitoring display is to use Ctrl-C.

Method 3 – Review QMirror status by database SQL queries (not recommended)

1. Open PC database SQL studio

2. Login as database administrator

3. Execute SQL statement

E.g. SELECT ZJTYPE, ZJJBID, ZJRPTM, ZJACTN, ZJLIB,
ZJOBJ, ZJTIME, ZJRCDS, ZJRMRK
FROM QMIRROR.ZJBSTS
ORDER BY ZJTYPE, ZJJBID

4. Action description:

CUTOFF – Cutoff date / time of data replication, memory used
CURRENT DELAY – Current delay by seconds, time period
AVERAGE DELAY – Average delay by seconds, time period
MINIMUM DELAY – Minimum delay by seconds, time point
MAXIMUM DELAY – Maximum delay by seconds, time point

Previous (400) Normal running QMirror/DB
Next (420) Get QMirror/DB status log