IBM SG24-6320-00 manual Updating database configuration values, Script is invoked as follows

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

10.3.3 Updating database configuration values

The database configuration values, such as logfile size, application heap and statement heap, must be updated up to WebSphere Commerce V5.6 level prior to running any migration scripts. A script file is provided with WebSphere Commerce V5.6 for updating the database configuration values:

<wc56_home>\bin\updateDB2Configuration.bat

The script is invoked as follows:

updateDB2Configuration <WC_db> [<logfile>]

Where <WC_db> 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.

In our example we called the as follows:

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 10-4.Base on your database characteristics, your DBA should review and modify these values accordingly in the script before executing the script.

Table 10-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

192Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide