DB2 z/OS - PTF HOLD actions

Mike Martin

DB2 z/OS - PTF HOLD actions
Hi all,

We have had DB2 z/OS V11 in our sandbox (for a good while) and are preparing to upgrade our V10 subsystems. Before we migrate our V10 subsystems to V11, we want to apply current V11 maintenance (HIPERs and RSUs) in our sandbox. (we do have fallback maint. on V10)

After doing several APPLY CHECKS, we realized there are a ton of HOLDs for the V11 maint. These HOLDs should only affect our existing sandbox V11 subsystem, right?

In other words, should we have to worry about how the HOLDs affect our existing V10 subsystems before/after the migration?

(as I typed this, I think the answer started coming to me, but any feedback is greatly appreciated)

Mike Martin
This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

Lizette Koehler

DB2 z/OS - PTF HOLD actions
(in response to Mike Martin)
I would start with running FIXCAT report in SMP/E to see what is on/rec/needed



Second, have the z/OS Sysprog do the same thing for DB2. Sometimes there are
fixes for in z/os for DB2



Lizette



From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 8:01 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2 z/OS - PTF HOLD actions



Hi all,



We have had DB2 z/OS V11 in our sandbox (for a good while) and are preparing to
upgrade our V10 subsystems. Before we migrate our V10 subsystems to V11, we
want to apply current V11 maintenance (HIPERs and RSUs) in our sandbox. (we do
have fallback maint. on V10)



After doing several APPLY CHECKS, we realized there are a ton of HOLDs for the
V11 maint. These HOLDs should only affect our existing sandbox V11 subsystem,
right?



In other words, should we have to worry about how the HOLDs affect our existing
V10 subsystems before/after the migration?



(as I typed this, I think the answer started coming to me, but any feedback is
greatly appreciated)



Mike Martin

This email may contain confidential and privileged material for the sole use of
the intended recipient. If you are not the intended recipient, please contact
the sender and delete all copies. Any review or distribution by others is
strictly prohibited. Personal emails are restricted by policy of the State
Employees' Credit Union (SECU). Therefore SECU specifically disclaims any
responsibility or liability for any personal information or opinions of the
author expressed in this email.



-----End Original Message-----

Mike Martin

DB2 z/OS - PTF HOLD actions
(in response to Lizette Koehler)
Thanks Lizette,

Maybe I didn't state my question correctly. The question has to do with performing tasks related to HOLDs (actions primarily).

Mike Martin


From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 11:14 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS - PTF HOLD actions

I would start with running FIXCAT report in SMP/E to see what is on/rec/needed

Second, have the z/OS Sysprog do the same thing for DB2. Sometimes there are fixes for in z/os for DB2

Lizette

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 8:01 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS - PTF HOLD actions

Hi all,

We have had DB2 z/OS V11 in our sandbox (for a good while) and are preparing to upgrade our V10 subsystems. Before we migrate our V10 subsystems to V11, we want to apply current V11 maintenance (HIPERs and RSUs) in our sandbox. (we do have fallback maint. on V10)

After doing several APPLY CHECKS, we realized there are a ton of HOLDs for the V11 maint. These HOLDs should only affect our existing sandbox V11 subsystem, right?

In other words, should we have to worry about how the HOLDs affect our existing V10 subsystems before/after the migration?

(as I typed this, I think the answer started coming to me, but any feedback is greatly appreciated)

Mike Martin

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----

-----End Original Message-----
This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

George Palko

DB2 z/OS - PTF HOLD actions
(in response to Mike Martin)
Mike,

Without knowing the specifics, I would not think that the v11 maintenance would impact the v10 version. I've never put maintenance on one version which had a negative impact on another version. Of course we keep separate CSI's which I'm sure you're doing. So, you should be fine Mike.

George

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 12:43 PM
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2 z/OS - PTF HOLD actions

Thanks Lizette,

Maybe I didn't state my question correctly. The question has to do with performing tasks related to HOLDs (actions primarily).

Mike Martin


From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 11:14 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 z/OS - PTF HOLD actions

I would start with running FIXCAT report in SMP/E to see what is on/rec/needed

Second, have the z/OS Sysprog do the same thing for DB2. Sometimes there are fixes for in z/os for DB2

Lizette

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 8:01 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS - PTF HOLD actions

Hi all,

We have had DB2 z/OS V11 in our sandbox (for a good while) and are preparing to upgrade our V10 subsystems. Before we migrate our V10 subsystems to V11, we want to apply current V11 maintenance (HIPERs and RSUs) in our sandbox. (we do have fallback maint. on V10)

