If you modify the sample Stage 1 migration tool or develop your own Stage 1 migration tool, the following SQL queries might be useful in verifying your changes.
db2 connect to VGMIG
To verify the first few characters of the External Source Format for all parts in the migration database:
db2 select vgpartname, cast(vgesfsource as char(n)) from migschema.vgpartn is a number between 1 and 256 and is the number of characters you want to display.
To determine if any parts in the migration database do not begin with valid External Source Format tags:
db2 select vgpartname, cast(vgesfsource as char(n)) from migschema.vgpart where vgesfsource not like ':%'n is a number between 1 and 256 and is the number of characters you want to display.
To reset all parts in the migration database if you want to rerun Stage 2 and 3 of migration without rerunning Stage 1:
db2 update migschema.vgpart set is_migrated = 'N', eglsource = NULL db2 delete from migschema.translation_msgs
To backup the migration database:
db2 backup database vgmig to x:\mybackups\backupNamex:\mybackups\backupName is the drive and directory where you want the backup to be placed. Several subdirectories will be created under x:\mybackups\backupName.
To restore the migration database that you previously backed up:
db2 restore database vgmig from x:\mybackups\backupName REPLACE EXISTINGx:\mybackups\backupName is the drive and directory where you want the backup to be placed. Several subdirectories will be created under x:\mybackups\backupName.
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.