Create the DB2 database for Application Center
The installer can create the Application Center database for us. We enter the name and password of a user account on the database server with SYSADM or SYSCTRL privileges. Account should be accessible through SSH.
Alternatively, the database administrator can create the Application Center databasebase for us.
When we manually create the database, we can replace the database name (APPCNTR) and the password with a database name and password of our choice. 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.
- Create a system user, for example, named wluser_project in a DB2 admin group such as DB2USERS.
project. For multiple instances of MPF Server to connect to the same database, use a different user name for each connection. Each database user has a separate default schema.
- Open a DB2 command line processor, with a user with SYSADM or SYSCTRL permissions:
- On Windows systems, click...
Start > IBM DB2 > Command Line Processor
- On Linux or UNIX...
cd ~/sqllib/bin
./db2
- Enter database manager and SQL statements similar to the following example to create the Application Center database, replacing the user name wluser_project with the chosen user names:
CREATE DATABASE APPCNTR COLLATE USING SYSTEM PAGESIZE 32768
CONNECT TO APPCNTR
GRANT CONNECT ON DATABASE TO USER wluser_project DISCONNECT APPCNTR
QUIT
- 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, create a SCHEMA for the Application Center database tables and objects.
Parent topic: Create databases manually