22.0 Database Configuration

Moab supports connecting to a database via native SQLite3, and it can also connect to other databases using the ODBC driver. However, Adaptive Computing presently only supports SQLite3. The SQLite3 connection is for storing statistics. Consider reviewing the SQLite web page Appropriate Uses for SQLite for information regarding the suitability of using SQLite3 on your system.

While the ODBC connection is useful for storing statistics, it also stores events, nodes, and jobs. You can further configure Moab to store checkpoint information to a database rather than to the flat text file (.moab.ck) if you set the CHECKPOINTWITHDATABASE parameter to TRUE.

Connecting to an external database makes Moab more searchable, allowing you to run queries for statistics and events rather than using regular expressions to drawn the information from the Moab flat files. Additionally, storing Moab information in a database is necessary to allow end users the ability to run Moab through a web application.

• 22.1 SQLite3
• 22.2 Connecting to a MySQL Database with an ODBC Driver
• 22.3 Migrating Your Database to Newer Versions of Moab

Moab must use an ODBC-compliant database to report statistics with Viewpoint reports.