IBM SG24-6320-00 manual Our example we called the as follows

Draft Document for Review July 28, 2004 7:33 pm 6320ch_DEV_before_migration.fm

updateDB2Configuration <database_name> [<logfile>]

Where <database_name> is the name of the database to change configuration values for and <logfile> is an optional parameter, naming the file to use for logging the progress of the script.

Important: The script must be called from a DB2 Command Window. If the script is run from a regular Windows command prompt window, the following output will be shown 11 times in the console, or log file if specified:

DB21061E Command line environment not initialized.

In our example we called the as follows:

D:

cd \WebSphere\WCToolkitPro56\bin

updateDB2Configuration mall c:\logs\updatedb2configuration.log

Once the script has executed, check the logs to ensure no errors has occurred. The script runs a series of SQL commands, so any SQL command failing is an indication of an error.

The script will update the database configuration values with the minimum recommended as shown in Table 6-4.Base on your database characteristics, your DBA should review and modify these values accordingly in the script before executing the script.

Table 6-4 DB2 configuration set by the updateDBConfiguration script

Parameter	Value
applheapsz	1000
stmtheap	60000
app_ctl_heap_sz	8192
locklist	2400
indexrec	RESTART
logfilsize	1000
logprimary	12
logsecond	10
pckcachesz	4096
catalogcache_sz	4096

Chapter 6. Pre-migration steps 103