As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
I have searched this (and other) information repositories, and have yet to come up with a solution that resolves this external sort error message:ERROR AT OR NEAR LINE 316 IN PROCEDURE XXXXXXXX FOCEXEC (FOC909)CRITICAL ERROR IN EXTERNAL SORT.RETURN CODE IS: 0016This message occurs on a sort statement:PRINT BP2 IC2 AR2 DP2 RA2 FF2 RI2 PP2 FD2 LD2 AC2 BY BP2 NOPRINT BY IC2 NOPRINT BY AR2 NOPRINT ON TABLE HOLD AS S2END I use SYNCSORT; system is z/OS Version 1 Release 9; on IBM Z890.I have tried increasing extents, using S001WKS instead of SORTWKS, using S001WKS AND SORTWKS,added ESTRECORDS = 10000000 and various lower rec amaounts.I now have the following SETs in my program:SET HIPERFOCUS = OFF SET AUTOPATH = ON SET EXTSORT = ON SET BINS = 60 SET WIDTH = 132 and presently have the following space allowances://FOCSORT DD UNIT=SYSDA,SPACE=(CYL,(125,25),RLSE) //FOCSTACK DD UNIT=SYSDA,SPACE=(TRK,(25,25),RLSE) //SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //SORTWK04 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //SORTWK05 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //SORTWK06 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //SORTWK07 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //SORTWK08 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //* //S1 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //S2 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) //S3 DD UNIT=SYSDA,SPACE=(CYL,(25,25),RLSE) This is our standard setup for external sorting.There are about 100,000 records involved.Any help with this would be appreciated.Thx,JoeThis message has been edited. Last edited by: Joe_So_Cool,
Mainframe FOCUS z/OS Standard paper reporting and VPS interface for emailing Excel, Word, etc.
I do have that amount allocated to the sortwks; yes we have enough space on sysda. Both readlimit and recordlimit eliminate the issue for testing purposes, but I'll need all of the records available for actual processing. I guess I'm asking this question because I have other FOCUS programs working with even larger amounts of recs and have never had this problem before. Thanks again for trying to help, Joe.
Mainframe FOCUS z/OS Standard paper reporting and VPS interface for emailing Excel, Word, etc.
It might work better if the code did not use noprint on the by statements. PRINT DP2 RA2 FF2 RI2 PP2 FD2 LD2 AC2 BY BP2 BY IC2 BY AR2 ON TABLE HOLD AS S2END