unresolved error holds - how to investigate

Chris Hoelscher

unresolved error holds - how to investigate

Db2 r11 nfm z/os

We generally only pull in recommended service (RSU) - when applying, I get lots (20+) of ptfs that cannot be applies because it or a prereq has an error hold that has not been resolved - running a errsysmods REPORT CONFIRMA THAT THERE IS NO RESOLVING FIOXES FOR THERE ERROR HOPLDS (YES - I PULL IN HOPLDDATA BEFORE every PTF RECEIVE)

My question is - where do I find an explanation of what the error is that caused error hold AIxxxxx to be placed? I can see the entry as an attribute of the sysmod it was assigned to, but I would like to see any details - in other words - I want to know of the error is not relevant to us, so that I can selectively bypass error holds and allow the plethora of ptfs held up by the error hold to be applied ...

Thanks for any light you can ashine

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: cid:[login to unmask email]: humana.com
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 714-8615, (502) 476-2538


The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.
Attachments

  • image001.jpg (2.9k)
  • image003.jpg (<1k)

Jim Tonchick

unresolved error holds - how to investigate
(in response to Chris Hoelscher)

Along with the ERRORSYSMODS, I suggest that you also add MISSING FIX. This will generate a RECEIVE statement with all the PTFs available that resolve any held PTFs.
<span style="font-size: 16px;">
</span>
<span style="font-size: 16px;">In our shop, we run a weekly RECEIVE RECOMMENDED for each major software product. This way we will most likely have the fix in house should a problem occur between RSU apply cycles.</span>
<span style="font-size: 16px;">
</span>
<span style="font-size: 16px;">If you want to see the error description for a specific APAR, just search the number on the IBM support site. You can then decide if it needs your attention or not.
</span>
-----Original Message-----
From: Chris Hoelscher <[login to unmask email]>
To: [login to unmask email] ([login to unmask email]) <[login to unmask email]>
Sent: Tue, Jan 10, 2017 10:44 PM
Subject: [DB2-L] - unresolved error holds - how to investigate



<div id="AOLMsgPart_1.2_2724b71e-5f73-480c-9682-5b93994fc33b">
<style scoped="">#AOLMsgPart_1.2_2724b71e-5f73-480c-9682-5b93994fc33b td{color: black;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;}@font-face {font-family:"Comic Sans MS"; panose-1:3 15 7 2 3 3 2 2 2 4;}@font-face {font-family:"sans serif";}.aolReplacedBody p.aolmail_MsoNormal,.aolReplacedBody li.aolmail_MsoNormal,.aolReplacedBody div.aolmail_MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"sans serif"; color:black; mso-believe-normal-left:yes;}.aolReplacedBody a:link,.aolReplacedBody span.aolmail_MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;}.aolReplacedBody a:visited,.aolReplacedBody span.aolmail_MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;}.aolReplacedBody p.aolmail_MsoAcetate,.aolReplacedBody li.aolmail_MsoAcetate,.aolReplacedBody div.aolmail_MsoAcetate {mso-style-priority:99; mso-style-link:"Balloon Text Char"; margin:0in; margin-bottom:.0001pt; font-size:8.0pt; font-family:"Tahoma","sans-serif"; color:black;}.aolReplacedBody span.aolmail_EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri","sans-serif"; color:windowtext;}.aolReplacedBody span.aolmail_BalloonTextChar {mso-style-name:"Balloon Text Char"; mso-style-priority:99; mso-style-link:"Balloon Text"; font-family:"Tahoma","sans-serif"; color:black;}.aolReplacedBody .aolmail_MsoChpDefault {mso-style-type:export-only; font-family:"Calibri","sans-serif";}@page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;}.aolReplacedBody div.aolmail_WordSection1 {page:WordSection1;}</style><style scoped="">#AOLMsgPart_1.2_2724b71e-5f73-480c-9682-5b93994fc33b td{color: black;} .aolReplacedBody p.aolmail_MsoNormal {margin-left:37.5pt;}</style><div bgcolor="white" lang="EN-US" style="margin-left:37.5pt" class="aolReplacedBody">
<img width="0" height="0" class="aolmail_shape" style="display:none;width:0;height:0">
<div class="aolmail_WordSection1">
<p class="aolmail_MsoNormal"><span style="font-size:9.0pt;font-family:"Calibri","sans-serif";color:windowtext">Db2 r11 nfm z/os</span></p>
<p class="aolmail_MsoNormal"><span style="font-size:9.0pt;font-family:"Calibri","sans-serif";color:windowtext"> </span></p>
<p class="aolmail_MsoNormal"><span style="font-size:9.0pt;font-family:"Calibri","sans-serif";color:windowtext">We generally only pull in recommended service (RSU) – when applying, I get lots (20+) of ptfs that cannot be applies because it or a prereq has an error hold
that has not been resolved – running a errsysmods REPORT CONFIRMA THAT THERE IS NO RESOLVING FIOXES FOR THERE ERROR HOPLDS (YES – I PULL IN HOPLDDATA BEFORE every PTF RECEIVE)</span></p>
<p class="aolmail_MsoNormal"><span style="font-size:9.0pt;font-family:"Calibri","sans-serif";color:windowtext"> </span></p>
<p class="aolmail_MsoNormal"><span style="font-size:9.0pt;font-family:"Calibri","sans-serif";color:windowtext">My question is – where do I find an explanation of what the error is that caused error hold AIxxxxx to be placed? I can see the entry as an attribute of the
sysmod it was assigned to, but I would like to see any details – in other words – I want to know of the error is not relevant to us, so that I can selectively bypass error holds and allow the plethora of ptfs held up by the error hold to be applied …</span></p>
<p class="aolmail_MsoNormal"><span style="font-size:9.0pt;font-family:"Calibri","sans-serif";color:windowtext"> </span></p>
<p class="aolmail_MsoNormal"><span style="font-size:9.0pt;font-family:"Calibri","sans-serif";color:windowtext">Thanks for any light you can ashine</span></p>
<p class="aolmail_MsoNormal"><span style="font-size:9.0pt;font-family:"Calibri","sans-serif";color:windowtext"> </span></p>
<div>
<p class="aolmail_MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:#5C9A1B">Chris Hoelscher</span></b></p>
<p class="aolmail_MsoNormal" style="text-autospace:none"><b><i><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:#5C9A1B">Technology Architect, Database Infrastructure Services</span></i></b></p>
<p class="aolmail_MsoNormal" style="text-autospace:none"><b><i><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:#5C9A1B">Technology Solution Services</span></i></b></p>
<p class="aolmail_MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:#1F497D"><img width="54" height="14" id="aolmail_Picture_x0020_1" alt="Description: cid:[login to unmask email]">:
humana.com</span><b><i><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:#5C9A1B"></span></i></b></p>
<p class="aolmail_MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:windowtext">123 East Main Street</span></b></p>
<p class="aolmail_MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:windowtext">Louisville, KY 40202</span></b></p>
<p class="aolmail_MsoNormal"><b><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:windowtext">Humana.com</span></b></p>
<p class="aolmail_MsoNormal"><b><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:windowtext">(502) 714-8615, (502) 476-2538</span></b></p>

