User Guide

Adobe LiveCycle Preparing Your Environment
Installing and Configuring LiveCycle for JBoss Configuring a DB2 database for concurrent usage 45
2. Make the following changes to the script:
● Replace the instances of dbname and DBNAME with the name that you want for the LiveCycle
database.
● Replace DB2_root with the path to the root directory where DB2 is installed.
● Ensure that no commands include line breaks and each command is terminated by a semicolon (“;”).
● Change 9000 in the following line based on your database size:
(FILE'DB2_root\DBNAME_DATA'9000)
This number specifies the minimum number of pages required to initialize the database. You can
also change this number using the DB2 administration tools after initializing the database.
3. Save the text file in a location that DB2 Command Line Processor can access.
4. Open a command prompt.
5. (Windows) Enter the following command to open DB2 Command Line Processor:
db2cmd
6. Enter the following command to run the script:
db2 -tf <path_to_script_file>/<script_file_name>
Configuring a DB2 database for concurrent usage
If you are using a DB2 database, you must configure it for multiple-user scenarios.
➤ To configure the DB2 database for concurrent usage:
1. Start DB2 Control Center:
● (Windows) Select Start > Programs > IBM DB2 > General Administration Tools > Control Center .
● (Linux) From a command prompt, enter the command: db2jcc
2. In the DB2 Control Center object tree, click All Databases.
3. Right-click the database you created for LiveCycle products and click Configuration Advisor.
4. Follow the steps in the Configuration Advisor wizard and ensure that the properties in the following
table are set.
DB2 property Required value
Workload type Mixed
Average number of SQL
transactions per unit of work
Fewer than 10
Database Administration Priority Faster transaction performance
Populated Database Set according to the current state of the database. The
database is not populated if the database has not yet been
initialized using Configuration Manager.
Isolation Level Cursor Stability