How Can We Help?
(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’
Previous (480) Large object (LOB) processing
Next (510) Grant target database privileges to users