QMirror DB

(010) 3 Steps to implement QMirror DB

The QMirror/DB implementation consists of three steps and takes a few minutes to complete. Step I. Configure PC Database (110)(130) Configure PC database Step II. Configure AS400 (200) Create an AS400 user profile for QMirror/DB(210) Check AS400 configuration Step III. Configure QMirror DB(download Configuration Data Sheet ) (300) Install QMirror/DB(310) Install QMirror/DB on Linux(330) Configure …

(010) 3 Steps to implement QMirror DB Read More »

(370) Download journaled physical files without replication

You can download journaled physical files without replication by setting the table as non-journaled. To do this, set column TBREPL to ‘N‘, TBJLIB and TBJNAM to blank in QMirror/DB system table ZAMTBF. E.g. UPDATE QMIRROR.ZAMTBFSET TBREPL=’N’,TBJLIB=”,TBJNAM=”WHERE TBLIB=’LIBR1′ AND TBOBJ=’FILEA’ AND TBMBR=’FILEA’ Previous (360) Start / end AS400 journaling by QMirror/DBNext (380) Upgrade QMirror/DB

(A17) Dynamic selection master (ZAMTBS)

Field Name Key Data Type Description TBLIB K CHAR(10) AS400 library name TBGEN K CHAR(10) Generic physical file name ATOJRN CHAR(1) Auto start journal LFLIB CHAR(10) Logical files located library name Refer to (525) Dynamic table selection

(525) Dynamic table selection

QMirror/DB supports dynamic table selection, which downloads and replicates tables after around 10 minutes they are created on the AS400. (Note: The empty physical files on the AS400 will not be processed by the trial version.) E.g. A daily transaction file named TRNyymmdd is created in library INVLIB on AS400 every morning. To let QMirror/DB …

(525) Dynamic table selection Read More »

(A125) Mapped field master (ZWHFLM)

Field Name Key Data Type Description MAPLIB K CHAR(64) Mapped database name MAPOBJ K CHAR(64) Mapped table name MAPFLD K CHAR(64) Mapped field name WHFLDI CHAR(10) AS400 field name Refer to (585) Define mapping table on PC database

(A15) Mapped table master (ZAMTBM)

Field Name Key Data Type Description MAPLIB K CHAR(64) Mapped database name MAPOBJ K CHAR(64) Mapped table name TBLIB CHAR(10) AS400 library name TBOBJ CHAR(10) AS400 file name TBMBR CHAR(10) AS400 member name MAPSEQ NUMBER(1,0) Mapped sequence Refer to (585) Define mapping table on PC database

Scroll to Top