DB2 V7 peoplesoft optimization hints

Jeff Frazier

DB2 V7 peoplesoft optimization hints
Hi,
We are looking at using optimization hints for peoplesoft. Is that
possible with peoplesoft? if so any good sites or papers on how to do
this?

TIA,
Jeff

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Don Doty

Re: DB2 V7 peoplesoft optimization hints
(in response to Jeff Frazier)
You might try to contact Craig Patton.



He had a lot of good ideas along those lines.



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jeff Frazier
Sent: Tuesday, November 28, 2006 10:57 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 V7 peoplesoft optimization hints




Hi,
We are looking at using optimization hints for peoplesoft. Is that
possible with peoplesoft? if so any good sites or papers on how to do
this?

TIA,
Jeff
------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm



The information in Indiana Farm Bureau Insurance email and any attachment is confidential and intended solely for the named addressee(s). This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without explicit permission. If you are not the intended recipient, any review, disclosure, copying, distribution, storage or use of the contents of this electronic message or any attached documents is prohibited. If you have received it in error, please notify the sender immediately and delete the message from your system. Personal messages and/or opinions in a message are solely those of the sender; Indiana Farm Bureau Insurance will accept no responsibility for such messages. While precautions have been taken, you are advised to check the message for computer viruses before opening any attachments.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Colin Clayton

Re: DB2 V7 peoplesoft optimization hints
(in response to Joel Goldstein)
Sorry Jeff, don't think that's possible with PeopleSoft using dynamic SQL.

Colin

(my opinion etc...etc...)

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Jeff Frazier
Sent: 28 November 2006 15:57
To: [login to unmask email]
Subject: [DB2-L] DB2 V7 peoplesoft optimization hints


*** WARNING : This message originates from the Internet ***


Hi,
We are looking at using optimization hints for peoplesoft. Is that possible
with peoplesoft? if so any good sites or papers on how to do this?

TIA,
Jeff
----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


The Royal Bank of Scotland plc, Registered in Scotland No. 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB

Authorised and regulated by the Financial Services Authority.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joel Goldstein

Re: DB2 V7 peoplesoft optimization hints
(in response to Don Doty)
While it's from an older version of PeopleSoft, the basics still apply.

Look in the Papers/Presentations section of our website, and scroll down to the Papers, Full Text area.
See the paper by Martin Hubel - Tuning PeopleSoft Applications for DB2 z/OS

Regards,
Joel.


Joel Goldstein
Responsive Systems
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.com
(732) 972-1261
----- Original Message -----
From: Jeff Frazier
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Tuesday, November 28, 2006 10:56 AM
Subject: [DB2-L] DB2 V7 peoplesoft optimization hints



Hi,
We are looking at using optimization hints for peoplesoft. Is that possible with peoplesoft? if so any good sites or papers on how to do this?

TIA,
Jeff --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm