Filter
Top Products
6320ch_before_migration.fm Draft Document for Review July 28, 2004 7:33 pm
192 Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide
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