DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions

Steven Lamb

DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions

We've just come across another downside of the new REORG_DROP_PBG_PARTS feature in DB2 11.

I was called out last Sunday at 2 am because of transaction abends in our production system - message DSNL028I with REASON=00E50013. It turns out that a Reorg job running with SHRLEVEL CHANGE cancelled the transactions to allow it to prune an empty partition from a PBG UTS. IBM have said "operating as designed".

The Utilities manual does indeed say "With ENABLE, during the UTILTERM phase, REORG cancels all claimers in order to drop the empty partitions, regardless of the value specified for the FORCE keyword."

I've just raised an RFE to ask for this behaviour to be changed - what's the point of having the benefits of SHRLEVEL CHANGE and then killing transactions anyway? Hopefully I've managed to make this public, so if you feel inclined to vote for it, it's at

https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=108987

 

Regards,
Steve

 

 

Ruediger Kurtz

AW: DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions
(in response to Steven Lamb)
Steve,

the Key-Symbol in front of your request indicates a private request …

Regards

Rüdiger


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas (stv.).
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Steven Lamb [mailto:[login to unmask email]
Gesendet: Freitag, 11. August 2017 14:00
An: [login to unmask email]
Betreff: [DB2-L] - DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions


We've just come across another downside of the new REORG_DROP_PBG_PARTS feature in DB2 11.

I was called out last Sunday at 2 am because of transaction abends in our production system - message DSNL028I with REASON=00E50013. It turns out that a Reorg job running with SHRLEVEL CHANGE cancelled the transactions to allow it to prune an empty partition from a PBG UTS. IBM have said "operating as designed".

The Utilities manual does indeed say "With ENABLE, during the UTILTERM phase, REORG cancels all claimers in order to drop the empty partitions, regardless of the value specified for the FORCE keyword."

I've just raised an RFE to ask for this behaviour to be changed - what's the point of having the benefits of SHRLEVEL CHANGE and then killing transactions anyway? Hopefully I've managed to make this public, so if you feel inclined to vote for it, it's at

https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=108987



Regards,
Steve





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

Steven Lamb

RE: AW: DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions
(in response to Ruediger Kurtz)

Hi Rüdiger,

I "think" I've made it public, but I don't know if it takes time for IBM to sort this part of the RFE out. It seems to be set to Private automatically, with a second flag to make it Public. :(

Steve

Ruediger Kurtz

AW: AW: DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions
(in response to Steven Lamb)
Steve,

thanks for pointing that out, but they haven’t sorted it out yet, will try later.

Best regards


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas (stv.).
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Steven Lamb [mailto:[login to unmask email]
Gesendet: Freitag, 11. August 2017 14:23
An: [login to unmask email]
Betreff: [DB2-L] - RE: AW: DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions


Hi Rüdiger,

I "think" I've made it public, but I don't know if it takes time for IBM to sort this part of the RFE out. It seems to be set to Private automatically, with a second flag to make it Public. :(

Steve

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

Andy Ai

RE: DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions
(in response to Steven Lamb)

Hi Steve

Thanks a lot for sharing this info. I have voted your RFE successfully. We are planning to deploy this but it appears that this is the showstopper for us.

Best regards

Andy

Andy Smith

RE: DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions
(in response to Steven Lamb)

Thanks for sharing this Steve.  We have this set to the default DISABLE due to one of our DBA's pointing out that we would be unable to RECOVER to a PIT prior to the pruning REORG.

P.S.  What are you doing still oncall?  It's a young man's game!!

Valerie Traurig

DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions
(in response to Steven Lamb)
But it is possible to have taken an image copy prior to the pruning and doing an unload from that copy and using that. It doesn't restore the pruned partitions, but you have your data at that point in time. However, you can't do log applies. Recovery is basically severely curtailed.
---------- Original Message ----------
From: Andy Smith <[login to unmask email]>
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions
Date: Wed, 16 Aug 2017 00:21:06 -0700 (MST)


Thanks for sharing this Steve. We have this set to the default DISABLE due to one of our DBA's pointing out that we would be unable to RECOVER to a PIT prior to the pruning REORG.
P.S. What are you doing still oncall? It's a young man's game!!

Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription

This email has been sent to: [login to unmask email] a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
ttp://www.ESAIGroup.com/idug

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

Steven Lamb

RE: DB2 z/OS REORG_DROP_PBG_PARTS cancels transactions
(in response to Andy Smith)

Our take on things is that in the vast majority of cases we would want to perform a Recover "to current", rather than to a point in time before the Reorg pruned partitions. It looks like we've had this Zparm set to ENABLE since we went to v11 18 months ago in prod, but this may have been the first time we've had transactions being cancelled as a result of it. We occasionally get "issues" with message handling suppressing things that shouldn't be suppressed, so I hope it's the first time it's happened! Somebody must have thought it was a good idea but wasn't aware of the potential consequences.

Hmm, I haven't checked the manual about this or tried it, but I assume the following will still work successfully.

1. You take a System Level Backup (BACKUP SYSTEM)

2. Run SHRLEVEL CHANGE REORGS, with PBG partition pruning taking place

3. Have a system failure that requires a Restore System recovery from the SLB and you perform a recover to current.

The tablespaces that were Reorged after the SLB was taken would be in a Recover Pending state, so I assume that performing a Recover for any that had undergone partition pruning would operate correctly.

 

Cheeky b****r Mr. Smith! :) Luckily we don't get many callouts so I still get my beauty sleep. I just park the zimmer frame next to the bed and hope I don't forget it's there and fall over it in the morning!