<p class="aolmail_MsoNormal"> </p>
</div>
<br clear="both">
The information transmitted is intended only for the person or entity to which it is addressed

and may contain CONFIDENTIAL material. If you receive this material/information in error,

please contact the sender and delete or destroy the material/information.


<hr size="1" style="color:#ccc"><div id="aolmail_socfooter" style="font-size:80%"><span style="font-weight:bold">Attachment Links: </span>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/do/download=1&fid=7733">image001.jpg (3 k)</a>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/do/download=1&fid=7734">image003.jpg (1 k)</a>


<span style="font-weight:bold">Site Links: </span>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/st/post=179638&anc=p179638#p179638">View post online</a>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/si/topic=19">View mailing list online</a>
<a target="_blank" rel="noopener noreferrer" href="mailto:[login to unmask email]">Start new thread via email</a>
<a target="_blank" rel="noopener noreferrer" href="mailto:[login to unmask email]?Subject=Unsubscribe">Unsubscribe from this mailing list</a>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/us/to/">Manage your subscription</a>


This email has been sent to: <a href="mailto:[login to unmask email]">[login to unmask email]</a>
<p>
** ** ** Attend the 2017 IDUG Tech Conference North America ** ** **

---> Anaheim, California, April 30 - May 04, 2017 <---

<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/na">http://www.idug.org/na</a>

</p>
<p>
Use of this email content is governed by the terms of service at:
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/cm/ld/fid=2">http://www.idug.org/p/cm/ld/fid=2</a></p>

</div><hr size="1" style="color:#ccc">

</div>
</div>
</div>

Venkat Srinivasan

RE: unresolved error holds - how to investigate
(in response to Chris Hoelscher)

Do not bypass error hold (bypass hold error) unless you get such an advise from the developer who is responsible for the fix. Instead use exclude to exlude the sysmod (s).

When in need (usually I don't find a need to apply a fix that may be in error) I look at the Causer sysmod summary report and manually read the PTF cover in IBM website. Usually google will lead me right into the cover letter. Rarely if it is a brand new item you will get a sign in prompt in which case that information is not yet available as public readable material.

Consciously I refuse to apply anything recent / new. If I apply RSU I look for any hipers that may have come in after the RSU level where fixes are marked data loss / function loss / recovery failures and review if I need to take them along. I ignore / don't bother about incorouts / performance tags marked after the RSU level.   

Venkat
 
In Reply to Chris Hoelscher:


Db2 r11 nfm z/os

We generally only pull in recommended service (RSU) - when applying, I get lots (20+) of ptfs that cannot be applies because it or a prereq has an error hold that has not been resolved - running a errsysmods REPORT CONFIRMA THAT THERE IS NO RESOLVING FIOXES FOR THERE ERROR HOPLDS (YES - I PULL IN HOPLDDATA BEFORE every PTF RECEIVE)

My question is - where do I find an explanation of what the error is that caused error hold AIxxxxx to be placed? I can see the entry as an attribute of the sysmod it was assigned to, but I would like to see any details - in other words - I want to know of the error is not relevant to us, so that I can selectively bypass error holds and allow the plethora of ptfs held up by the error hold to be applied ...

Thanks for any light you can ashine

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: cid:[login to unmask email]: humana.com
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 714-8615, (502) 476-2538


The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.