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
