Macromedia live cycle 7.2 매뉴얼

Installing and Configuring LiveCycle for JBoss

 Creating a DB2 database     44

The user name and password of the new user you create on the database is used again when you create 
the data source.

For information about using Oracle 9i or 10g, see the Oracle 9i or 10g user documentation.

Create a DB2 database by running the script provided in this section. The script is tuned for a system that 
will use 1 GB of memory for the database. If your system has a different amount of memory dedicated for 
the database, see the DB2 documentation for details on configuring your system settings. 

You must also create a user with SYSADM and DBADM privileges that can be used when configuring the 
data source on the application server. For information about creating a user, see the DB2 documentation. 
For deployments on Linux, the user name must not exceed 8 characters and, on Windows, it must not 
exceed 12 characters. 

The user name and password of the new user you create on the database is used again when you create 
the data source.

After you create the database, you must configure it to enable concurrent usage. (See 

.)

➤

1. On the computer that hosts DB2, create a new text file that includes the following DB2 script:

create database dbname using codeset utf-8 territory default;
connect to dbname;
CREATE BUFFERPOOL "BP8K" SIZE 50000 PAGESIZE 8192 NOT EXTENDED STORAGE;
connect reset;
connect to dbname;
CREATE TEMPORARY TABLESPACE DBNAME_TEMP_8K IN DATABASE PARTITION GROUP
IBMTEMPGROUP PAGESIZE 8192 MANAGED BY SYSTEM USING
('DB2_root\DBNAME_TEMP')
EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL BP8K; 
CREATE REGULAR TABLESPACE DBNAME_DATA_8K IN DATABASE PARTITION GROUP
IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE USING
(FILE'DB2_root\DBNAME_DATA'9000) EXTENTSIZE 16 PREFETCHSIZE 16 BUFFERPOOL
BP8K;
commit work; 
connect reset; 
connect to dbname;
alter bufferpool ibmdefaultbp immediate size 96000;
alter bufferpool bp8k immediate size 32000;
commit work;
connect reset;
update db cfg for dbname using dbheap 4000;
update db cfg for dbname using logbufsz 2048;
update db cfg for dbname using locklist 2000;
update db cfg for dbname using chngpgs_thresh 40;
update db cfg for dbname using logfilsiz 4000;
deactivate database dbname;
activate database dbname;