Db2 for z/OS & Db2ZAI

Db2 for z/OS and its ecosystem

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14

    Posted 3 days ago

    Estamos tentando fazer uma migração de de um DB2 v8 para um Db2 V12. Alguém conhece o step-by-step? 



    ------------------------------
    Valter Da Cruz
    ------------------------------


  • 2.  RE: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14

    Posted 2 days ago

    I fear you have a lot of pain in front of you... Firstly the only way is to install and migrate to Db2 9, 10, 11 and then 12. This is a problem as you cannot order Db2 9, 10 or 11 anymore. The next way would be to install Db2 12 and "copy everything over" This is not possible as the Db2 ERLY code is -2 and +1 tolerant so you cannot even start both Db2s in the same LPAR. Extracting all DDL, Image Copying all user data, extracting all DBRMs and then attenmpting to recreate in Db2 is dangerous due to various problems with "deprecated" items that you can no longer even create in Db2 12. Basically I would call IBM and ask for help!  

    Good luck!



    ------------------------------
    Roy Boxwell
    Senior Software Architect
    Software Engineering GmbH
    Duesseldorf
    +4921196149675
    ------------------------------

    Original Message


  • 3.  RE: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14

    Posted 2 days ago

    As my esteemed colleague has said, be prepared for pain. However, BMC provides pain-killers in the shape of Change Manager and CM/Pilot to help you on your migration journey. Other vendors provide similar tools that do similar functions. Either way, tools will probably help. But as Roy suggested, PLEASE consult IBM.

     

    Regards,

    Marcus Davage CEng CITP MBCS

    Lead Product Developer
    Intelligent Z Optimization and Transformation
    BMC Software Ltd
    Direct +44 118 921 8517
    Mobile +44 7840 023 560
    Email marcus_davage@bmc.com

    MarcusDavage@bmcsoftware.onmicrosoft.com/bookings/">Book time to meet with me

    My Digital Pin IBM Champion 2025 badge image. Experience. Advanced level. Issued by IBM

     




    Original Message


  • 4.  RE: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14

    Posted yesterday

    I agree with a lot of what Roy has stated. I will add that the Install Db2 13 and "copy everything over" method has worked for several customers recently. They actually started from DB2 version 7. To do this they had to be ultra prepared and they had planned well over a year to do it, etc. So it IS possible.

    Why would you want to go to Db2 12 vs Db2 13 since Db2 12 is going out of service soon? Is that because you could then just migrate from Db2 12 to Db2 13 at the end of the year? Assuming you got everything planned and tested properly, I'd recommend getting to Db2 13.



    ------------------------------
    John R Lyle
    ------------------------------

    Original Message


  • 5.  RE: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14

    Posted 11 hours ago

    Hello John, the copy of data can be a hard job, but still manageable. Although, I have my doubts about stored procs, plans and specially packages. Do you have experience on that?



    ------------------------------
    Ellen França
    Sr. Db2 System Programmer
    Kyndryl
    Czech Republic
    ------------------------------

    Original Message


  • 6.  RE: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14

    Posted 2 days ago

    Olá Valter,

    It's possible to skip V9, but you would still need to go V8 > V10 > V11 > V12.... the most critical part would be for application DBAs to check every incompatibility on all those versions (including V9) and possible fallback scenarios. Concerning the code, I would contact IBM support to see what are the options. If your customer have contract with GSD, is still possible to request older versions though.

    There was a recent presentation from IBM lab that many customers are going from V11 > V12 > V13 where you wouldn't need to wait on each phase (CM/NFM or Function Levels). As all those phases are pretty stable for previous versions.

    So, considering you are on DB2 V8 NFM, you would plan something on those lines:

    • V8 NFM > V10 CM
    • V10 CM > V10NFM > V11 CM
    • V11 CM >V11 NFM > V12 FL100.
    • Think about testing and possible fallback, because there are phases that you cannot fallback to previous version anymore.
    • Application compatibilities, customer needs to make sure their applications continues to behave as expected and that they might need some modifications
    • Also consider compatibilities with z/OS versions and other products/tools that connects to DB2 on each phase, you may need to also upgrade those (possibly more than once) to keep up with the Db2 version

    Boa sorte :)

    Ellen França



    ------------------------------
    Ellen França
    ------------------------------

    Original Message


  • 7.  RE: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14

    Posted 2 days ago

    Olá Valter - Please reach out to me directly at rmruppel@us.ibm.com.  This will be challenging - as others have described - but I think we can work with the right people to help get you where you need to be.



    ------------------------------
    RICHARD RUPPEL
    Principal Brand Technical Specialist
    Data and AI for IBM Z
    IBM
    ------------------------------

    Original Message


  • 8.  RE: Upgrade IBM DB2 V8 to IBM Db2 V12 running under z/OS 2.4 on Z14

    Posted yesterday

    Why not go to Db2 13?  Db2 12 will be out of support in 7 months - and since you are going through the pain why not get to a landing place where you will have some years to recover.

    As others have mentioned, the -> 10CM -> 10NFM -> 11CM -> 11NFM -> 12FL100 -> 12FL500 -> 12FL510 -> 13 is longer but simpler.  Getting the 10 and 11 code will be the problem.

    Assuming you go for the great leap forward:  

    • if you try to run DB2 V8 and Db2 xx on the same machine, try to get hold of the DB2 9 or DB2 10 Early Code.  These support DB2 V8 and support the EARLY,REFRESH command.  So you can bounce the Early Code depending on which DB2 version you are going to start.  (With, of course, LLA REFRESH.) Each time you do so, check the message with the PTF codes to ensure you have actually started the one you want.

    • If you cannot get those early code, you'll have to use the V8 early code in IEFSSN, and dynamically add the V12/13 SSN information to bring up the V12/13 subsystem.. 

    • I did a V7->V10 leap.  I copied tablespaces and indexes using DSN1COPY changing the IDs along the way.  Also converted the one simple tablespace I had to segmented I started.
    • Otherwise it is unload / reload.
    • Remote bind copy to deliver packages to the new subsystem
    • Lots of fun.  I was very glad when it was over. 

    Get all the help you can from your tool vendor(s) and IBM.



    ------------------------------
    James Campbell
    ------------------------------

    Original Message


Related Content