Knowledge Base

Field Name Key Data Type Description TBLIB K CHAR(10) AS400 library name TBOBJ K CHAR(10) AS400 file name TBMBR K CHAR(10) AS400 member name TBFMT CHAR(10) Record format TBREPL CHAR(1) To be replicated TBJLIB CHAR(10) Journal library TBJNAM CHAR(10) Journal name TBFLDN NUMBER(5,0) Number of fields TBRLEN NUMBER(5,0) Record length TBTXT CHAR(50) AS400 file text […]

Field Name Key Data Type Description EXLIB K CHAR(10) AS400 library name EXFILE K CHAR(10) AS400 file name EXFLDE K CHAR(30) Extended field name EXRESV CHAR(1) Reserved EXFLDT CHAR(32) Extended field data type EXFUNC CHAR(500) Extended field function statementblank – User maintained field EXFTXT CHAR(50) Extended field comment EXSTS CHAR(1) Status of execution Refer to

Field Name Key Data Type Description HDLIB K CHAR(10) AS400 library name HDFILE K CHAR(10) AS400 file name HDFLDE K CHAR(15) Hidden field name Refer to (540) Define hidden fields in the target database

Field Name Key Data Type Description ZJTYPE CHAR(1) Log typeblank – Delay status D – Download statusE – Error occurredR – Recovery statusS – SQL status ZJJBID NUMBER(3,0) Job ID ZJRPDT NUMBER(8,0) Reporting date ZJRPTM NUMBER(6,0) Reporting time ZJACTN CHAR(30) Action description ZJLIB CHAR(10) AS400 library name ZJOBJ CHAR(10) AS400 file name ZJMBR CHAR(10) AS400

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

Field Name Key Data Type Description ZJMRDT NUMBER(8,0) Date replicated ZJMRHR NUMBER(6,0) Hour replicated ZJLIB CHAR(10) AS400 library name ZJOBJ CHAR(10) AS400 file name ZJMBR CHAR(10) AS400 member name ZJINS NUMBER(10,0) Records inserted ZJUPD NUMBER(10,0) Records updated ZJDEL NUMBER(10,0) Records deleted

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/DB log

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

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

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