I need some information on how Migration activity can be planned to Migrate from Mainframe DB2 to DB2 UDB for Windows.

If you have any documents, pdf or any links where in the required information is provided please provide it.

Thanks and regards,
Srini

I would use MS Project for this purpose

If you can do it, the best way to move the data is to catalog the remote DB2 z/OS database from a Linux or Windows DB2 client and export the tables in IXF format from the client. You may have to do a remote bind of DB2 client CLI and utility packages to the DB2 z/OS subsystem (use the Configuration Assistant).

For the DDL, I would see if there is a tool you have z/OS that will recreate the DDL and then you can manually make some minor changes to tablespaces, etc. However, the IXF files will create the tables for you, but not any indexes and maybe not in the tablespaces you want.

Hi Marcus,

How can we go about recreating Indexes in that case? Please reply.

Also, if you have any document on Migration procedures from DB2 Z/OS to DB2 UDB for windows. Please help to share.

Regards,
Srini

Hi Marcus,

Thanks for your reply.

In that case, how can we go about for recreating Indexes?

Also, if you have any documents please share.

Regards,
Srini

Most z/OS shops have a tool that will reproduce the DDL. If you don't have one, you can write a query using the catalog tables to do it (probably SYSIBM.SYSINDEXES, etc). Catalog tables are documented in the appendix of the SQL Reference manual.