Setting up your DB2 database manually for Application Center

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

1. Create a system user, worklight, in a DB2 admin group such as DB2USERS, by using the appropriate commands for your operating system. Give it the password worklight. For more information, see the DB2 documentation and the documentation for your operating system.
   Important: You 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