Solutions to Upgrade from 7.30.uc5 to 7.31.uc5 broke Peoplesoft

With the new 7.31 optimizer the Nvision settings had to be changed to fix the queries. The Peoplesoft admin got the information from Tech Notes article by Kevin Fennimore Vol 9 Issue 3 1999. Thanks Kevin! |--------+-----------------------> | | "Carlson@WHSm| | | ith" | | | <carlson1 | | | | | | 03/22/2000 | | | 03:01 PM | | | Please | | | respond to | | | "Carlson@WHSm| | | ith" | | | | |--------+-----------------------> >-------------------------------------------------------------------| | | | To: informix-list@iiug.org | | cc: (bcc: Kernoal Stephens/STS/AUTOZONE) | | Subject: Re: Upgrade from 7.30.uc5 to 7.31.uc5 broke | | Peoplesoft N'vision | >-------------------------------------------------------------------| Kernoal.Stephens@AUTOZONE.COM wrote: > > AIX 4.3.2 > Peoplesoft 7.52 > > Before upgrade every one was happy. > Bad news coming . . . . > After upgrade the N'vision reports went from a couple of minutes to hours. Ouch! > > No changes were made to the onconfig during the upgrade. Granted . . . ! > > What are the new features with IDS 7.31 geared toward peoplesoft to help > with these queries? Subquery flattening could be the culprit, but it was a problem in the 7.30 versions. Hopefully the issue had been resolved before the 7.31 code was released. Just a question . . . did you run the required UPDATE STATISTICS after the upgrade? -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */