Use this task to specify initial DB2® database settings. Note that this information is provided only as an example.
To achieve good database operation, specify the initial database settings. You will fine-tune the settings later, in Fine-tuning the database.
Putting the database log file on a disk drive that is separate from the data tends to improve performance, provided that sufficient disk drives are available. If few disk drives are available, distributing the table spaces, as described in the previous section, is usually more beneficial than putting the database log on a separate drive.
db2 UPDATE DB CFG FOR BPEDB USING NEWLOGPATH F:\db2logs
To create a database for high performance, perform the following actions:
CREATE DATABASE BPEDB ON D: USING CODESET UTF-8 TERRITORY en-us;
CREATE DATABASE BPEDB ON /wasdbfs USING CODESET UTF-8 TERRITORY en-us;where /wasdbfs specifies a directory.
- Scriptfile to create tablespaces for DB2 8.1 and 8.2 - to run the script call - db2 connect to BPEDB - db2 -tf createTablespaceDb2.ddl CREATE TABLESPACE AUDITLOG MANAGED BY SYSTEM USING( 'F:/BPEDB_TS/AUDITLOG' ); CREATE TABLESPACE COMP MANAGED BY SYSTEM USING( 'D:/BPEDB_TS/COMP' ); CREATE TABLESPACE INSTANCE MANAGED BY SYSTEM USING( 'E:/BPEDB_TS/INSTANCE' ); CREATE TABLESPACE STAFFQRY MANAGED BY SYSTEM USING( 'D:/BPEDB_TS/STAFFQRY' ); CREATE TABLESPACE TEMPLATE MANAGED BY SYSTEM USING( 'D:/BPEDB_TS/TEMPLATE' ); CREATE TABLESPACE WORKITEM MANAGED BY SYSTEM USING( 'D:/BPEDB_TS/WORKITEM' ); -- start import scheduler DDL: createTablespaceDB2.ddl CREATE TABLESPACE SCHEDTS MANAGED BY SYSTEM USING( 'D:/BPEDB_TS/SCHEDTS' ); -- end import scheduler DDL: createTablespaceDB2.ddl
Use the script for your database that is provided in the ProcessChoreographer directory. For example, for DB2, use the createSchemaDb2.ddl file.
Use a capacity planning tool for your initial database settings.
If you are using DB2, start the DB2 configuration advisor from the DB2 Control Center, by selecting DB2 configuration advisor from the pop-up menu of the Business Process Choreographer database. Do the following actions:
For Server, allocate to DB2 only as much memory as is physically available to it without swapping.
For Workload, select Mixed (queries and transactions).
Select More than 10, to indicate that long transactions are used.
Then, in the Transactions per minute field, select the estimated number of transactions processed each minute. To determine this number, assume that each activity in the process has one transaction. The number of transactions performed in one minute is then as follows:
number of transactions performed each minute = number of processes completed each minute * number of activities in each process
For Priority, select Faster transaction performance.
For Isolation, select Read stability. This isolation level is required for Business Process Choreographer.
The configuration advisor displays suggested changes. You can either apply the changes now, or save them to a file to apply later.
Last updated: Tue Feb 21 17:59:22 2006
(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)