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

DB2 database and user requirements

Review the database requirement for DB2®. Follow the steps to create user, database, and setup your database to meet the specific requirement.

About this task

The page size of the database must be at least 32768.The following procedure creates a database with a page size 32768. It also creates a user (mfpuser) and then grants the database access to this user. This user can then be used by the Server Configuration Tool or the Ant tasks to create the tables.

Procedure

  1. Create a system user named, for example, mfpuser in a DB2 admin group such as DB2USERS, by using the appropriate commands for your operating system. Give it a password, for example, mfpuser.
  2. Open a DB2 command line processor, with a user that has SYSADM or SYSCTRL permissions.
    • On Windows systems, click Start > IBM DB2 > Command Line Processor.
    • On Linux or UNIX systems, go to ~/sqllib/bin and enter ./db2.
  3. To create the MobileFirst Server database, enter the SQL statements similar to the following example.

    Replace the user name mfpuser with your own.

    CREATE DATABASE MFPDATA COLLATE USING SYSTEM PAGESIZE 32768
CONNECT TO MFPDATA
GRANT CONNECT ON DATABASE TO USER mfpuser
DISCONNECT MFPDATA
QUIT
Parent topic: Database requirements