Execute QMirror/DB on a Windows command prompt and take command option 2 – ‘End current instance’. QMirror/DB x.x.x (released in 20xx/xx) command list (xxxx):1 – Start instance xxxx 2 – End instance xxxx 5 – Build up indexes from AS400 logical files K – Change license key L – Log monitoringS – Status monitoring Q – […]
(440) End QMirror/DB Read More »
(Note: The empty physical files on the AS400 will not be processed by the trial version.) Step 1. Execute QMirror/DB on a Windows command prompt Step 2. Take command option 2 to end the current instance if running Step 3. Take command option 4 to add tables from AS400 physical filesNo need to worry about
(450) Add more AS400 physical files into QMirror DB table list Read More »
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.ZAMTBFSET 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
(460) Remove tables from QMirror/DB table list Read More »
QMirror/DB provides a rapid yet low loading function for data verification between AS400 and the target database. The function first compares record counts between AS400 and the target database, then deletes the extra records and downloads the missing records. If you want to verify a specified AS400 table at once, set the verification flag TBVRFY
(470) Data verification between AS400 and the target database Read More »
Table status is kept in field TBDWFG, QMIRROR.ZAMTBF. A– Waiting for a full table download (the table will be dropped before downloading) B – Journal backlog processing D – To be removed G – Downloading H – Hooking resources I – Initiating for download Q – Running SQL QMIRROR.ZTBSQL statements R – Downloaded, ready to mirror X – Excluded from QMirror/DB Y – Waiting
(490) Learn QMirror/DB table status Read More »
Create sufficient indexes to get better query performance. The index creation could be defined in system table QMIRROR.ZTBSQL. Unique keys of physical file will be kept in field QMIRROR.ZAMTBF.TBUNIQ. QMirror/DB will insert a record into system table QMIRROR.ZTBSQL to build up index by pulling index keys off of the AS400 physical file with ZQSEQ=99998 after
(520) Create extra indexes in the target database Read More »
QMirror/DB uses system table QMIRROR.ZEXFLD to add extended fields in the replicated tables. Insert records into QMIRROR.ZEXFLD to define extended fields, and QMirror/DB will maintain these fields for you. Please refer to (A30) Extended fields master (ZEXFLD) for table structure and field comments. After maintaining QMIRROR.ZEXFLD, you need to re-download the files which you updated. Please refer
(530) Define extended fields in the target database Read More »
If you have some fields on AS400 files that are sensitive to share with users who are using the PC database, you can hide them up in the target database. For example, salary. It is approached by system table QMIRROR.ZHDFLD. Please refer to (A40) Hidden fields master (ZHDFLD) for table structure and field comments. Insert records into
(540) Define hidden fields in the target database Read More »
QMirror/DB supports replication from multiple AS400 servers to multiple PC database servers. You can use it to consolidate data from multiple AS400s for analytics or analysis. Or split data from a single AS400 to multiple PC databases for widely applications. Every configuration has a unique ID in QMirror/DB. The first configuration ID is named as
(550) Multiple AS400s / PC database servers configurations Read More »
Notice:1. QMirror/DB service must be installed after QMirror/DB. 2. QMirror/DB service must be installed on the same PC server which has QMirror/DB installed. 3. QMirror/DB service xxxx.ini will be reset when QMirror/DB instance xxxx starts up. Install QMirror DB as a Windows service 1. Download QMirror_DB_8xxs.zip from https://www.qmirror.com/download/ 2. Uninstall the earlier QMirror/DB Service from the Windows
(570) Install QMirror/DB as a Windows service Read More »