After doing several APPLY CHECKS, we realized there are a ton of HOLDs for the V11 maint. These HOLDs should only affect our existing sandbox V11 subsystem, right?

In other words, should we have to worry about how the HOLDs affect our existing V10 subsystems before/after the migration?

(as I typed this, I think the answer started coming to me, but any feedback is greatly appreciated)

Mike Martin

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----

-----End Original Message-----

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----


-----------------------------------------

CONFIDENTIALITY NOTICE: The Ohio Public Employees Retirement System intends this e-mail message, and any attachments, to be used only by the person(s) or entity to which it is addressed. This message may contain confidential and/or legally privileged information. If the reader is not the intended recipient of this message or an employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that you are prohibited from printing, copying, storing, disseminating or distributing this communication. If you received this communication in error, please delete it from your computer and notify the sender by reply e-mail.

Lizette Koehler

DB2 z/OS - PTF HOLD actions
(in response to Mike Martin)
Typically, I read every HOLD data and see if it applies to my shop.



General rule of thumb





Install fixes for compatibility for newer versions.



Make sure the HOLD DATA Is retrieve before running APPLY CHECK







If there are fixes for a more current version of DB2 than what I am running,
then I run the FIXCAT process and see what it says. FIXCAT augments my APPLY
Check process.



Some fixes are for compatibility, and probably okay to install. Some might not
be. Should you do this, check your NON IBM Products for compatibility with
these types of PTFs. For example, CA DB2 Tools. If PTF X for IBM Compatibility
for V11, then see if CA DB2 Tools needs a similar PTF to support that
compatibility update in IBM PTF X.





If you are planning to go to V11, then put on any compatibility PTFs. Those
should be the safest ones.





Lizette





From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 9:43 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS - PTF HOLD actions



Thanks Lizette,



Maybe I didn't state my question correctly. The question has to do with
performing tasks related to HOLDs (actions primarily).



Mike Martin





From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 11:14 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 z/OS - PTF HOLD actions



I would start with running FIXCAT report in SMP/E to see what is on/rec/needed



Second, have the z/OS Sysprog do the same thing for DB2. Sometimes there are
fixes for in z/os for DB2



Lizette



From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 8:01 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS - PTF HOLD actions



Hi all,



We have had DB2 z/OS V11 in our sandbox (for a good while) and are preparing to
upgrade our V10 subsystems. Before we migrate our V10 subsystems to V11, we
want to apply current V11 maintenance (HIPERs and RSUs) in our sandbox. (we do
have fallback maint. on V10)



After doing several APPLY CHECKS, we realized there are a ton of HOLDs for the
V11 maint. These HOLDs should only affect our existing sandbox V11 subsystem,
right?



In other words, should we have to worry about how the HOLDs affect our existing
V10 subsystems before/after the migration?



(as I typed this, I think the answer started coming to me, but any feedback is
greatly appreciated)



Mike Martin

This email may contain confidential and privileged material for the sole use of
the intended recipient. If you are not the intended recipient, please contact
the sender and delete all copies. Any review or distribution by others is
strictly prohibited. Personal emails are restricted by policy of the State
Employees' Credit Union (SECU). Therefore SECU specifically disclaims any
responsibility or liability for any personal information or opinions of the
author expressed in this email.



-----End Original Message-----



-----End Original Message-----

This email may contain confidential and privileged material for the sole use of
the intended recipient. If you are not the intended recipient, please contact
the sender and delete all copies. Any review or distribution by others is
strictly prohibited. Personal emails are restricted by policy of the State
Employees' Credit Union (SECU). Therefore SECU specifically disclaims any
responsibility or liability for any personal information or opinions of the
author expressed in this email.



-----End Original Message-----

Mike Martin

DB2 z/OS - PTF HOLD actions
(in response to George Palko)
Thanks George,

We just got finished dealing with a ton of HOLD actions when we did the V10 fallback maint.

When we went back to working on V11, I didn’t want to go through a ton of HOLDs again. Then, I convinced myself that the V11 HOLD actions shouldn’t cause us any additional work migrating our V10 subsystems. (it seems so obvious now when I type it ☺)

Mike

