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] Does WebFocus support Parallel Processing

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Does WebFocus support Parallel Processing
 Login/Join
 
Silver Member
posted
Hi,

We are builing a new environment with 8 CPU's and 8 Ghz Memory and is a Sun Solaris Machine. It has got the Parallel processing funtionality.

Does WebFocus support Parallel Processing?
Does Reporting Server make use of O/S Parallel Processing funtionality?

Thanks,
Amarnath

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Expert
posted Hide Post
Have you talked to your IBI rep ?


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
Platinum Member
posted Hide Post
WF just builds SQL and sends it to the engine for the platform it runs on, correct? If you have parallelism enabled on that engine, what would not allow it to work?


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Report This Post
Silver Member
posted Hide Post
Its not about Database, i know Database performs Parallel Processing.

I am thiking about the job done by Reporting Server,does Reporting server support parallel processing?


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Expert
posted Hide Post
I don't think so.


I think you should talk to your IBI rep, or put in a case with IBI so you can get an appropriate answer for your version of WebFOCUS, and OS.


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
<JG>
posted
quote:
does Reporting server support parallel processing

No.

There have been a few discussions about this recently.

The WebFOCUS server will start a particular task on any processor available to it.
So it is processor independant.

If a request is made to a database engine that supports multi-tasking then that particular
part of the request will use multiple processors (WebFOCUS adapter configuration permitting).

However the WebFOCUS server parts of the request are bound to the one processor.


  



    Four processor machine
    ____________________________________________
    |                                           |
    |                                           |
    |                                           |
    |               Oracle                      |
    |              /------\                     |
    |             / /----\ \                    |
    |  WebFOCUS  / /      \ \   WebFOCUS        |
    |  Process---            --- Process        |
    |            \ \      / /                   |
    |             \ \----/ /                    |
    |              \------/                     |
    |                                           |
    |                                           |
    |                                           |
    |                                           |
    |                                           |
    ____________________________________________
 
Report This Post
Master
posted Hide Post
For the WebFOCUS/FOCUS language to support parallel processing, IBI would have to add languane extensions to Dialogue Manager. You would have to be able to identify sections of code that are independent of each other and identify WAIT places. For example, I have a large program that collects data from more than 100 tables in our Oracle database and creates an XFOCUS database that is used for reporting.

Step 1 creates file and loads the population.
Step 2 collects data and updates.
Step 3 collects data and updates.
Step 4 collects data and updates.
....
Step 30 collects data and updates

This is a weekly batch job that runs around 3am and takes about 45 minutes to run, however, Steps 2-30 could run in parallel because they do not add to the population.

Since this program originated back in the dark times (before WebFOCUS), if I was going to do this program now and use parallel processing, I would write 30 distinct programs. After the population is created in step 1, I would use 29 DSTRUN calls in fex 1 to run the last 29 fexes. DSTRUN tells Report Caster to run a job now, so all 29 jobs would fire at the same time. I don't know that I would gain a lot, but it would be interesting to see how that would work.


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
<JG>
posted
quote:
so all 29 jobs would fire at the same time

You have to re-configure caster as the default is 3 concurrent caster processes.
 
Report This Post
Virtuoso
posted Hide Post
There are ways to load-balance across multiple reporting services, each of which can be started on separate processors. It can be done, though it's not a transparent thing that magically happens. A good SE can get you set up to work across multiple processors.

I'll be honest -- short of heavy processing on FOCUS data files or some really hairy cross-DBMS joins the processing time on the Reporting Server (or WF Client for that matter) shouldn't be all that significant. Unless you're in a pretty complex environment multi-processing will only be an issue for the underlying DBMS. Your conversion to a multi-processor configuration may introduce more processing time than it reduces.

I'd wait until the problem presents itself before worrying about it. I'm on a four processor system and the tscoms are pulling very little juice. It's all in SQL Server.

S.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Silver Member
posted Hide Post
Thank you guys for your valuable feedback


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report 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] Does WebFocus support Parallel Processing

Copyright © 1996-2020 Information Builders