(430) Re-download specified AS400 tables manually

You can re-download non-journaled or omit journaled physical files manually. Please refer to (370) Download journaled physical files without replication.

To re-download specified AS400 physical files manually, you can change the download flag TBDWFG to ‘A‘ in system table QMIRROR.ZAMTBF for full table download. Or change TBDWFG to ‘Y‘ for ‘Selected Download.’ Please refer to (580) Selected Download if needed.

Download immediately

E.g. UPDATE QMIRROR.ZAMTBF
SET TBDWFG=’A’, TBNDDT=0, TBNDTM=0, TBSTS=’ ‘
WHERE TBLIB=’LIBR1′ AND TBOBJ=’FILEA’ AND TBMBR=’FILEA’

Download on a specified date

E.g. UPDATE QMIRROR.ZAMTBF
SET TBDWFG=’A’, TBNDDT=20101231, TBNDTM=135959
WHERE TBLIB=’LIBR1′ AND TBOBJ=’FILEB’ AND TBMBR=’FILEB’

Download scheduling

Use scheduling code TBDSCH and next download time TBNDTM to setup download scheduling. QMirror/DB will do a ‘Selected Download’ if it was specified.
Reboot QMirror/DB instance is needed after you changed download schedule.

Daily – Set TBDSCH to 9999

E.g. UPDATE QMIRROR.ZAMTBF SET TBREPL=’N’, TBDSCH=9999, TBNDTM=001000
WHERE TBLIB=’LIBR1′ AND TBOBJ=’FILEC’ AND TBMBR=’FILEC’

Weekly– Set TBDSCH from 9990 to 9996, 9990 means Sunday

E.g. UPDATE QMIRROR.ZAMTBF SET TBREPL=’N’, TBDSCH=9990, TBNDTM=001000
WHERE TBLIB=’LIBR1′ AND TBOBJ=’FILED’ AND TBMBR=’FILED’

Monthly– Set TBDSCH from 9901 to 9931, 9901 means 1st of month

E.g. UPDATE QMIRROR.ZAMTBF SET TBREPL=’N’, TBDSCH=9901, TBNDTM=001000
WHERE TBLIB=’LIBR1′ AND TBOBJ=’FILEE’ AND TBMBR=’FILEE’

Yearly– Set TBDSCH from 0101 to 1231, 0101 means January 1st

E.g. UPDATE QMIRROR.ZAMTBF SET TBREPL=’N’, TBDSCH=0101, TBNDTM=001000
WHERE TBLIB=’LIBR1′ AND TBOBJ=’FILEF’ AND TBMBR=’FILEF’

Previous (420) Get QMirror/DB status log
Next (440) Normal ending QMirror/DB