IBM SG24-6320-00 manual Our example

6320ch_migrating.fmDraft Document for Review July 28, 2004 7:33 pm

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.

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