Field Name Key Data Type Description ZMJLIB K CHAR(10) Journal library ZMJNAM K CHAR(10) Journal name ZMJNDX NUMBER(3,0) Journal index ZMCRCV CHAR(10) Current journal receiver ZMCSEQ NUMBER(10,0) Current sequence number ZMJRCV NUMBER(4,0) No. of last deleted journal receiver ZMRMRK CHAR(128) Remark Go to (220) About QMirror/DR internal SQLite database
(A60) Journal master (ZJMASF) Read More »
Field Name Key Data Type Description ZPLGDT NUMBER(8,0) Logging date ZPLGTM NUMBER(6,0) Logging time ZPLSEQ NUMBER(3,0) Sequence number ZPLOGS TEXT QMirror/DR log Go to (220) About QMirror/DR internal SQLite database
(A70) System log file (ZPCLOG / ZPCLOG2) Read More »
Field Name Key Data Type Description ZVERNO CHAR(10) QMirror/DR version number ZSVRID CHAR(4) Configuration ID ZRECOVERY CHAR(1) Y – recovery mode ZSYSDB CHAR(1) Separated system database ZPTPIP CHAR(30) Target AS400 IP address ZPUSER CHAR(30) Target AS400 user ID ZATPIP CHAR(30) Source AS400 IP address ZAUSER CHAR(10) Source AS400 user ID ZSLKEY CHAR(31) QMirror/DR license key
(A80) System control file (ZSERVR) Read More »
W101 QMirror/DR configuration terminated W103 QMirror/DR license will be expired at the end of this month W104 QMirror/DR command terminated W303 AS400 at <IP address> is not running. Will re-connect <n> minutes later. W305 Failed to build up the replication path. Re-starting QMirror/DR. W307 AS400 journal <library/journal> is not available now. Will try again later. W308 AS400
(B20) Warning messages Read More »
E001 AS400 user <user> does not have the authority to execute QMirror/DR E002 Object list is empty. Please build up object list from AS400 libraries E004 Make sure the latest PTFs are applied to the AS400 server at <IP address> E101 QMirror/DR license is expired or incorrect E103 Configuration failure E106 Configuration ID <id> is incorrect
(B10) Error messages Read More »
Notes: An additional license is required to enable QMirror/DB upload functions. QMirror/DB provides a convenient and safe method for writing data back to the AS400 server from the PC database based on transactional management. Only defined upload fields will be written back to the AS400 server, and these fields will be restricted to download from
(590) Upload data from PC database to AS400 Read More »
Field Name Key Data Type Description UPTMST K CHAR(26) Transaction timestamp e.g. CURRENT_TIMESTAMP for MS SQL Servere.g. NOW(3) for MySQL UPTRXN K CHAR(10) Transaction code UPLIB K CHAR(10) AS400 library name UPOBJ K CHAR(10) AS400 file name UPMBR K CHAR(10) AS400 member name UPCODE K CHAR(1) Upload code (I/U/D) UPRRN K NUMBER(10,0) AS400 relative record
(A110) Upload transaction detail (ZUPDTL) Read More »
Field Name Key Data Type Description UPTMST K CHAR(26) Transaction timestamp e.g. CURRENT_TIMESTAMP for MS SQL Servere.g. NOW(3) for MySQL UPCLIB K CHAR(10) CL PGM library UPCPGM K CHAR(250) CL programWill be called right after upload successes UPTRXN K CHAR(10) Transaction code UPRMRK CHAR(64) User remark UPRTN CHAR(4) Return code UPUDAT NUMBER(8,0) Upload date UPUTIM
(A100) Upload controller (ZUPCTL) Read More »
Do you have PC database installed? (110) If the answer is No- Download and install PC database QMirror/DB supports the following PC databases: Among the supported databases, MySQL or SQL Server databases are recommended. You can download one of them from its Website and install it on your PC server. If you are using other
(110)(130) Configure PC database Read More »
1. To create an AS400 user profile ‘QMIRROR’, enter command: CRTUSRPRF USRPRF(QMIRROR) PASSWORD(xxxxxxxx) USRCLS(*USER) SPCAUT(*ALLOBJ *JOBCTL) PWDEXPITV(*NOMAX) 2. Or use any existing user profile which owns SPCAUT(*ALLOBJ *JOBCTL) authority. 3. The user profile has to have authority to execute following commands: ADDRPYLE, CHGJOB, CHGJRN, CPYF, CRTDTAATA, CRTJRN, CRTJRNRCV, CRTLIB (Notes), CRTMSGQ, DLTDTAARA, DLTF, DLTJRNRCV, ENDJRNPF, SNDJRNE,
(200) Create an AS400 user profile for QMirror/DB Read More »
