For up-to-date product documentation, see the IBM MobileFirst Foundation Developer Center.

Set 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.

• Relational databases
  Understand the users, privileges, and database requirement before you set up the database tables.

Parent topic: Install MobileFirst Server for a production environment