(460) Learn QMirror/DR object transfer status
Object status is kept in field TBDWFG, QMIRROR.ZAMTBF.
A -Wait to transfer
G -Transferring
R – Transferred, ready to replicate
X -ExcludedfromQMirror/DR
Z – Transferred and replicating
For examples:
1. To know which object is not ready
SELECT * FROM QMIRROR.ZAMTBF
WHERE TBDWFG<>’Z’ AND TBDWFG<>’X’
2. To know which tables are excluded from QMirror/DR
SELECT * FROM QMIRROR.ZAMTBF WHERE TBDWFG=’X’