Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] User's big focsort.foc

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] User's big focsort.foc
 Login/Join
 
Winfred Gunter
Gold member
posted
I have some power users that during the life of there job they create large focsort.foc files.
Is it safe to delete this, in code?

Will FOCUS re-create it if/when needed again?

I already have the user coding DOS del on some other interim files as he completes each step of his job, which helps, but this focsort.foc is killing me.

Thanks,
--wg

This message has been edited. Last edited by: Winfred Gunter,


WF 8009m, Clustered vm Windows2008r2 reporting servers;
Web interface: tomcat;
Output: EXCEL, HTML, PDF; dbms: Oracle 10, db2 on mvs, mssql
 
Posts: 81 | Location: Monroe LA | Registered: January 07, 2005Report This Post
dhagen
Virtuoso
posted Hide Post
Yep.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Waz
Expert
posted Hide Post
This is something that we do here, when we have lots of large files.

Typically ours are hold files.

FOCSORT will be recreated if its removed.

Also have you tried SET EXTSORT = ON. The files are cleaned up after the sort.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Winfred Gunter
Gold member
posted Hide Post
Waz,

Are you saying that SET EXTSORT = ON will tell webfocus to clean up the focsort.foc during a job process, rather than waiting until the agent is done?

If so, that's terrific. What we are trying right now, is DOS DEL focsort.foc within the job steps (in addition to DOS DEL temphold.ftm files).

I just read-up on EXTSORT because I was remembering from years ago.... It appears that EXTSORT is for an external sort utility like syncsort... we don't have that available.

Thanks for the response,
--wg

This message has been edited. Last edited by: Winfred Gunter,


WF 8009m, Clustered vm Windows2008r2 reporting servers;
Web interface: tomcat;
Output: EXCEL, HTML, PDF; dbms: Oracle 10, db2 on mvs, mssql
 
Posts: 81 | Location: Monroe LA | Registered: January 07, 2005Report This Post
Dan Satchell
Virtuoso
posted Hide Post
These links provide info on FOCSORT and the settings that affect it. None of this information will help in deleting FOCSORT during a session, but it might help in avoiding the need to do so.

FOCSORT Limit

FOCSORT Processing


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Waz
Expert
posted Hide Post
WF comes with the external sort module.

The FOCSORT will not be removed, but may not be created/replaced


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Winfred Gunter
Gold member
posted Hide Post
Thanks for the responses....

I've read the links and I'll try the setting extsort, tablef and matrix, but my user is doing MATCHes. It may still use focsort, if I understood what I read.

Thanks for the ideas,
--wg


WF 8009m, Clustered vm Windows2008r2 reporting servers;
Web interface: tomcat;
Output: EXCEL, HTML, PDF; dbms: Oracle 10, db2 on mvs, mssql
 
Posts: 81 | Location: Monroe LA | Registered: January 07, 2005Report This Post
Winfred Gunter
Gold member
posted Hide Post
Waz,

I tried SET EXTSORT = ON and when the job runs it gives and error:

0 ERROR AT OR NEAR LINE 106 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC909) CRITICAL ERROR IN EXTERNAL SORT. RETURN CODE IS: 00000332

So, wf may come with external sort module, but apparently I don't have it (or configured).

--wg


WF 8009m, Clustered vm Windows2008r2 reporting servers;
Web interface: tomcat;
Output: EXCEL, HTML, PDF; dbms: Oracle 10, db2 on mvs, mssql
 
Posts: 81 | Location: Monroe LA | Registered: January 07, 2005Report This Post
jgelona
Master
posted Hide Post
EXTSORT has been around for 10-12 years? IMO has never been reliable, especially with Multi-Verb request. Over the years I have tried using it several time and would get signifcantly different results with EXTSORT=ON vs. EXTSORT=OFF. Therefore we always leave it off. Maybe it has been fixed (haven't tried using it in several years), but I'd stay away from it unless all you are doing is sorting and do extensive testing to make sure your results are the same with EXTSORT ON or OFF.

I try to write my code in such a way that the database does the sorting (which won't happen with multi-verb requests) or code SQL Passthru.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] User's big focsort.foc

Copyright © 1996-2020 Information Builders