Db2 - L

 View Only
  • 1.  Db2 13 migration - AHA idea for the fallback SPE

    Posted 7 days ago
    Edited by Emil Kotrc 7 days ago
    Hi all,
    if you are planning to migrate to Db2 13 you need to be at FL V12R1M510. However, you also need the fallback SPE PH37108 https://www.ibm.com/support/pages/apar/PH37108, but there is no indication you have it installed. I've opened this Aha idea https://ibm-data-and-ai.ideas.ibm.com/ideas/DB24ZOS-I-1376 . Please vote for it if you like it.

    Thanks,
    Emil.

    ------------------------------
    Emil Kotrc
    Broadcom
    ------------------------------


  • 2.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 7 days ago

    Emil,

    The AHA link does not work.

     

    Thanks,

    Mark.

     






  • 3.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 7 days ago
    Sorry for the broken link (ending dot), please use this one https://ibm-data-and-ai.ideas.ibm.com/ideas/DB24ZOS-I-1376






  • 4.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 7 days ago
    What do you mean when you say "no indication" ?
    PH37108 is associated with PTF UI79956 you need to check if this is installed on your system or not .

    I ran report on missing ptfs on FIXCAT -IBM.Migrate-Fallback.DB2.V12 .  required PTF came up.



    Make sure you receive latest holddata before running report .


    Regards,
    Manoj K Jadwani



    ------------------------------
    ManojJadwaniTCS
    ------------------------------



  • 5.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 7 days ago
    Sure, but if I run Db2 from deployment libraries, I have no CSI available. Obtaining such information is then more challenging, because I need to go back in time when the copy has been made, review the outputs, check the state of SMP/E at that time, etc.  For me it would be much easier, if I can just simply ask Db2 itself if it is ready for the migration.

    Thanks,
    Emil.






  • 6.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 7 days ago
    I understand your pain. I have been there not long ago when I started supporting project with missing Db2 CSI.
    Good thing is we have atleast Db2 code level now we can guess/base maintenance level to the PTF that introduced it.

    But I am with you on this and will vote on the idea , IBM should give a module which compiles list of PTF that Db2 has and keeps on updating that module with each maintenance level something of this sort.

    Regards,
    Manoj K Jadwani

    ------------------------------
    ManojJadwaniTCS
    ------------------------------



  • 7.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 7 days ago
    Not Db2 13 yet. But ...

    In the past (pre Db2 13) each module had a prefix which contains the RMID (FMID or PTF
    which replaced the module). (I think this is what MEPL uses.) Try doing a seach on
    SDSNLOAD for one of the module names that UI79956 replaces (listed in the APAR text)
    and see what PTF last replaced it.

    James Campbell



    On 22 Jun 2022 at 16:01, Manoj Jadwani via Internation wrote:

    > I understand your pain. I have been there not long ago when I started supporting project with missing Db2 CSI.
    > Good thing is we have atleast Db2 code level now we can guess/base maintenance level to the PTF that introduced it.
    >
    > But I am with you on this and will vote on the idea , IBM should give a module which compiles list of PTF that Db2 has and keeps on updating that module with each maintenance level something of this sort.
    >
    > Regards,
    > Manoj K Jadwani
    >
    > ------------------------------
    > ManojJadwaniTCS
    > ------------------------------
    > -------------------------------------------
    > Original Message:
    > Sent: Jun 22, 2022 11:21 AM
    > From: Emil Kotrc
    > Subject: Db2 13 migration - AHA idea for the fallback SPE
    >
    > Sure, but if I run Db2 from deployment libraries, I have no CSI available. Obtaining such information is then more challenging, because I need to go back in time when the copy has been made, review the outputs, check the state of SMP/E at that time, etc. For me it would be much easier, if I can just simply ask Db2 itself if it is ready for the migration.
    > Thanks,Emil.
    >
    >
    >
    >
    > Original Message:
    > Sent: 6/22/2022 10:18:00 AM
    > From: Manoj Jadwani
    > Subject: RE: Db2 13 migration - AHA idea for the fallback SPE
    >
    > What do you mean when you say "no indication" ?
    > PH37108 is associated with PTF UI79956


  • 8.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 6 days ago

    We use MEPL and ISRSUPC with every DB2 maintenance rollout, comparing each system's runtime datasets against the SMP/E target stuff to ensure there's no mixup.  Makes things easy.

    Regards,

    Steve



    ------------------------------
    Steven Lamb
    ------------------------------



  • 9.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 6 days ago
    Thank you all for the hints and tips how you do that. Certainly, I could do all these things, the fallback SPE is not anything new, so the processes are likely in place already. However, Db2 13 already simplified the migration significantly in my opinion. Ideally, I would like to say that I am ready to go for migration if I activate M510, but still I need this small SPE. If there is a bit of information somewhere that tells me I have it installed, I would be sure I am ready ready and it would make life a bit easier ;-)

    Thanks,
    Emil.

    ------------------------------
    Emil Kotrc
    Broadcom
    ------------------------------



  • 10.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 6 days ago
    Voted!

    Roy Boxwell

    SOFTWARE ENGINEERING GmbH and SEGUS Inc.
    -Product Development-



    Vagedesstrasse 19
    40479 Dusseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email: R.Boxwell@seg.de
    Web http://www.seg.de
    Link zur Datenschutzerklärung

    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert, Ulf Heinrich




  • 11.  RE: Db2 13 migration - AHA idea for the fallback SPE

    Posted 6 days ago
    Thank you Roy!
    E.