Db2 - L

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

Original Message:
Sent: 6/22/2022 4:18:00 AM
From: Emil Kotrc
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: 6/22/2022 9:19:00 AM
From: Mark Vickers
Subject: RE: Db2 13 migration - AHA idea for the fallback SPE

Emil,

The AHA link does not work.

 

Thanks,

Mark.

 

Original Message:
Sent: 6/22/2022 4:18:00 AM
From: Emil Kotrc
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

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

Original Message:
Sent: Jun 22, 2022 09:39 AM
From: Emil Kotrc
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: 6/22/2022 9:19:00 AM
From: Mark Vickers
Subject: RE: Db2 13 migration - AHA idea for the fallback SPE

Emil,

The AHA link does not work.

 

Thanks,

Mark.

 

Original Message:
Sent: 6/22/2022 4:18:00 AM
From: Emil Kotrc
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

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

Original Message:
Sent: Jun 22, 2022 09:39 AM
From: Emil Kotrc
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: 6/22/2022 9:19:00 AM
From: Mark Vickers
Subject: RE: Db2 13 migration - AHA idea for the fallback SPE

Emil,

The AHA link does not work.

 

Thanks,

Mark.

 

Original Message:
Sent: 6/22/2022 4:18:00 AM
From: Emil Kotrc
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

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

Original Message:
Sent: Jun 22, 2022 09:39 AM
From: Emil Kotrc
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: 6/22/2022 9:19:00 AM
From: Mark Vickers
Subject: RE: Db2 13 migration - AHA idea for the fallback SPE

Emil,

The AHA link does not work.

 

Thanks,

Mark.

 

Original Message:
Sent: 6/22/2022 4:18:00 AM
From: Emil Kotrc
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

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

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

Original Message:
Sent: Jun 23, 2022 12:26 AM
From: James Campbell
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

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

Original Message:
Sent: Jun 23, 2022 03:19 AM
From: Steven Lamb
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: Jun 23, 2022 12:26 AM
From: James Campbell
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

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


Original Message:
Sent: 6/23/2022 4:46:00 AM
From: Emil Kotrc
Subject: RE: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: Jun 23, 2022 03:19 AM
From: Steven Lamb
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: Jun 23, 2022 12:26 AM
From: James Campbell
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: 6/23/2022 6:18:00 AM
From: Roy Boxwell
Subject: RE: Db2 13 migration - AHA idea for the fallback SPE

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


Original Message:
Sent: 6/23/2022 4:46:00 AM
From: Emil Kotrc
Subject: RE: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: Jun 23, 2022 03:19 AM
From: Steven Lamb
Subject: Db2 13 migration - AHA idea for the fallback SPE

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

Original Message:
Sent: Jun 23, 2022 12:26 AM
From: James Campbell
Subject: Db2 13 migration - AHA idea for the fallback SPE

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