From: Palko, George [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 1:14 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS - PTF HOLD actions

Mike,

Without knowing the specifics, I would not think that the v11 maintenance would impact the v10 version. I’ve never put maintenance on one version which had a negative impact on another version. Of course we keep separate CSI’s which I’m sure you’re doing. So, you should be fine Mike.

George

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 12:43 PM
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2 z/OS - PTF HOLD actions

Thanks Lizette,

Maybe I didn’t state my question correctly. The question has to do with performing tasks related to HOLDs (actions primarily).

Mike Martin


From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 11:14 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 z/OS - PTF HOLD actions

I would start with running FIXCAT report in SMP/E to see what is on/rec/needed

Second, have the z/OS Sysprog do the same thing for DB2. Sometimes there are fixes for in z/os for DB2

Lizette

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Wednesday, August 02, 2017 8:01 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS - PTF HOLD actions

Hi all,

We have had DB2 z/OS V11 in our sandbox (for a good while) and are preparing to upgrade our V10 subsystems. Before we migrate our V10 subsystems to V11, we want to apply current V11 maintenance (HIPERs and RSUs) in our sandbox. (we do have fallback maint. on V10)

After doing several APPLY CHECKS, we realized there are a ton of HOLDs for the V11 maint. These HOLDs should only affect our existing sandbox V11 subsystem, right?

In other words, should we have to worry about how the HOLDs affect our existing V10 subsystems before/after the migration?

(as I typed this, I think the answer started coming to me, but any feedback is greatly appreciated)

Mike Martin

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----

-----End Original Message-----

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----
________________________________
-----------------------------------------
CONFIDENTIALITY NOTICE: The Ohio Public Employees Retirement System intends this e-mail message, and any attachments, to be used only by the person(s) or entity to which it is addressed. This message may contain confidential and/or legally privileged information. If the reader is not the intended recipient of this message or an employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that you are prohibited from printing, copying, storing, disseminating or distributing this communication. If you received this communication in error, please delete it from your computer and notify the sender by reply e-mail.

-----End Original Message-----
This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

Roy Boxwell

DB2 z/OS - PTF HOLD actions
(in response to Mike Martin)
I read and do all the HOLD actions... sometimes it takes "a while"...

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de

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

On 2 Aug 2017, at 17:10, MARTIN, MIKE <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi all,

We have had DB2 z/OS V11 in our sandbox (for a good while) and are preparing to upgrade our V10 subsystems. Before we migrate our V10 subsystems to V11, we want to apply current V11 maintenance (HIPERs and RSUs) in our sandbox. (we do have fallback maint. on V10)

After doing several APPLY CHECKS, we realized there are a ton of HOLDs for the V11 maint. These HOLDs should only affect our existing sandbox V11 subsystem, right?

In other words, should we have to worry about how the HOLDs affect our existing V10 subsystems before/after the migration?

(as I typed this, I think the answer started coming to me, but any feedback is greatly appreciated)

Mike Martin

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----

Joe Hartmann

RE: DB2 z/OS - PTF HOLD actions
(in response to Mike Martin)

Mike

Most of your holds actions will be taken care of during the upgrade process.  There are some actions that you would still have to do after the upgrade.  I just put maintenance on our v11 system and there was a catmaint job to run.  This would not be included in jobs you run to migrate. 

Joe

Mike Martin

DB2 z/OS - PTF HOLD actions
(in response to Joe Hartmann)
Thanks Joe,

That makes perfect sense. I just needed a little reassurance since this is our first DB2 z/OS upgrade. Thanks!

Mike Martin

From: Joe Hartmann [mailto:[login to unmask email]
Sent: Thursday, August 03, 2017 7:57 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS - PTF HOLD actions


Mike

Most of your holds actions will be taken care of during the upgrade process. There are some actions that you would still have to do after the upgrade. I just put maintenance on our v11 system and there was a catmaint job to run. This would not be included in jobs you run to migrate.

Joe

-----End Original Message-----
This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

Avram Friedman

RE: DB2 z/OS - PTF HOLD actions
(in response to Mike Martin)

This is how I handle ptfs with associated actions in a preventive time apply.

First and foremost I do not read the cover letters.

I have supported DB2 since before first customer ship, I am the father of several DB2 products including omegamon DB2

I don't understand the ptf cover letters.  I work in terms of software functions like dist, sql, data sharing but the ptfs are written in terms of module and from a corrective view point.  Not a mass preventive apply

2 if you are installing or migrating to a version of DB2 for the first time and have not run the insulation CLIST there is nothing special to do just follow the install process

#2 provides a hint as to what to do with a preventive service

Run a fake installation CLIST for an install or migration

This will rebuild a copy of of all the installation jobs

Update runtimes and restart DB2

Run new.sdsnsamp.fake(dsntijpm) in install mode

This will run the system binds, rebuild system tables etc

 

Run out of the fake dataset builds and binds for the samples you use

And packages usually need to be redone as well as other system level add ons.

Do not look to see what needs it. Just do it

Avram Friedman
DB2-L hall of fame contributer
DB2-L acting administrator

[login to unmask email]