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
Back to discussions
Expand all | Collapse all

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

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

    Posted 23 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 23 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 22 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 21 days ago

    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 21 days 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

    Our customer already DB2 V12 installed and running on z14 z/os 2.4! So they want to migrate firstly to V12. Now their production environment running on z114 z/os 1.9.



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

    Original Message


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

    Posted 22 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


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

    Posted 22 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


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

    Posted 21 days ago

    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


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

    Posted 2 days ago

    I am a Japanese Db2 engineer and have migrated from V8 to V12. I hardened the v12 subsystem to a new machine, unloaded the V8 Db2 catalog, and used EXCEL to generate the DDL. After creating the same environment as V8 in the V12 environment, I unloaded/loaded the data from V8 to V12. For more details, please ask a Japanese company called SCSK. I think it will be the same for V13, not V12.



    ------------------------------
    Kingo Saito KING
    Senior Constaltant
    Twinz Co., Ltd
    Matsudo
    +81(47)361-7309
    ------------------------------

    Original Message


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

    Posted 2 days ago

    I am a Japanese Db2 engineer and have migrated from V8 to V12. I hardened the v12 subsystem to a new machine, unloaded the V8 Db2 catalog, and used EXCEL to generate the DDL. After creating the same environment as V8 in the V12 environment, I unloaded/loaded the data from V8 to V12. For more details, please ask a Japanese company called SCSK. I think it will be the same for V13, not V12.



    ------------------------------
    Kingo Saito KING
    Senior Constaltant
    Twinz Co., Ltd
    Matsudo
    +81(47)361-7309
    ------------------------------

    Original Message


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

    Posted 2 days ago

    Hi Kingo, curious as to why the V8 catalog was unloaded as it cannot be loaded into another catalog. I'm assuming it was used as input to the EXCEL process to generate the necessary user object DDL? And for creating the same environment in V12.....I assume that means you did a brand new V12 install? Just making sure I understand your process. Glad it worked for you. 



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

    Original Message


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

    Posted 2 days ago
    Edited by Kingo Saito 2 days ago

    Hi John, Sorry, it was over a year ago, so I can't quite remember, but the client I was working with had poor DDL management, so I unloaded the data from the DB2 catalog in V8 and generated the DDL using Excel functions. The main DDL I generated was the following:

    -　GRANT DBADM
    -    GRANT TABLE
    -    GRANT USER
    -    GRANT PLAN
    -    CREATE STOGROUP
    -    CREATE DATABASE
    -    CREATE ALIAS (instead of SYNONYMS)
    -    BIND PLAN
    -    BIND PACKAGE

    The difficult part was to verify that the timestamps of the PACKAGE DBRM objects and the LOAD modules matched.
    An SCSK system engineer created a program in ASSEMBLER to extract the TIMESTAMPs from the DBRM and LOAD modules.

    I'm not familiar with BMC's Change Manager and CM/Pilot, but I think it would be more reliable to use a product that provides support.

    ------------------------------
    Kingo Saito KING
    Senior Constaltant
    Twinz Co., Ltd
    Matsudo
    +81(47)361-7309
    ------------------------------

    Original Message


Related Content