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?
Thomas Vogt replied
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).