cancel
Showing results for 
Search instead for 
Did you mean: 

DB migration of a DB2 instance on z/OS

Former Member
0 Kudos

We have a DB migration requirement here where the current environment is:

DB instance is a DB2 server running on z/OS mainframe while the CI is already a Windows server on a non-mainframe server. Plan is to get rid of DB2 and migrate it to (a non-mainframe server) MSSQL.

In such a environemnt and project, we were keen to know how do we export the database for DB migration? In the case where the DB is DB2 running on z/OS (and the CI on Windows platform), how will be the migration approach from the perspective of where does the DB export run? Do we essentially make use of USS (Unix system services) for z/OS? If so, where can I get the (download the) kernel for USS on z/OS from SAP Service marketplace? -OR- Can the Dbexport intiated from the CI host?

In the case of a distributed SAP installation where the DB instance and the CI instance run on seperate boxes, where will my DBexport (or R3load export processes) run? Is it necessary that the export has to be done from the DB instance only?

Accepted Solutions (1)

Accepted Solutions (1)

thomas_vogt
Advisor
Advisor
0 Kudos

The export has to be done using the installation tool (dependent on the SAP release R3setup or SAPinst) and is always running on the application server.

There's no need to install an application server on z/OS.

More details at service.sap.com/osdbmigration and in the Heterogeneous system copy guide (service.sap.com/instguides).

Regards Thomas

Answers (1)

Answers (1)

Former Member
0 Kudos

Mangesh,

We're considering the same migration. How big is the database you're migrating? Have you done any test migrations yet?

Jeff

Former Member
0 Kudos

Just to add that all above questions could be answered by certified OS/DB consultant to lead your project.

SAP requires it for support reason after migration.

The speed depends on:

- release of kernel

- size of the largest table

- hardware, etc.