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     [SHARING] Do any of you run Webfocus on an iSeries running OS400?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SHARING] Do any of you run Webfocus on an iSeries running OS400?
 Login/Join
 
Master
posted
We're considering whether it would be a good idea to install our Webfocus reporting server and client on our iSeries instead of dedicating a Windows server to the task.

We have been running on Win 2003 Server for many years, and haven't had any real trouble, but we figure the iSeries is a more expensive machine so likely faster.

Do any of you run Webfocus on an iSeries running OS400? What are your thoughts compared to Windows, have you had any trouble with it on the iSeries with configuration?

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


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Guru
posted Hide Post
Yes we are.

The client with whom am working right now, is Running the WebFOCUS server instance(basically 2, one for Dev and One for TEST) as part of the OS 400 server. And performance wise, it is too good, as the DB2 DB server also reside in the same OS400 machine. As far as I see configuration Files ODIN, ADMIN and edaserve dont show much difference between the usual windows/Unix one and OS400 one.

We initally had few issues in executing DB2 stored procs from webFOCUS in this Env. But sorted out with IbI and created CLI adapters to resolve the same.

Otherwise perfomance is really the point to be mentioned here.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Member
posted Hide Post
IBM has a product called DB2 Web Query that is their version of the Webfocus products for iSeries & OS/400 OS.

We've been running sucessfully for 2+ years now. Integrates well with all DB2 tables and views and stored procedures. Has options for running the reports on web pages via a URL calls. Can pull in data from SQL Servers as well.

Hope this helps.

Bob
 
Posts: 17 | Registered: December 20, 2010Report This Post
Master
posted Hide Post
Ramkumar brings up an interesting point. Is the performance of running Webfocus on the iSeries improved over connecting to a database through ODBC or through a CLI adapter?

rdmcnally: Are you running DB2 Web Query? Have you had much luck with it? Is it exactly the same as webfocus?


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 611 | Registered: January 04, 2007Report This Post
Member
posted Hide Post
Yes - we are running DB2 Web Query.
Yes - we have had a lot of success with it.
No - it is not exactly the same as webfocus. IBM has modified it to work with the DB2 Data Base and iSeries OS. I dont have a feature by feature comparison of the two products. A good place to start is here:

http://www.ibm.com/developerwo...um.jspa?forumID=1289
 
Posts: 17 | Registered: December 20, 2010Report This Post
Guru
posted Hide Post
Both the ways Jason. CLI adapters were created only to resolve issues in executing DB2 Stored Procedures.

Other than that, performance was really good in(webfocus running on iSeries OS400 and DB2 db) data fetching part - either through webFocus Synonyms or through SQL pass throughs. I mean to faster when Compared to connect to MS SQL Server or Oracle which resides in a different Server.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
<JG>
posted
Situation here is quite simple.

Basic rule,
If WebFOCUS is installed on the same machine as the data source the performance is going to be better,
simply because you remove the network transfer element.

iSeries machines generally have faster processors and more memory than Windows server machines,
if you are going 100% at DB2 data it's got to be a better option.

However if you need to access none DB2 data on a remote source you will take a hit.

Installation and configuration is a bit more complex but should not be an issue.

Remeber if you use any opsys calls they all need to be changed, same for filedefs etc.

Best advice, if you are seriously thinking about this, is to contact your local IBI branch
and talk with them.

I would suggest a POC, because you will have to pay to change platforms and you need proof that the investment is worth it.
 
Report This Post
Guru
posted Hide Post
quote:
If WebFOCUS is installed on the same machine as the data source the performance is going to be better,
simply because you remove the network transfer element.



Yes.. Latency plays the role there...


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 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     [SHARING] Do any of you run Webfocus on an iSeries running OS400?

Copyright © 1996-2020 Information Builders