Skip to Content
avatar image
Former Member

DB migration of a DB2 instance on z/OS

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 27, 2006 at 03:27 PM

    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 and in the Heterogeneous system copy guide (

    Regards Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2006 at 08:01 PM


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


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.