Oninit cdi / Archive
Talk to an expert →

Upgrade from 7.30.uc5 to 7.31.uc5 broke Peoplesoft N'vision

Posted in 2000

Topics: Installation, Setup & Upgrades, SQL Development & Query Writing, Server Administration, Platform-Specific Issues, Versions, Editions & End-of-Life

Kernoal.Stephens@AUTOZONE.COM — — source: Informix-list mailing list archive (1991-1998)

AIX 4.3.2 Peoplesoft 7.52 Before upgrade every one was happy. After upgrade the N'vision reports went from a couple of minutes to hours. No changes were made to the onconfig during the upgrade. What are the new features with IDS 7.31 geared toward peoplesoft to help with these queries? Has any one had similar problems??????? Subquery Flattening maybe? Thanks

↪ replying to Kernoal.Stephens@AUTOZONE.COM
Carlson@WHSmith — — source: Informix-list mailing list archive (1991-1998)

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 */

Glossary