(490) Learn QMirror/DB table status

Table status is kept in field TBDWFG, QMIRROR.ZAMTBF.

A– Waiting for a full table download (the table will be dropped before downloading)

B – Journal backlog processing

D – To be removed

G – Downloading

H – Hooking resources

I – Initiating for download

Q – Running SQL QMIRROR.ZTBSQL statements

R – Downloaded, ready to mirror

X – Excluded from QMirror/DB

Y – Waiting for a full table download or ‘Selected Download’ if specified (the table will be cleared before downloading)

Z – Downloaded and start mirroring, ready to use

For example:

1. To know which tables are not yet ready for use

SELECT * FROM QMIRROR.ZAMTBF WHERE TBDWFG<>Z’ AND TBDWFG<>’X’

2. To know which tables are excluded from QMirror/DB

SELECT * FROM QMIRROR.ZAMTBF WHERE TBDWFG=’X’

Tags: