Re: PeopleSoft on Informix??

jdiaz@accustaff.com (Jeff Diaz) wrote: >Our company is running PeopleSoft v5.10 - currently in the process of >moving over to 6. We are running this on Informix 7.12 on Digital >Unix. Now, the former DBA who was in charge of this had tons of >problems tuning the PeopleSoft databases. Are things really this bad? >He had told me that Informix just couldn't handle the massive number of >tables, views, and indexes that peoplesoft used and was nearly >impossible to tune well. I was even told not to update statistics on >any of the tables because this actually broke the informix optimizer >and it would choose the most inappropriate path. >I'm not new to Informix, and I've done pretty well on the other >databases around here, but he's got me scared to touch the peoplesoft >stuff. I'm inclined not to believe some of these things, but then >again, I'm not going to go playing around with the parameters until I >know for sure. Has anyone else had this experience? Is it really >true? If not, are there any tricks I should know to get peoplesoft >running well? First of all, what PeopleSoft Apps are you running? We run HR version 5 and Financials version 3. We have not had a problem managing the Informix per se. However ,there are significant tuning issues, some engine related, some client/I-net related. Partly it depends on your underlying platform. The one thing that we have had significant success with is in the indexing strategy. This is an area you'll have to examine very carefully. It's going to mean a lot of set explains. As to the informix optimizer, I am still not a fan of it. We've had signicant problems with it in regards to our data warehouse. Since then I have always set the OPTCOMPIND=0. While we have been running PeopleSoft on Informix for 2 years(we were one of if not the first such customer to go into production) I can't say that these Informix/Peoplesoft instances are any more difficult to manage. I also can't say that we've come to know everything about tuning this database either, so if anyonw else has comments, I'd like to see them posted here. Good Luck with your situation. Barry Leb barryleb@atl.mindspring.com