Creating the DB2 database for MobileFirst Server administration

During the installation of IBM MobileFirst™ Platform Foundation, the installation tools can create the administration database for you.

Before you begin

You perform this procedure to create the databases before you run Ant tasks or the Server Configuration Tool to populate them. For a fully manual database installation, see Configuring the DB2 database manually for the IBM MobileFirst Platform Server administration instead.

About this task

The installation tools can create the administration 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 administration database for you. For more information, see the DB2 Solution user documentation.

When you create the database manually, you can replace the database name (here WLADMIN) and the password with a database name and password of your choice.

Important: You 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 limits:

Database names: no more than 8 characters on all platforms
User name and passwords: no more than 8 characters for UNIX and Linux, and no more than 30 characters for Windows

Procedure

Create a system user named, for example, wluser in a DB2 admin group such as DB2USERS, by using the appropriate commands for your operating system. Give it a password, for example, wluser.
If you want 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. For more information about database users, see the DB2 documentation and the documentation for your operating system.
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.
To create the administration database, enter database manager and SQL statements similar to the following example.
Replace the user name wluser with your own.
```
CREATE DATABASE WLADMIN COLLATE USING SYSTEM PAGESIZE 32768
CONNECT TO WLADMIN
GRANT CONNECT ON DATABASE TO USER wluser
DISCONNECT WLADMIN
QUIT
```

What to do next

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

If the IMPLICIT_SCHEMA authority is granted to the user that you created in Step 1, no further action is required. This is the default in the database creation script of Step 2.
If the user does not have the IMPLICIT_SCHEMA authority, create a SCHEMA for the administration database tables and objects.