Hi Dave,
Thank you for you quick answer.
OK, I understand the Db2 Reorg Utility in variable length data sort is
the only exception.
But basically DFSORT is to reject program invoked ZSORT with ICE267I
RSN=200 (DFSORT was invoked via a program and is not supported with the
use of the IBM Integrated Accelerator for Z Sort).
Which APAR changed DFSORT to accept Db2 Reorg Utility with variable data
length ZSORT as the exception ?
Or is the above logic included from the beginning(PH03027) even though
it is not stated ?
Best regards,
Nobuhiko Furuya(古谷信彦)
V-SOL Inc.
On 2022/01/27 20:34, David Betten wrote:
Db2 Utilities is the only exception to the program invoked restriction.
And reading the APAR, you'll notice even that is limited to "variable
length data sort of the REORG TABLESPACE utility". The reason for these
restrictions is that data has to be fed into the sort at a high speed to
realize benefit from the accelerator. The DFSORT and Db2 Utility teams had
to do extensive work to optimize the interface of passing records between
the utility and sort tasks to achieve that. A user program invoking DFSORT
would not have that optimization and thus would not realize benefit from
the accelerator.
Dave Betten
z/OS Performance Specialist
Worldwide z Technical Sales
IBM Technology Sales
email: [email protected]
"IBM Mainframe Discussion List" <[email protected]> wrote on
01/26/2022 09:40:33 PM:
From: "Nobuhiko Furuya" <[email protected]>
To: [email protected]
Date: 01/26/2022 09:40 PM
Subject: [EXTERNAL] ZSORT support for program invoked sort
Sent by: "IBM Mainframe Discussion List" <[email protected]>
Hello all,
With APAR PH03207, ZSORT has been enabled as follows.
https://www.ibm.com/support/pages/sites/default/files/inline-files/
DFSORT%20User%20Guide%20for%20PH03207.pdf
In the above, some restrictions are described as follows.
Below is a list of restrictions that will disable DFSORT's use of the
IBM Integrated
Accelerator for Z Sort and will revert to DFSORT traditional sorting
technique:
SORTL Facility is not enabled on the processor
ZSORT is not enabled for the DFSORT job
COPY Operation specified
INREC specified
JOINKEYS specified
MERGE FIELDS specified
MODS(EXITS) statement specified
OUTREC specified
OUTFIL specified
SUM FIELDS specified
DFSORT invoked from program
Memory Objects cannot be create
So it clearly states that "DFSORT invoked from program" is NOT supported
as ZSORT.
On the other hand, APAR PH28183 is to support ZSORT within Db2 Reorg
utility as follows.
https://www.ibm.com/support/pages/apar/PH28183
Ｉbelieve Db2 Reorg utility should invoke DFSORT with ZSORT option with
the above APAR.
Does PH28183 or some prerequisites eliminate the original DFSORT
restriction ?
Or do I misunderstand something ?
Can anyone comment on this ?
Nobuhiko Furuya(古谷信彦)
V-SOL Inc.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
