A partial download of non-journaled files can be accomplished by QMirror/DB through SQL WHERE clause definition in ZAMTBF.TBSQLW. A new table on the target database <library.file_member_SELECTED> will be created with selected records according to the SQL WHERE clause defined in ZAMTBF.TBSQLW. Case study Jack is the QMirror/DB administrator of company ABC who uses MySQL as […]
(580) Selected download 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 »
Normally, QMirror DB should run well under common AS400 configuration. If you have a slow download speed, you need to check and tune your AS400 configuration. Please refer to the following paragraphs to check your AS400 configuration. Watch the QMirror/DB performance status and tune accordingly. 1. Use command DSPUSRPRF QUSER to verify that the user’s status is
(210) Check AS400 configuration Read More »
Since QMirror/DB demands tiny system resources, we recommend you to install it on the same PC server with database server. For remote download/replication processing, place QMirror/DB server at the AS400 site is better than at the PC databases site. 1. Download QMirror_DB_8xx.zip from https://www.qmirror.com/download/ 2. Uninstall QMirror/DB’s earlier version from Windows program menu list 3. Unzip, execute QMirror_DB_8xx.exe,
(300) Install QMirror/DB Read More »
1. Prepare data for configuration https://www.qmirror.com/qmirror-download/QMirrorDB_Configuration_Data_Sheet.txt 2. Start configuration by c:\QMirrorDB\qmirror.bat 3. Accept the terms of the license agreement Do you accept the terms of the license agreement? (y/N/q) y 4. AS400 IP Address or Hostname 5. AS400 User ID 6. QMirror Working Library (default is ‘QMIRROR’) p.s. QMirror saves work files in working library
(330) Configure QMirror/DB Read More »
(Note: The empty physical files on the AS400 will not be processed by the trial version.) To build up table list from AS400 physical files, take command option 4 to enter AS400 library name and physical file name. Buildup table list from AS400 physical files – Enter AS400 library name: libr1 Enter AS400 physical file
(340) Build up table list from AS400 physical files Read More »
