VisualAge Generator to Enterprise Generation Language Migration Guide


Useful Queries

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.

Note:

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.vgpart
n 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\backupName
x:\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 EXISTING
x:\mybackups\backupName is the drive and directory where you want the backup to be placed. Several subdirectories will be created under x:\mybackups\backupName.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]