Creating a DB2 database

The following instructions describe how to manually create the DB2® database for Leap.

In a production environment, you must create DB2 database before you install HCL Leap to WebSphere® Application Server.

Note: Do not create a database if you want to continue using the same database with the existing user content.

1. To set up the DB2 database:

   1. Create an empty DB2 database with a maximum database name of 8 characters, and a maximum page size of 32768.

   2. Connect to the database and create a User Temporary table space.

      Use the following settings for the temporary table space:

      • Large_usertemp pagesize 32K
      • Managed by automatic storage extentsize 16
      • <bufferpool-name> is the name of your DB2 large buffer pool. Each DB2 server can have a different name.

        db2 "CREATE DB FEBDB using codeset UTF-8 territory us PAGESIZE 32768"
         db2 connect to FEBDB
        db2 "CREATE BUFFERPOOL bufferpool-name IMMEDIATE SIZE 250 PAGESIZE 32K"
        db2 "CREATE USER TEMPORARY TABLESPACE LARGE_USERTEMP PAGESIZE 32k MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 16 PREFETCHSIZE 16 BUFFERPOOL bufferpool-name"
        

Parent topic: Create a Database