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.ZAMTBFWHERE TBDWFG<>’Z’ AND TBDWFG<>’X’ 2. To know which tables are excluded from QMirror/BK SELECT * FROM QMIRROR.ZAMTBF WHERE […]
(460) Learn QMirror/BK object transfer status Read More »
Use command option R to switch to recovery mode. Then restart QMirror/BK and use command option 9 to start recovery. When do recovery, the triggers will be disabled on AS400. After recovery, the trigger will be enabled again on the AS400. Go to (500) Prepare batch programs to execute QMirror/BK
(470) Recovery mode Read More »
A faster way to execute QMirror/BK is to use batch programs. A batch program named ‘run_qmirror_qmbk.bat’ was created in the QMirror/BK directory. Follow the instruction in ‘run_qmirror_qmbk.bat’ to preset all the parameters needed by QMirror/BK. You can get all the encrypted data from QMirror/BK console displayed under the interactive mode. Notes: QMirror/BK keeps the last
(500) Prepare batch programs to execute QMirror/BK Read More »
To install QMirror/BK as a Windows service: 1. Download QMirror_BK_1xxs.zip from https://www.qmirror.com/download/ 2. Uninstall the earlier QMirror/BK service from the Windows program menu list 3. Unzip, execute QMirror_BK_1xxs.exe, and follow the instructions 4. A program menu ‘QMirror BK Service’ will be created on Windows 5. Edit the preset parameters as needed in c:QMirrorBKServiceQMBK.ini Notes: QMirror/BK service keeps the last
(510) Install QMirror/BK as a Windows service Read More »
Use command option U to clear and delete working library on AS400. QMirror/BK x.x.x (released in 20xx/xx) command list (QMBK): 1 – Start QMirror/BK 3 – Remove libraries from library list 4 – Build up object list from AS400 libraries 6 – Show selected library list 7 – Show excluded object list 8 – ENDJRNPF
(520) Uninstall QMirror/BK Read More »
1. To create an AS400 user profile ‘QMIRROR’ on AS400,enter command: CRTUSRPRF USRPRF(QMIRROR) PASSWORD(xxxxxxxx) USRCLS(*USER) SPCAUT(*ALLOBJ *JOBCTL *IOSYSCFG *SAVSYS *SECADM) PWDEXPITV(*NOMAX) 2. Or use any existing user profile which owns SPCAUT(*ALLOBJ *JOBCTL *IOSYSCFG *SAVSYS *SECADM) authority 3. The user profile has to have the authority to execute the following commands: ALCOBJ, CHGJOB, CHGJRN, CHGPF, CHGPFM,
(100) Create AS400 user profiles for QMirror/BK Read More »
Install QMirror DR 1. Create AS400 user profiles for QMirror DR 2. Install QMirror DR 3. Configure QMirror DR 4. Simulation Test Execute QMirror DR 1. Build up library list from source AS400 libraries (command option 4)(to start journaling for physical files) 2. Save libraries from source AS400 and restore to target AS400 by tape(saving time to transfer large objects by
1. To create an AS400 user profile ‘QMIRROR’ on both source and target AS400s,enter command: CRTUSRPRF USRPRF(QMIRROR) PASSWORD(xxxxxxxx) USRCLS(*USER) SPCAUT(*ALLOBJ *JOBCTL *IOSYSCFG *SAVSYS *SECADM) PWDEXPITV(*NOMAX) 2. Or use any existing user profile which owns SPCAUT(*ALLOBJ *JOBCTL *IOSYSCFG *SAVSYS *SECADM) authority 3. Both source and target AS400s user profile must have same name password 4. The user
(100) Create AS400 user profiles for QMirror/DR Read More »
Normally, QMirror/DR should run well under common AS400 configuration. If you have a slow replication speed, you will need to check or tune your AS400 configuration. Please refer to the following paragraphs to check with your AS400 configuration. Watch the QMirror/DR performance status and tune accordingly. 1. Use command STRTCPSVR to start FTP server and DDM server.
(110) Check AS400 configuration Read More »
1. Download QMirror_DR_1xx.zip from https://www.qmirror.com 2. Uninstall QMirror/DR’s earlier version from Windows program menu list 3. Unzip, execute QMirror_DR_1xx.exe, and follow the instructions 4. A program menu ‘QMirror DR’ will be created on Windows 5. Execute QMirror/DR from program menu list 6. Or execute QMirror/DR on a DOS prompt E.g. c:\QMirrorDR\qmirror.bat Check QMirror/DR directory properties
(200) Install QMirror/DR Read More »
