Knowledge Base

Since QMirror/DB demands tiny system resources, we recommend you to install it on the same PC server with database server. For remote download/replication processing, place QMirror/DB server at the AS400 site is better than at the PC databases site. 1. Download QMirror_DB_8xx.zip from https://www.qmirror.com/download/ 2. Uninstall QMirror/DB’s earlier version from Windows program menu list 3. Unzip, execute QMirror_DB_8xx.exe,

1. Prepare data for configuration https://www.qmirror.com/qmirror-download/QMirrorDB_Configuration_Data_Sheet.txt 2. Start configuration by c:\QMirrorDB\qmirror.bat 3. Accept the terms of the license agreement Do you accept the terms of the license agreement? (y/N/q) y 4. AS400 IP Address or Hostname 5. AS400 User ID 6. QMirror Working Library (default is ‘QMIRROR’) p.s. QMirror saves work files in working library

(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

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

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

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,

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. Stop QMirror/DB Windows Services QMIrrorXXXX and QGuardXXXX Step 3. Uninstall QMirror/DB from Windows server by c:\QMirrorDB\uninstall.exe Step 4. Uninstall QMirror/DB service by c:\QMirrorDBService\uninstall.exe Step

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