6320ch_migrating.fm Draft Document for Review July 28, 2004 7:33 pm
210 Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide
In our example:
D:\WebSphere\CommerceServer56\logs\migration\instancename\migrateddb51_time
stamp.log
Example 11-1 A Sample of the migration log file with the precheck option set
[2004.04.30 11:38:29] Info : Logging started in VERBOSE mode.
[2004.04.30 11:38:29] Info : DTD path: ...
[2004.04.30 11:38:29] Event: Loading plan:
D:\WEBSPH~1\COMMER~1\schema\migration\config\DataMigrationPlan51.xml
[2004.04.30 11:38:32] Info : Plan loaded.
[2004.04.30 11:38:32] Info : dbname: mall
[2004.04.30 11:38:32] Info : dbuser: dbusr01
[2004.04.30 11:38:32] Info : dbtype: db2
[2004.04.30 11:38:32] Info : instance name: demo
[2004.04.30 11:38:32] Info : schema name: dbusr01
[2004.04.30 11:43:08] Info : set schema dbusr01
[2004.04.30 11:43:14] Info : SELECT PRODUCTVERSION FROM SITE
[2004.04.30 11:43:16] Info : SELECT LANGUAGE_ID FROM LANGUAGE WHERE LOCALENAME='en_US'
[2004.04.30 11:43:17] Info : Init Migrator ends.
[2004.04.30 11:43:17] Event: Pre migration begins...
[2004.04.30 11:43:21] Event: Executing command: precheck
[2004.04.30 11:43:21] Event: running java program:
com.ibm.commerce.migration.command.PreCheckCommand
[2004.04.30 11:43:23] Info : select count(*) from bzrpentstg where LENGTH(value) > 4000
[2004.04.30 11:43:24] Info : select count(*) from calcodedsc where LENGTH(longdescription) >
4000
.
.
.
[2004.04.30 11:43:14] Warning: In order to migrate one of the biggest tables "ORDERITEMS" in
the database, the database migration script needs at least 303 MB in the database log space. It
also needs at least 303 MB free disk space in the tablespace. Otherwise, the database migration
may fail.
.
.
.
[2004.04.30 11:43:35] Warning: [401] You have some items without parent products. You may
create a parent product for each item if you do not want default migration behaviour.
.
.
.
[2004.04.30 11:43:35] Info : select count(*) from storecgry where name is null
[2004.04.30 11:43:35] Event: In the database prechecking, there are some warnings. See log file
for details.
[2004.04.30 11:43:35] Info : Executed command: precheck
[2004.04.30 11:43:35] Event: Pre migration ends.
[2004.04.30 11:43:35] Event: Migration has terminated successfully.