Re: Informix PDQ & PeoplSoft Financials

Vardan Aroustamian <aroustv@towers.com> wrote: >In article <6ismmm$1jd$1@nnrp1.dejanews.com>, > ttpayne@tuc.com wrote: >> >> I'm an Informix DBA, and we are running PeopSoft Financials 6.x and Informix >> Dynamic Server 7.2. >> >> I would like to turn on Informix's PDQ feature to speed up some of >> our nightly batch jobs, but to do so, I need to set the PDQPRIORITY >> environment variable. >> >> Since all of our users are ultimately logged in as 'sysadm', seting the PDQ >> environment variable in this account is not feasible because we don't want >> ALL of our queries to run in PDQ mode. >> >> My question: >> Have any of you turned on Informix PDQ for a PeopleSoft application? >> If so, I would welcome any suggestions. >> >> Tim (ttpayne@tuc.com) >> >> -----== Posted via Deja News, The Leader in Internet Discussion ==----- >> http://www.dejanews.com/ Now offering spam-free web-based newsreading >> >You can use SET PDQPRIORITY statement in your application. This is not exactly true or easy. Peoplesoft uses both Cobol and sqr's. You can set pdqpriority within the sqr without much difficulty. However, it is not the case with the Cobol. To be honest, I don't know how you would do it with the Cobol. Generally, I have used pdqpriority at the instance level with peoplesoft. We had some success with a low setting at 2 or 5. However, we were on 7.14 informix and ran into a bug, so we had to turn pdqpriority off at the instance level. You may not have this bug on 7.2. >-- >Vardan Aroustamian >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/ Now offering spam-free web-based newsreading Barry Leb barryleb@atl.mindspring.com