Hi,

2 utilities

db2look
db2move

with some underwater rocks.

ddl after db2look need to be parsed to :

- create db
- cfg db
- create bp (if you have tbs with page > 4K - restart db)
- create tablespaces
- create tables without any constrains

then

- load data (if you have tables with identity you need handmade load +
alter tables with autoincremental column for new start values)
- create table constrains, indexes, fk
- create summary tables

After that you need write simple script for create ddl for triggers, view
and fucntions which create its in right order(!!!).

Last stage - create sql procedures.


Andrew
www.it4profit.com

P.S. mail me if you have troubles.