Create the DB2 database for MobileFirst Server administration

Overview

The installation tools can create the administration for us. Enter the name and password of a user account on the database server with SYSADM or SYSCTRL privileges, and accessible through SSH. Alternatively, the database administrator can create the administration database for you. See DB2 Solution user documentation.

When creating the database manually, we can replace the database name (here WLADMIN) and the password with a database name and password of the our choice.

DB2 limits:

• Database names: No more than 8 characters on all platforms
• User name and passwords: No more than 8 characters for UNIX and Linux. No more than 30 characters for Windows

Create administration DB and user

1. Create a system user named, for example, wluser in a DB2 admin group such as DB2USERS.

   For multiple MobileFirst Server instances to connect to the same database, use a different user name for each connection. Each database user has a separate default schema.

2. Open a DB2 command-line processor...

   • On Windows systems, click...
     Start > IBM DB2 > Command Line Processor

   • On Linux or UNIX...
     cd ~/sqllib/bin
     ./db2

3. Create the database.

   Replace "wluser" with your user name.

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

The installation tools can create the database tables and objects for MobileFirst Server administration in a specific schema. Then use the same database for MobileFirst Server administration and for a MobileFirst project.

If the IMPLICIT_SCHEMA authority is granted to the user created (the default), no further action is required. If the user does not have the IMPLICIT_SCHEMA authority, create a SCHEMA for the administration database tables and objects.

Parent topic: Create administration database (Optional)