IBM VERSION 9 manual v Click Install New to create a newDB2 copy

If you have at least one existing DB2 product installed on your computer, you can:

vClick Install New to create a newDB2 copy

vClick Work with Existing to upgrade an existing DB2 copy, to add functionality to an existing DB2 copy, or to install an add-on product.

vClick Migrate to migrate an existing DB2 Version 8 copy.

5.The DB2 Setup wizard will determine the system language, and launch the setup program for that language. Online help is available to guide you through the remaining steps. To invoke the online help, click Help or press F1. You can click Cancel at any time to end the installation.

Your DB2 product will be installed, by default, in the x:\Program Files\IBM\sqllib directory, where x: represent the drive letter of the drive where you have installed your DB2 product.

If you are installing on a system where this directory is already being used, the DB2 product installation path will have _xx added to it, where _xx are digits, starting at 01 and increasing depending on how many DB2 copies you have installed.

You can also specify your own DB2 product installation path.

For information on errors encountered during installation, review the installation log file located in the My Documents\DB2LOG\ directory. The log file uses the following format: DB2-ProductAbrrev-DateTime.log, for example, DB2-ESE-Tue Apr 04 17_04_45 2006.log.

If you want your DB2 product to have access to DB2 documentation either on your local computer or on another computer on your network, then you must install the DB2 Information Center. TheDB2 Information Center contains documentation for the DB2 database system and DB2 related products. By default, DB2 information will be accessed from the web if the DB2 Information Center is not locally installed.

DB2 Express memory limits and the DATABASE_MEMORY configuration parameter:

If you are installing DB2 Express Edition or DB2 Express-C Edition on a system that has more memory than the maximum memory limit of 4GB, as outlined in the terms and conditions of the product, you need to explicitly set the DATABASE_MEMORY configuration parameter to 4GB or less, so that the Self Tuning Memory Manager will work within your licensed memory limits.

Note: If you have more than one database on that server, the sum of all database memory usage cannot exceed 4GB.

You can use the Control Center or the UPDATE DATABASE CONFIGURATION command to make this change. For example, to set the DATABASE_MEMORY limit to 4GB, enter the following command:

DB2 UPDATE DATABASE CONFIGURATION using DATABASE_MEMORY 1000000 IMMEDIATE; CONNECT RESET;

Also, when using the Configuration Advisor to assist you in configuring the performance of your database, you need to set the Target Memory on the Server page to a percentage of your total system memory that will ensure you stay under the 4GB memory limit.

18Getting started with DB2 installation and administration