Db2 Tools for zOS

 View Only
  • 1.  IBM Tools that can migrate IMS DB to DB2

    Posted Thu January 23, 2025 09:05 AM

    Hello All,

    I have a requirement from a partner to migrate the mainframe  IMS DB to DB2, while exploring I found that CDC can be leveraged to achieve this, so looking out for tools which can help achieve this, appreciate any inputs on this.



    ------------------------------
    Nitesh Kumar
    ------------------------------


  • 2.  RE: IBM Tools that can migrate IMS DB to DB2

    Posted Fri January 24, 2025 03:15 PM

    Hi Nitesh,  CDC could provide assistance in migration, but keep in mind that the primary focus of CDC is capture changes that happen every day.  So, an initial load(point in time) would need to occur to then use CDC to keep the 2 DBs in sync until you are ready to migrate.

    I have participated in 100s of IMS DB migrations to DB2 for z/OS.

    The biggest challenge is create the required SQL access to DB2, in place of the IMS DB calls.

    There are many choices in this space, driven mainly by overall project requirements.

    If you have any specific questions, please feel free to reach out to me at ebersole@ibm.com.



    ------------------------------
    Randy Ebersole

    Db2 for z/OS Technical Specialist

    IBM DB2 for z/OS Expert Lab Services

    ebersole@ibm.com
    ------------------------------



  • 3.  RE: IBM Tools that can migrate IMS DB to DB2

    Posted Fri January 24, 2025 06:40 PM
    We created a way to do this in-house by taking delta of today and yesterday IMS files, we then create simple UPDATE, DELETE, INSERT statements from the delta files and run it daily to update DB2 tables. We use CDC to upload data from DB2 tables on the cloud. We have at most few 1000s rows a day to update so this method works for us. Initially, you have to create table and rows in DB2 to match that of IMS.

    John




  • 4.  RE: IBM Tools that can migrate IMS DB to DB2

    Posted 30 days ago

    Hi, 

    Besides CDC based approach, there are other alternatives too. 

    • This is an old solution for IMS to Db2 for z/OS Migration. Please check the details from here
      • https://www.precisely.com/product/precisely-syncsort/syncsort-optimize-ims 
        In 1990s, it was called DL/2 and was owned by a UK company, These days it is owned by Precisely.
    • IBM Data Virtualization Manager for z/OS https://www.ibm.com/products/data-virtualization-manager-for-zos?   also helps any IMS to Db2 for z/OS
      migration project.

    Best Regards, 

    Mehmet Cuneyt Goksu, PhD
    Executive IT Specialist@CoE
    IBM Liaison for Db2 for z/OS@IDUG BOD&EMEA
    Data and AI on Z
    +49 173 3943384 mobile
    mehmet.goksu@ibm.com



    ------------------------------
    MEHMET CUNEYT GOKSU
    ------------------------------