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

Set up your DB2 database manually for Application Center

We can set up your DB2® database for Application Center manually.

Set up your DB2 database for Application Center by creating the database schema.

Procedure

1. Create a system user, worklight, in a DB2 admin group such as DB2USERS, by using the appropriate commands for our operating system. Give it the password worklight. For more information, see the DB2 documentation and the documentation for our operating system.

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

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. Enter the following database manager and SQL statements to create a database that is called APPCNTR:

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

4. Run DB2 with the following commands to create the APPCNTR tables, in a schema named APPSCHM (the name of the schema can be changed). This command can be run on an existing database that has a page size compatible with the one defined in step 3.

   db2 CONNECT TO APPCNTR
   db2 SET CURRENT SCHEMA = 'APPSCHM'
   db2 -vf product_install_dir/ApplicationCenter/databases/create-appcenter-db2.sql -t

Parent topic: Configure the DB2 database manually for IBM MobileFirst Platform Application Center