Database objects for DB2

  1. In your operating system, create a user. The Management Console will use this name to log in to the database. Example: user name BUILD, password BUILD.

    Perform the remaining steps in DB2®. Important: you must use all uppercase for the database name and schema name.

  2. Create a database named BUILD
  3. Create a schema named BUILD.
Note: Build Forge® accesses the database using the schema for the user.

Sample DB2 SQL command script

Use the following commands at a DB2 Command Line Processor to create the and database. 
// Create database and schema
db2 "CREATE DATABASE BUILD USING CODESET UTF-8 
    TERRITORY US PAGESIZE 16 K AUTOCONFIGURE 
    USING MEM_PERCENT 20 APPLY DB ONLY"
db2 "CONNECT TO BUILD"
db2 "CREATE SCHEMA BUILD"
db2 "CONNECT RESET"

// Grant permissions to the user 
db2 "CONNECT TO BUILD"
db2 "GRANT CREATEIN,DROPIN,ALTERIN ON SCHEMA BUILD 
     TO USER BUILD WITH GRANT OPTION"
db2 "GRANT DBADM,CREATETAB,BINDADD,CONNECT,
    CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA, LOAD,
    CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT 
    ON DATABASE TO USER BUILD"
db2 "commit work"
db2 "CONNECT RESET"
db2 "terminate"
Note: The DB2 database page size should be equal to, or larger than, 16K when you install Build Forge, or when you upgrade Build Forge from a previous version and use a DB2 database. For information about how to change the page size, see the DB2 documentation in Knowledge Center.