Setting up databases

Set up the database to be used by MobileFirst Server components.

The following MobileFirst Server components need to store technical data into a database:

MobileFirst Server administration service
MobileFirst Server live update service
MobileFirst Server push service
MobileFirst runtime
Note: If multiple runtime instances are installed with different context root, each instance needs its own set of tables.

The database can be a relational database such as IBM® DB2®, Oracle, or MySQL.

Relational databases (DB2, Oracle, or MySQL)

Each component needs a set of tables. The tables can be created manually by running the SQL scripts specific to each component (see Create the database tables manually), by using Ant Tasks, or the Server Configuration Tool. The table names of each component do not overlap. Thus, it is possible to put all the tables of these components under a single schema.

However, if you decide to install multiple instances of MobileFirst runtime, each with its own context root in the application server, every instance needs its own set of tables. In this case, they need to be in different schemas.