(460) Remove tables from QMirror/DB table list

If you want to remove a specified table from QMirror/DB table list, you can change download flag TBDWFG to ‘D’ in system table QMIRROR.ZAMTBF.

E.g. UPDATE QMIRROR.ZAMTBF
SET TBDWFG=’D’
WHERE TBLIB=’LIBR1′ AND TBOBJ=’FILEA’ AND TBMBR=’FILEA’

QMirror/DB will drop the tables which TBDWFG is ‘D’; end journaling and delete the record in ZAMTBF.

Previous (450) Add more AS400 physical files into QMirror DB table list
Next (470) Data verification between AS400 and the target database