(Note: The empty physical files on the AS400 will not be processed by the trial version.) To build up table list from AS400 physical files, take command option 4 to enter AS400 library name and physical file name. Buildup table list from AS400 physical files – Enter AS400 library name: libr1 Enter AS400 physical file […]
(340) Build up table list from AS400 physical files Read More »
If you have logical files on the AS400 and want to build up indexes on the target PC database from these logical files, take command option 5. QMirror/DB takes the index keys out of the AS400 logical fields and inserts them into system table QMIRROR.ZTBSQL to build up indexes. Only the tables in the system
(350) Build up indexes from AS400 logical files Read More »
You can install QMirror/DB on Linux with WINE installed. WINE is a compatibility layer capable of running Windows applications on Linux. Please refer to https://www.winehq.org/ for more details. To enable the QMirror dashboard, you need to install an HTTP server on Linux. Some hints here to set up Apache server. <VirtualHost *:80> ServerAdmin admin@qmirrordb ServerName qmirrordb ServerAlias
(310) Install QMirror/DB on Linux Read More »
QMirror/DB uses AS400 journal to do data replication. You can let QMirror/DB setup AS400 journaling for you. When you run QMirror/DB command option 8 – ‘Start / End AS400 journaling’, QMirror/DB will keep message queue (MSGQ), journal receivers (JRNRCV) and journal (JRN) into library ‘QMIRROR’. If command option 8 is not shown on the menu,
(360) Start / End AS400 journaling by QMirror/DB Read More »
Upgrade QMirror/DB is easy. All existing data on the target PC database are safe. No re-configuration is needed. Step 1. Stop QMirror/DB by taking Ctrl-C or command option 2 Step 2. Uninstall QMirror/DB from Windows server by c:\QMirrorDB\uninstall.exe Step 3. Uninstall QMirror/DB service by c:\QMirrorDBService\uninstall.exe Step 4. Download the latest version of QMirror/DB from www.qmirror.com/download
(380) Upgrade QMirror/DB Read More »
Step 1. Run QMirror/DB command option 8 – ‘Start / End AS400 journaling’ to end AS400 journaling which was started by QMirror/DB. Step 2. Delete AS400 library ‘QMIRROR’ which was created by QMirror/DB. Step 3. Clean QMirror/DB system database and library databases on the PC database server. Step 4. Uninstall QMirror/DB from the Windows program menu list
(390) Uninstall QMirror/DB Read More »
Start QMirror/DB instance ROOT by c:\QMirrorDB\run_qmirror.bat or start QMirror DB other instances by c:\QMirrorDB\run_qmirror_xxxx.bat on a Windows command prompt. To execute a QMirror/DB instance, take command option 1 – ‘Start instance xxxx’. QMirror/DB x.x.x (released in 20xx/xx) command list (xxxx): 1 – Start instance xxxx 3 – Re-configuration4 – Build up table list from AS400 physical files 5 –
(400) Normal running QMirror/DB Read More »
The current states of QMirror/DB are kept in the system table QMIRROR.ZJBSTS. Please refer to (A50) Job log file (ZJBLOG) / Job status file (ZJBSTS) for table structure and field comments. Administrator may monitor the running log and status of QMirror/DB on any PC at any location with the following three methods. Method 1 – Use a
(410) Get QMirror/DB running log and status Read More »
There are four kinds of status logs kept in system table QMIRROR.ZJBLOG. Please refer to (A50) Job log file (ZJBLOG) / Job status file (ZJBSTS) for table structure and field comments. 1. Delay status log2. Download status log3. SQL status log4. Recovery status log When you set configuration, you can choose to keep or omit these logs.
(420) Get QMirror/DB status log Read More »
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
(430) Re-download specified AS400 tables manually Read More »
