Jan,

Thanks!

I used the db2 -f  command to export all of the Z/OS tables under a
certain user. I had to create a wrapper and server to point to the Z/OS
machine and then I created synonyms. It works great! The other way
worked also but it requires more work in crafting the load utility.

export to ab_pct_tbl.ixf of ixf         messages msgs.txt select * from
db2admin.ab_pct_tbl        ;
export to acs_tbl.ixf of ixf            messages msgs.txt select * from
db2admin.acs_tbl           ;
export to addresses.ixf of ixf          messages msgs.txt select * from
db2admin.addresses         ;
export to aims_cntl_tran.ixf of ixf     messages msgs.txt select * from
db2admin.aims_cntl_tran    ;