+

Search Tips | Advanced Search

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


Create the DB2 database for Application Center

During IBM MobileFirstâ„¢ Platform Foundation installation, the installer can create the Application Center database for you.

The installer can create the Application Center database for you if you enter the name and password of a user account on the database server that has the DB2® SYSADM or SYSCTRL privilege, and the account can be accessed through SSH. Otherwise, the database administrator can create the Application Center database for you. For more information, see the DB2 Solution user documentation.

When we manually create the database, we can replace the database name (here APPCNTR) and the password with a database name and password of your choosing.

Important: We can name your database and user differently, or set a different password, but ensure that you enter the appropriate database name, user name, and password correctly across the DB2 database setup. DB2 has a database name limit of 8 characters on all platforms, and has a user name and password length limit of 8 characters for UNIX and Linux systems, and 30 characters for Windows.


Procedure

  1. Create a system user, for example, named wluser in a DB2 admin group such as DB2USERS, using the appropriate commands for our operating system. Give it a password, for example, wluser. If we want multiple instances of IBM MobileFirst Platform Server to connect to the same database, use a different user name for each connection. Each database user has a separate default schema. For more information about database users, see the DB2 documentation and the documentation for our operating system.
  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, navigate to ~/sqllib/bin and enter ./db2.
    • Enter database manager and SQL statements similar to the following example to create the Application Center database, replacing the user name wluser with your chosen user names:

        CREATE DATABASE APPCNTR COLLATE USING SYSTEM PAGESIZE 32768
        CONNECT TO APPCNTR
        GRANT CONNECT ON DATABASE TO USER wluser
        DISCONNECT APPCNTR
        QUIT

  3. The installer can create the database tables and objects for Application Center in a specific schema. This allows you to use the same database for Application Center and for a MobileFirst project. If the IMPLICIT_SCHEMA authority is granted to the user created in step 1 (the default in the database creation script in step 2), no further action is required. If the user does not have the IMPLICIT_SCHEMA authority, you need to create a SCHEMA for the Application Center database tables and objects.

Parent topic: Optional creation of databases