IBM Z and LinuxONE IBM Z

IBM Z

The enterprise platform for mission-critical applications brings next-level data privacy, security, and resiliency to your hybrid multicloud.

 View Only

  • 1.  Migrating Oracle data to DB2 z/os

    Posted Mon March 09, 2020 08:53 AM
    Has anyone migrated Oracle data to DB2 z/OS?  I'm trying to use Database Conversion Warehouse Full client and I don't see a target database for IBM Z.  I see options for IBM UDB.   The documentation seems to say it's supported.  But, I don't see the IBM Z choice.

    ------------------------------
    Janet Klein
    ------------------------------


  • 2.  RE: Migrating Oracle data to DB2 z/os

    Posted Tue March 10, 2020 11:33 AM
    I am no expert on DB2, but this is an expert from an understanding DB2 book. "All versions of DB2 on distributed platforms and on MVS, AS/400, VM, and VSE have adopted the name DB2 UDB". 

    So your IBM UDB option should work.

    ------------------------------
    Jerry Thomas
    ------------------------------

    Original Message


  • 3.  RE: Migrating Oracle data to DB2 z/os

    Posted Tue March 10, 2020 10:05 PM
    Thank you for looking at my issue.  I will try that.

    ------------------------------
    Janet Klein
    ------------------------------

    Original Message


  • 4.  RE: Migrating Oracle data to DB2 z/os

    Posted Thu March 12, 2020 09:26 AM
    DB2 for LUW or DB2 z/OS  are two different things form a technical point.
    Some years ago i had a Oracle Transparent gateway on our z/OS machine / DB2 subsystem - see this list below
    Therefor the question : is your Warehouse Client an Oracle product ? 
    https://support.oracle.com/knowledge/Oracle%20Database%20Products/461234_1.html

    ------------------------------
    Jürgen Jost
    ------------------------------

    Original Message


  • 5.  RE: Migrating Oracle data to DB2 z/os

    Posted Thu March 12, 2020 09:30 AM
    DB2 for LUW or DB2 z/OS  are two different things form a technical point.
    Some years ago i had a Oracle Transparent gateway on our z/OS machine / DB2 subsystem - see this list below
    Therefor the question : is your Warehouse Client an Oracle product ? 
    https://support.oracle.com/knowledge/Oracle%20Database%20Products/461234_1.html

    ------------------------------
    Jürgen Jost
    DB2 z/OS - LUW DBA
    -----------------------
    ------------------------------

    Original Message


  • 6.  RE: Migrating Oracle data to DB2 z/os

    Posted Thu March 12, 2020 09:27 AM
    As a DB2 z/OS DBA  i know from earlier days the Oracle Gateway - installed on z/OS
    the  oracle product for today is may be - the db2 z/OS dba has to do some work
    https://docs.oracle.com/en/middleware/goldengate/core/12.3.0.1/oggin/installing-db2-z-os1.html#GUID-B4267245-E2C6-4A37-9CC6-C5BEF44A5028

    ------------------------------
    Jürgen Jost
    ------------------------------

    Original Message


Related Content