QMirror/DB Configuration Data Sheet =================================== 1 QMirror PC server administrator password - (*** Important! Run command prompts with administrative privileges) e.g. qmpc0987 (or leave blank) 2 PC database type - e.g. SQL Server 3 Database name or Instance name for the specified database type - e.g. qmirrordb 4 PC database server IP address or hostname - (*** Important! Make sure the PC database server can be connected by TCP/IP) e.g. 10.10.10.12 5 PC database port - e.g. 1433 6 PC database administrator ID - e.g. sa 7 PC database password - e.g. sa123pwd (or leave blank) 8 AS400 IP address or hostname - (*** Important! Make sure the AS400 server can be connected by TCP/IP) e.g. 10.10.10.11 9 AS400 user profile - (https://www.qmirror.com/knowledge-base/qmirror-db-200-create-an-as400-user-profile-for-qmirror-db/) e.g. QMIRROR 10 AS400 QMirror working library - (QMirror will save some objects in this library) e.g. QMIRROR 11 PC database character data type (VARCHAR or CHAR) - e.g. VARCHAR 12 PC database natural number data type (EXACT-NUMBER or NUMERIC/DECIMAL) - e.g. EXACT-NUMBER 13 QMirror license key - e.g. T2512-N6E8T-HM9W7-WWBM9-6YBCG 14 PC database character set (ASCII or DBCS/Unicode) - e.g. ASCII 15 AS400 user profile password - e.g. qqmm3456 (or leave blank) 16 AS400 libraries and physical files list - (https://www.qmirror.com/knowledge-base/qmirror-db-340-build-up-table-list-from-as400-physical-files/) e.g. libr1/*all, libr2/abc* (select one by one) 17 AS400 libraries where logical files are located - e.g. libr1, libr2 (select one by one) 18 Are these physical files journaled (Yes or No) - (https://www.qmirror.com/knowledge-base/qmirror-db-360-start-end-as400-journaling-by-qmirror-db/) e.g. Yes 19 The journal receivers will be retained at least one day before deleting (Yes or No) - (https://www.qmirror.com/knowledge-base/qmirror-db-360-start-end-as400-journaling-by-qmirror-db/) e.g. Yes 20 PC database GUI SQL tool - e.g. SSMS for SQL Server, HeidiSQL for MySQL/PostgreSQL 21 Enable Internet Information Services (IIS) on Windows - (https://www.qmirror.com/knowledge-base/qmirror-db-410-get-qmirror-db-running-log-and-status/) e.g. Done