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     WebFOCUS reporting server on AS400 vs AIX

Read-Only Read-Only Topic
Go
Search
Notify
Tools
WebFOCUS reporting server on AS400 vs AIX
 Login/Join
 
Guru
posted
Hello,

My current client is trying to move its WF Reporting Server from Win to either AS400 or AIX. Performance is a big concern. Will the performance depend on hardware or the AS400 has clear advantages over AIX? Currently, WF mainly connects to JD Edwards on AS400. We do see lots of crashed agents on the server and reports take long time to run. We are also planning to increase the users by 500+.

Thanks,
Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report This Post
Expert
posted Hide Post
I can't answer the question regarding AIX vs AS400, though I don't think it should make any difference, but "we do see lots of crashed agents on the server and reports take long time to run" could be due to programs not efficiently written. Have you traced the SQL verify the efficiency of the programs?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
We are very happy with WF on AIX and, after one user took all the  's out of his -HTMFORMs, we have very few crashed agents. We are running 765 for the reporting servers.

However, if you are accessing JD Edwards on AS/400, doesn't it seem more logical to put the reporting server there?

Can you have IBM help you size the box so that you won't have performance issues.

And please make note of Francis' comment. It is very germaine to this discussion. Poorly written code will run slowly whereever you put it.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Guru
posted Hide Post
Thank You guys! I do think the crashed agents are due to poorly written code or the JDE adapter for WF 713 has bugs. I will need to investigate that.


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report This Post
Master
posted Hide Post
We are in a similar situation and are doing everything we can to move off of the AS400. The AIX server is much faster. Now as far as JDE goes, on the AS400 that is a DB2 interface. I have not worked with it on AIX, but it is my understanding it can be done, but is an ORACLE interface. If you are currently running JDE on the AS400 are you planning to port the data to the AIX through an ETL process? or connect to it directly through a data adapter? or run WebFocus on both machines? There is not a simple answer that one is better than the other. It is going to depend on your systems and budget. All of the options have a cost involved. Discuss the options with your Tech rep and get estimates on what it would cost for each option and what are the advantages/disadvantages of each option.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Guru
posted Hide Post
Hey Pat,

Why did you guys move WF out of AS400? and why do you think it is working faster on AIX? I am assuming WF Reporting server would be 1/2 the price for AIX vs. AS400. We are thinking about putting the reporting server on AIX and connect to JDE on AS400 with an adapter. Do you see any issues with that?

Thanks,
Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report This Post
Master
posted Hide Post
We are still running a few FOCUS programs on the AS400 and I am doing everything I can to get them to WF because FOCUS for the AS400 is no longer supported. We have not moved WF off of the AS400 yet, but we are paying licensing fees on all of our servers. Our data is scattered across all 3 servers and doesn't "talk" to one another. Be aware that the initial cost for the data adapters is high. The cost of WF on the AIX + RC + WF on the NT is about 3/4 of WF on the AS400. But the initial outlay for data adapters for us to move everything to the AIX was more than double our total annual cost. In my opinion is it worth it? If you want up to the minute data, Yes! Could I convince my company of that? NO. We have applications that need data from JDE and Oracle. Currently we run a lot of batch processes and FTP the data from one server to the other. This means I have redundant files on each server that I have to try to keep in sync. I see fewer issues with using a data adapter and putting everything on one server than with not doing it. If you are with a large company, especially if you have several developers or user developers the savings in labor should pay for it.

Another option is an ETL process that extracts the data and builds a data warehouse/datamarts. I have been in several companies that this worked very well. The last one I was with refreshed the data warehouse every 8 minutes. That is what this company is moving toward, but we are way behind. We have another system that already has the data adapters and we are going to us it to load a data warehouse.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Guru
posted Hide Post
Thank You all for your help.


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report This Post
Platinum Member
posted Hide Post
In general, crashed agents means a bug in our software. They should be submitted for fixes. At a minimum, the reason for the crashes should be determined so you can implement a work around. Depending on how you are configured, crashed agents can cause performance problems. First of all, they occupy virtual memory (though they are likely paged out). Secondly, they are counted against your quota of active agents. If 17 of 20 agents are used up as "crashed" that leaves you running with 3 which can cause two affects when they are all in use
1. If queing is off, you will get msgs that there are no agents are available.
2. If queuing is on, the server attach manager will wait till an agent becomes free. The user perception is that the report is taking forever to run, but the reality is that most of the time the report request is waiting for a worker agent.
..
So check if you have queuing ... and clean out those crashed agents periodically.


Brian Suter
VP WebFOCUS Product Development
 
Posts: 200 | Location: NYC | Registered: January 02, 2007Report This Post
Guru
posted Hide Post
Hello Brian,


Thank you for the insight. This is what I have on my default Service configuration

Service


--------------------------------------------------------------------------------
Changing values with an asterisk (*) requires restarting the server
Press "Save" button to save the changes

service DEFAULT
maximum 50
number_ready 10
deployment private selected
Queuing on selected
maximum_q 10
queue_limit 60
idle_session_limit -1
idle_agent_limit 120
profile
cpu_limit -1
memory_limit -1
connection_limit -1
max_connections_per_user 4
agent_refresh 100
owner_control_request n selected


-------------------------------------------------------------------------------------------------------------------------------------

I also have "crashed_cleanup = on" in my edaserve.cfg, so crashed agents are being cleaned up.
Is there any other configuration change I should make to optimize our environment?

Thanks,
Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report This Post
Virtuoso
posted Hide Post
Sayed,

I'm just curious. What type of applications are you running against JDE? Batch? Self-Service? Ad-Hoc queries? All of the above?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Guru
posted Hide Post
Daniel,

Mostly Self-Service and Ad-Hoc. There may be some Batch that I am not aware of.

Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 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     WebFOCUS reporting server on AS400 vs AIX

Copyright © 1996-2020 Information Builders