In this section, we show how to use DB2 Control Center to create a database for Lotus Notes Traveler. You can also use create database statement using command line.
When using DB2 for Linux, UNIX, and Windows as the enterprise database server for Lotus Notes Traveler, Lotus Notes Traveler is a DB2 application. If the database server is dedicated to Lotus Notes Traveler, the tuning consideration can just focus on Lotus Notes Traveler. When Lotus Notes Traveler is sharing the database server with other applications, the database administrator will have to balance the resources among the applications. We introduce the initial DB2 server configuration using DB2 Configuration Advisor.
To configure the DB2 HADR to provide the high availability, see High Availability and Disaster Recovery Options for DB2 on Linux, UNIX, and Windows
Creating a DB2 database
To create a DB2 database through Control Center, use these steps:
1. Launch the DB2 Control Center and select Create Database → Standard
2. Follow the Create Database Wizard. Fill in the Database name, In this example, it is called traveler
3. Specify the locale
4. Click through and click Finish
. This will create the traveler database. Note: You do not need to create tables at this point. Lotus Notes Traveler server will automatically create tables during configuration. Go to section 4.3.3 Lotus Notes Traveler configuration for high availability
to configure Lotus Notes Traveler server to use DB2.
Locating the DB2 connection port number
To locate the DB2 server name and port number:
1. Open the DB2 Control Center on the Windows server.
2. Right-click one of the available instances for the local machine.
3. Click Setup Communications.
4. Click Properties. The port number is listed in the Properties window.
Tuning the DB2 database
Follow this steps to configure database.
1. From the Control Center, right-click your database and select Configuration Advisor
2. Select Server
to specify how much of this server's memory can be used. Assuming the database server is dedicated to Lotus Notes Traveler, you can select 80% target memory to allow system to use almost all of the memory for this database.
3. For the the type of workload, select Mixed
4. Specify a typical database transaction. Select More than 10 (long transactions)
and set the Transaction per minute (estimate)
5. Specify a database administration priority. Select faster performance.
6. Select No data populated
7. Estimate the number of applications connected. For example, if your DBMaxPoolSize is set as 2000, then you have to set Average number of connected remote applications
8. Select default Cursor stability
as the isolation level.
9. Review your selection and click Finish
to perform the changes.