[AD kind of] DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Phil Grainger

[AD kind of] DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)
It’s an “extra price” sort for people who can’t face reorging their tables WITHOUT a sort – now you can have two ��

Of course, when you realise that the best sort is NO sort at all, you need a different solution

(Sorry – couldn’t resist)

________________________________

Phil Grainger

Enablement Manager

[login to unmask email]

Direct



+44 (0)118 921 8000

Mobile



+44(0)7808 643 479


E2, Eskdale Road
Winnersh
Berkshire
RG41 5TS


[http://media.cms.bmc.com/images/corp_signature_bmclogo_2014.jpg] http://www.bmc.com

[cid:[login to unmask email]






From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 09 May 2018 17:19
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Isaac,

Thanks very much. Interesting detail.

“DB2 Sort provides high-speed utility sort processing for data that is stored in DB2 for z/OS databases. DB2 Sort is a component of the IBM DB2 Utilities Solution Pack for z/OS. DB2 Sort is also available as a separately orderable product.”

From: Isaac Yassin [mailto:[login to unmask email]
Sent: Wednesday, May 09, 2018 11:44 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Take a look at

https://www.ibm.com/support/knowledgecenter/en/SSLJYE_2.1.0/cnkhome.html https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_en_SSLJYE-5F2.1.0_cnkhome.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=628l8xufGcqT1SV5yFNP4BPlhUFxv-iB8V369Pt0sBU&s=IgheXUT-VXGLzLuvWhZ17zX4ylcNpdBSp8ium9LM4pk&e=

Isaac Yassin
dbX-Consulting Services
IBM Gold Consultant
IBM Champion for Analytics #ibmchampion
IBM Certified Solution Expert
IBM Certified System Administrator - DB2 10, 11, 12 for z/OS
IBM Certified Database Administrator - DB2 for z/OS 9, 10, 11
IBM Certified Database Administrator - DB2 LUW 10.1
IBM Certified Specialist - PureData System for Analytics v7.1
IDUG Israel RUG co-Chair


On Wed, May 9, 2018 at 5:55 PM, Chris Hoelscher <[login to unmask email]<mailto:[login to unmask email]>> wrote:
That’s my understanding … well, SORT of …

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D123-2BEast-2BMain-2BStreet-2B-250D-250A-2BLouisville-2C-2BKY-2B40202-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=628l8xufGcqT1SV5yFNP4BPlhUFxv-iB8V369Pt0sBU&s=8f7MjVO2bp_psgQF3DqAWxkfiGapvXSZ8TilvvxkoUk&e=
Louisville, KY 40202 https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D123-2BEast-2BMain-2BStreet-2B-250D-250A-2BLouisville-2C-2BKY-2B40202-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=628l8xufGcqT1SV5yFNP4BPlhUFxv-iB8V369Pt0sBU&s=8f7MjVO2bp_psgQF3DqAWxkfiGapvXSZ8TilvvxkoUk&e=
Humana.com
(502) 476-2538 or 407-7266

From: Baldon, David [mailto:[login to unmask email]<mailto:[login to unmask email]>]
Sent: Wednesday, May 9, 2018 10:54 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

That’s my understanding as well.

...David

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Wednesday, May 9, 2018 9:44 AM
To: '[login to unmask email]<mailto:[login to unmask email]>' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - DB2SORT (was RE: DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Steven,

I thought DB2SORT was the name for the stub DFSORT license which is automatically supplied with DB2. About fifteen years ago, IBM decided it wanted closer integration between DB2 and SORT in order to achieve greater efficiencies. This sounds like that; so you should actually have DB2SORT (If this is that stub license), and it’s part of the DB2 implementation.

--Phil

From: Steven Lamb [mailto:[login to unmask email]
Sent: Wednesday, May 09, 2018 10:00 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS v11 REORG Shrlevel Change Deadline issues


Is anybody else having issues with DB2 v11 Reorgs and Deadlines at the moment?

We seem to be having a couple of different issues (that we have PMRs for);

* The Reorg can reach the Deadline and abend
* The Reorg can reach the deadline and just hang on an ECB wait outside of DB2. Terminate Util doesn't work and the job has to be cancelled
* The Reorg can reach the deadline, stop processing the current object, but then go on to start another object from the Listdef and then decide to end

The APARs I've found usually mention DB2SORT, but we don't have DB2SORT.



Regards,

Steve



-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----

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

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (8k)
  • image002.png (5.9k)

J&#248;rn Thyssen

RE: [AD kind of] DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)
(in response to Phil Grainger)

like (IBM) REORG ... SORTDATA NO RECLUSTER NO?

In Reply to Phil Grainger:

It’s an “extra price” sort for people who can’t face reorging their tables WITHOUT a sort – now you can have two ��

Of course, when you realise that the best sort is NO sort at all, you need a different solution

(Sorry – couldn’t resist)

________________________________

Phil Grainger

Enablement Manager

[login to unmask email]

Direct



+44 (0)118 921 8000

Mobile



+44(0)7808 643 479


E2, Eskdale Road
Winnersh
Berkshire
RG41 5TS


[http://media.cms.bmc.com/images/corp_signature_bmclogo_2014.jpg] http://www.bmc.com

[cid:[login to unmask email]






From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 09 May 2018 17:19
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Isaac,

Thanks very much. Interesting detail.

“DB2 Sort provides high-speed utility sort processing for data that is stored in DB2 for z/OS databases. DB2 Sort is a component of the IBM DB2 Utilities Solution Pack for z/OS. DB2 Sort is also available as a separately orderable product.”

From: Isaac Yassin [mailto:[login to unmask email]
Sent: Wednesday, May 09, 2018 11:44 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Take a look at

https://www.ibm.com/support/knowledgecenter/en/SSLJYE_2.1.0/cnkhome.html https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_en_SSLJYE-5F2.1.0_cnkhome.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=628l8xufGcqT1SV5yFNP4BPlhUFxv-iB8V369Pt0sBU&s=IgheXUT-VXGLzLuvWhZ17zX4ylcNpdBSp8ium9LM4pk&e=

Isaac Yassin
dbX-Consulting Services
IBM Gold Consultant
IBM Champion for Analytics #ibmchampion
IBM Certified Solution Expert
IBM Certified System Administrator - DB2 10, 11, 12 for z/OS
IBM Certified Database Administrator - DB2 for z/OS 9, 10, 11
IBM Certified Database Administrator - DB2 LUW 10.1
IBM Certified Specialist - PureData System for Analytics v7.1
IDUG Israel RUG co-Chair


On Wed, May 9, 2018 at 5:55 PM, Chris Hoelscher <[login to unmask email]<mailto:[login to unmask email]>> wrote:
That’s my understanding … well, SORT of …

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D123-2BEast-2BMain-2BStreet-2B-250D-250A-2BLouisville-2C-2BKY-2B40202-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=628l8xufGcqT1SV5yFNP4BPlhUFxv-iB8V369Pt0sBU&s=8f7MjVO2bp_psgQF3DqAWxkfiGapvXSZ8TilvvxkoUk&e=
Louisville, KY 40202 https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D123-2BEast-2BMain-2BStreet-2B-250D-250A-2BLouisville-2C-2BKY-2B40202-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=628l8xufGcqT1SV5yFNP4BPlhUFxv-iB8V369Pt0sBU&s=8f7MjVO2bp_psgQF3DqAWxkfiGapvXSZ8TilvvxkoUk&e=
Humana.com
(502) 476-2538 or 407-7266

From: Baldon, David [mailto:[login to unmask email]<mailto:[login to unmask email]>]
Sent: Wednesday, May 9, 2018 10:54 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

That’s my understanding as well.

...David

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Wednesday, May 9, 2018 9:44 AM
To: '[login to unmask email]<mailto:[login to unmask email]>' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - DB2SORT (was RE: DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Steven,

I thought DB2SORT was the name for the stub DFSORT license which is automatically supplied with DB2. About fifteen years ago, IBM decided it wanted closer integration between DB2 and SORT in order to achieve greater efficiencies. This sounds like that; so you should actually have DB2SORT (If this is that stub license), and it’s part of the DB2 implementation.

--Phil

From: Steven Lamb [mailto:[login to unmask email]
Sent: Wednesday, May 09, 2018 10:00 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS v11 REORG Shrlevel Change Deadline issues


Is anybody else having issues with DB2 v11 Reorgs and Deadlines at the moment?

We seem to be having a couple of different issues (that we have PMRs for);

* The Reorg can reach the Deadline and abend
* The Reorg can reach the deadline and just hang on an ECB wait outside of DB2. Terminate Util doesn't work and the job has to be cancelled
* The Reorg can reach the deadline, stop processing the current object, but then go on to start another object from the Listdef and then decide to end

The APARs I've found usually mention DB2SORT, but we don't have DB2SORT.



Regards,

Steve



-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----

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

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2018 IBM Champion.

Views are personal. 

Phil Grainger

[AD kind of] DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)
(in response to Jørn Thyssen)
Well a BIT like that, but one that can recluster the data WITHOUT a sort.....

SORTDATA NO RECLUSTER NO is hardly a reorg at all

Sent using OWA for iPad
________________________________
From: Jørn Thyssen <[login to unmask email]>
Sent: 09 May 2018 21:15:40
To: [login to unmask email]
Subject: [DB2-L] - RE: [AD kind of] DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)


like (IBM) REORG ... SORTDATA NO RECLUSTER NO?

In Reply to Phil Grainger:

It’s an “extra price” sort for people who can’t face reorging their tables WITHOUT a sort – now you can have two ��

Of course, when you realise that the best sort is NO sort at all, you need a different solution

(Sorry – couldn’t resist)

________________________________

Phil Grainger

Enablement Manager

[login to unmask email]

Direct



+44 (0)118 921 8000

Mobile



+44(0)7808 643 479


E2, Eskdale Road
Winnersh
Berkshire
RG41 5TS


[http://media.cms.bmc.com/images/corp_signature_bmclogo_2014.jpg] http://www.bmc.com

[cid:[login to unmask email]






From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 09 May 2018 17:19
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Isaac,

Thanks very much. Interesting detail.

“DB2 Sort provides high-speed utility sort processing for data that is stored in DB2 for z/OS databases. DB2 Sort is a component of the IBM DB2 Utilities Solution Pack for z/OS. DB2 Sort is also available as a separately orderable product.”

From: Isaac Yassin [mailto:[login to unmask email]
Sent: Wednesday, May 09, 2018 11:44 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Take a look at

https://www.ibm.com/support/knowledgecenter/en/SSLJYE_2.1.0/cnkhome.html https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_en_SSLJYE-5F2.1.0_cnkhome.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=JYomwt_Ijuja6kfeq8ef8jGVfGLlPmcENlk-slQhqjU&s=pTvQclvCXkfyPzR_wSIjvvRKHrb35u8zXdEEBeyFklw&e= https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_en_SSLJYE-5F2.1.0_cnkhome.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=628l8xufGcqT1SV5yFNP4BPlhUFxv-iB8V369Pt0sBU&s=IgheXUT-VXGLzLuvWhZ17zX4ylcNpdBSp8ium9LM4pk&e=

Isaac Yassin
dbX-Consulting Services
IBM Gold Consultant
IBM Champion for Analytics #ibmchampion
IBM Certified Solution Expert
IBM Certified System Administrator - DB2 10, 11, 12 for z/OS
IBM Certified Database Administrator - DB2 for z/OS 9, 10, 11
IBM Certified Database Administrator - DB2 LUW 10.1
IBM Certified Specialist - PureData System for Analytics v7.1
IDUG Israel RUG co-Chair


On Wed, May 9, 2018 at 5:55 PM, Chris Hoelscher mailto:[login to unmask email]>> wrote:
That’s my understanding … well, SORT of …

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D123-2BEast-2BMain-2BStreet-2B-250D-250A-2BLouisville-2C-2BKY-2B40202-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=628l8xufGcqT1SV5yFNP4BPlhUFxv-iB8V369Pt0sBU&s=8f7MjVO2bp_psgQF3DqAWxkfiGapvXSZ8TilvvxkoUk&e=
Louisville, KY 40202 https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3D123-2BEast-2BMain-2BStreet-2B-250D-250A-2BLouisville-2C-2BKY-2B40202-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=628l8xufGcqT1SV5yFNP4BPlhUFxv-iB8V369Pt0sBU&s=8f7MjVO2bp_psgQF3DqAWxkfiGapvXSZ8TilvvxkoUk&e=
Humana.com
(502) 476-2538 or 407-7266

From: Baldon, David [mailto:[login to unmask email]<mailto:[login to unmask email]<mailto:[login to unmask email]>]>
Sent: Wednesday, May 9, 2018 10:54 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2SORT (was DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

That’s my understanding as well.

...David

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Wednesday, May 9, 2018 9:44 AM
To: '[login to unmask email]<mailto:[login to unmask email]>' mailto:[login to unmask email]>>
Subject: [DB2-L] - DB2SORT (was RE: DB2 z/OS v11 REORG Shrlevel Change Deadline issues)

Steven,

I thought DB2SORT was the name for the stub DFSORT license which is automatically supplied with DB2. About fifteen years ago, IBM decided it wanted closer integration between DB2 and SORT in order to achieve greater efficiencies. This sounds like that; so you should actually have DB2SORT (If this is that stub license), and it’s part of the DB2 implementation.

--Phil

From: Steven Lamb [mailto:[login to unmask email]
Sent: Wednesday, May 09, 2018 10:00 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS v11 REORG Shrlevel Change Deadline issues


Is anybody else having issues with DB2 v11 Reorgs and Deadlines at the moment?

We seem to be having a couple of different issues (that we have PMRs for);

* The Reorg can reach the Deadline and abend
* The Reorg can reach the deadline and just hang on an ECB wait outside of DB2. Terminate Util doesn't work and the job has to be cancelled
* The Reorg can reach the deadline, stop processing the current object, but then go on to start another object from the Listdef and then decide to end

The APARs I've found usually mention DB2SORT, but we don't have DB2SORT.



Regards,

Steve



-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----

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

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com

2018 IBM Champion.

Views are personal.

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.