(460) Learn QMirror/BK object transfer status

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

A -Wait to transfer

G -Transferring

R – Transferred, ready to replicate

X -Excluded from QMirror/BK

Z – Transferred and replicating

For example:

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/BK

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

Refer to (220) About QMirror/BK internal SQLite database

Go to (470) Recovery Mode