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 UDB -- Replace occurence or @location@ in this file with the location -- where you want the tablespace containers to be stored, then run: -- db2 connect to BPEDB -- db2 -tf createTablespaceDb2.ddl CREATE TABLESPACE TEMPLATE MANAGED BY SYSTEM USING( 'D:/BPE/TEMPLATE' ); CREATE TABLESPACE STAFFQRY MANAGED BY SYSTEM USING( 'D:/BPE/STAFFQRY' ); CREATE TABLESPACE AUDITLOG MANAGED BY SYSTEM USING( 'E:/BPE/AUDITLOG' ); CREATE TABLESPACE COMP MANAGED BY SYSTEM USING( 'D:/BPE/COMP' ); CREATE TABLESPACE INSTANCE MANAGED BY SYSTEM USING( 'D:/BPE/INSTANCE', 'E:/BPE/INSTANCE'); CREATE TABLESPACE WORKITEM MANAGED BY SYSTEM USING( 'F:/BPE/WORKITEM' ); CREATE TABLESPACE SCHEDTS MANAGED BY SYSTEM USING( ' F:/BPE/SCHEDTS' );
Notice how the INSTANCE table space is distributed across two drives.
Create Business Process Choreographer tables by running the script provided for the respective database. For DB2, for example, use the createSchemaDb2.ddl file in the ProcessChoreographer directory.
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.
The configuration advisor displays suggested changes. You can either apply the changes now, or save them to a file to apply later.
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)