Field Name Key Data Type Description ZVERNO CHAR(10) QMirror/DB version number ZSVRID CHAR(4) Configuration IDROOT – Primary configurationRefer to (550) Multiple AS400s / PCs configurations ZPTYPE CHAR(1,0) Target database type ZPINST CHAR(30) Target database instance name ZPTPIP CHAR(30) Target database IP address ZPPORT CHAR(10) Target database connection port ZPUSER CHAR(30) Target database user ID ZPPRFX […]
(A80) System control file (ZSERVR) Read More »
Field Name Key Data Type Description ZQNDX K NUMBER(9,0) Record index ZQBOA CHAR(1) C/B/A-before or after table creationA – Execute AFTER the table is downloadedB – Execute BEFORE the table starts downloadingC – Execute BEFORE the table is created ZQKEY TEXT Binding table list, separates by semicolon ZQSEQ NUMBER(9,0) Sequence of execution99998 – Index buildup
(A90) SQL statement master (ZTBSQL) Read More »
Field Name Key Data Type Description UPLIB K CHAR(10) AS400 library name UPFILE K CHAR(10) AS400 file name UPFLDI K CHAR(10) AS400 field name UPTXT CHAR(50) Field text UPFRMK CHAR(64) User remark Refer to (590) Upload data from PC database to AS400
(A120) Upload field master (ZUPFLD) Read More »
S303 AS400 at <IP address> is not running. Will re-connect <n> minutes later. S402 <PC database type> at <IP address> is not running. Will re-connect <n> minutes later. S501 Rebooted after being in a suspend mode
(B20) Suspended messages Read More »
E001 AS400 user <user> does not have the authority to execute QMirror/DB E002 Table list is empty. Please build up table list from AS400 physical files E004 AS400 SQL system error E101 QMirror/DB license is expired or incorrect E102 QMirror/DB license is expired E103 Configuration failure E104 A serious problem occurred. Please drop QMIRROR database in
(B10) Error messages Read More »
Install QMirror DB 1. (110) (130) Install and configure PC database2. (200) Create an AS400 user profile for QMirror DB3. (300) Install QMirror DB4. (330) Configure QMirror DB5. Performance check (command option P)6. (340) Build up table list from AS400 physical files (command option 4) (Note: The empty physical files on the AS400 will not be processed by the trial version.)7. (360)
