(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’

Go to (220) About QMirror DR internal SQLite database

Table of Contents
Scroll to Top