QGuard is a component of the QMirror/DB Windows Service, responsible for monitoring and ensuring the smooth operation of QMirror/DB Windows Service. It starts automatically when QMirror/DB Windows Service is launched. If QMirror/DB Windows Service becomes unresponsive for more than 10 minutes, QGuard will automatically restart the QMirror/DB Windows Service. To stop QMirror/DB Windows Service permanently, […]
(575) QGuard Windows Service Read More »
W101 QMirror/DB configuration terminated W103 QMirror/DB license will be expired at the end of this month W104 QMirror/DB command terminated W301 No table is journaling. Mirror threads disabled W302 Index list is empty. Try to build up indexes… W304 AS400 field value dumping (<offset>) <library/file/member/RRN> W305 Failed to build up the replication path. Re-starting QMirror/DB
(B30) Warning messages Read More »
Field Name Key Data Type Description MAPLIB K CHAR(64) Mapped database name MAPSMA K CHAR(64) Mapped schema for SQL server 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
(A135) Mapped field master (ZWHFLM) Read More »
Field Name Key Data Type Description WHLIB K CHAR(10) AS400 library name WHFILE K CHAR(10) AS400 file name WHMBR K CHAR(10) AS400 member name WHFLNO K NUMBER(4,0) Sequence number WHHIDE CHAR(1) Hidden field WHFLDI CHAR(10) AS400 field name WHFLDE CHAR(30) Target column name WHFLDT CHAR(1) Data type WHCSID NUMBER(5,0) Field CCSID WHALIS CHAR(30) AS400 alternative
(A130) Table field master (ZWHFLD) Read More »
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 – EMPLIBRPhysical file – EMPMASTERData fields – F1 – Employee ID F2 – Social security number (character) F3 – Salary (int)Target database – MS SQL Server– Create database keyUSE EMPLIBR;CREATE MASTER KEY ENCRYPTION BY
(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 »
