Procedure
- 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.
- Create a database named BUILD
- Create a schema named BUILD.
Results
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"