(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

Table of Contents
Scroll to Top