Database server requirements
Supported databases
Database clients must be appropriate to the MVMM installation and to the database server. Only configurations with database clients and versions currently supported by the DB vendor for the hardware and OS running the MVMM services are supported. For example, some database clients are not supported on some Linux variants.
MVMM services 64-bit applications on both Linux and Windows. A 64-bit database client must be available for Windows or Linux servers running MVMM .
Database | Version | Notes |
|---|---|---|
Db2 LUW | 10.5, 11.1, 11.5 | For Linux and Windows. Note that the Db2 database needs to have a user temporary tablespace with a page size of 16K or greater. For more information, see Required-roles-and-permissions-for-installation. |
Oracle | 12.2, 18, 19, 21 | For Linux and Windows. |
Microsoft SQL Server | 2014, 2016 | The MVMM services must be on Windows. Using SQL Server Client Driver (ODBC). Set the Default Database to the MVMM database when creating the ODBC DSN. On the Windows 64-bit, you need to define a 64-bit ODBC connection. See Microsoft SQL Server specific concepts for more details. |
Microsoft SQL Server | 2017, 2019, 2022 | For Linux and Windows. Windows: Using SQL Server Client Driver (ODBC), set the Default Database to the MVMM database when creating the ODBC DSN. You need to define a 64-bit ODBC connection. For more details, see Microsoft SQL Server specific concepts. Linux: Using Microsoft ODBC Driver 17 for SQL Server for Linux (Download ODBC Driver for SQL Server, Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS), install the 64-bit ODBC driver and configure an ODBC DSN pointing to the MVMM database. For more details, see Creating-and-initializing-a-Microsoft-SQL-Server-database. |
Contact BMC Support for assistance with:
- Sizing help if you are considering running the database server on the same computer as the other MVMM components.
- The appropriate fix pack or patch set for your database.
Database connection requirements
MVMM is designed with the expectation that the database is available 24x7.
When you use MVMM to store history data, the database collects data continually and any outage might result in the loss of data. For this reason, MVMM expects a continuous database connection.
The BMC services are designed to reconnect to the database if the database goes offline temporarily. If the database comes back online after an extended offline period, the application might automatically re-establish the connection but stability cannot be guaranteed.
In the event of a planned database outage, MVMM services should be in a stopped state while the database is unavailable. In the event of an unplanned database outage, services should be stopped and started once the database is made available again.
Database size
Some parts of the database could be considered a data warehouse with a live continual history data feed. It is not uncommon for the database to grow in size to many gigabytes with tables containing hundreds of millions of rows.
Shared or dedicated database server
You can run the MVMM database on a separate server or on the same server as the MVMM services.
BMC recommends that you run your database and services on different servers. Consider using the same server only if you are working with a small configuration.
Refer to the caution under the Database performance section for information about latency.
If you select to run services on the same system as the database, set a dependency for each of the services to start after your database starts. Services cannot start before the database. If required, contact BMC Support for assistance in configuring this requirement.