(110)(130) Configure PC database

Do you have PC database installed?

(110) If the answer is No- Download and install PC database

QMirror/DB supports the following PC databases:

• MySQL
• PostgreSQL — Increase max_connections, shared_buffers and kernel.shmmax by changing postgresql.conf
• MS SQL Server
• Azure SQL Database — 50 DTUs or above
  Make sure you are using Azure SQL Database, not Azure SQL Managed Instance.
• Oracle
• LUW DB2
• MaxDB
• MariaDB
• Tibero

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 PC database, let us know and we shall do our best to fulfill your requirement.

QMirror connects your PC database by IP address. Make sure your PC database can be connected by TCP/IP.

(130) If the answer is Yes – Check existing databases

QMirror/DB will use the following databases in your existing PC database instance:

1. System database – QMIRROR

There should be no database named ‘QMIRROR’ before installing QMirror/DB.

2. User databases – named as AS400 library

QMirror/DB assigns table name as AS400 physical file name in these databases.

Previous (020) Quick Start
Next (200) Create an AS400 user profile for QMirror/DB