The following instructions describe how to manually create
the
DB2®
database
for Leap.
Before you begin
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.
Procedure
To set up the
DB2®
database:
- Create an empty
DB2®
database
with a maximum database name of 8 characters, and a maximum page size
of 32768.
- 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"