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 »
Case studyWhen an employee master file on the AS400 contains sensitive data, you can encrypt it in the target database. Library – EMPLIBR Physical file – EMPMASTER Data fields – F1 – Employee ID F2 – Social security number (character) F3 – Salary (decimal) Target database – MS SQL Server — Create database key USE
(535) Data encryption in the target database Read More »
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
(370) Download journaled physical files without replication Read More »
QMirror/DB provides you a simple way to migrate data from AS400 to PC databases. Live Data Migration Steps 1. Install and configure QMirror/DB 2. Select tables from AS400 libraries/PFs by taking command option 4(Note: The empty physical files on the AS400 will not be processed by the trial version.) 3. Start journaling all tables by
(560) Data migration from AS400 to PC databases Read More »
A large object (LOB) is a string data type with a size ranging from 0 bytes to 2 GB. For example, audio, video, drawing, mixed text and graphic, and image. For performance consideration, QMirror downloads and replicates large object fields as empty strings. If you want to download and replicate large object fields to the
(480) Large object (LOB) processing Read More »
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
(A17) Dynamic selection master (ZAMTBS) Read More »
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 »
(Note 1: An additional license is required to enable QMirror/DB mapping functions.)(Note 2: QMirror/DB upload function does not support multiple split mapped tables.) Normally, QMirror/DB replicates AS400 physical files to the target database with the same naming rules. Target database name = AS400 library name Target table name = AS400 physical file name AS400 physical
(585) Define mapping table in the PC database Read More »
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
(A125) Mapped field master (ZWHFLM) Read More »
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
(A15) Mapped table master (ZAMTBM) Read More »
