DATABASE CONSULTING SERVICES
PeopleSoft DB2 UDB DBA and Performance Tuning Specialists
Performance Tip of the Week Archive
Week 1: 4/8/2002: Online tracing - 2-tier
Week 2: 4/15/2002: Online tracing - 3 & 4-tier
Week 3: 4/23/2002: Interpreting online traces - 2-tier
Week 4: 4/29/2002: Interpreting online traces - 3-tier
Week 5: 5/6/2002: Interpreting online traces - 4-tier
Week 6: 5/13/2002: The Art of Tuning
Week 7: 5/20/2002: SQL Case Study 1 - Menu authorization during Signon
Week 8: 5/27/2002: SQL Case Study 2 - Entry into PSQuery
Week 9: 6/03/2002: Menu Navigation
Week 10: 6/10/2002: Menu Browser Caching
Week 11: 6/17/2002: SQL Case Study 3 - Security Views in HR
Week 12: 6/24/2002:Case Sensitive Searching
Week 13: 7/01/2002: Batch Tracing - Mainframe Cobol
Week14: 7/08/2002: Batch Tracing - Mainframe Application Engine
Week15: 7/15/2002: Batch Tracing - Interpreting the PTPSQLRT Statistics Report
Week16: 7/22/2002: Interpreting the Cobol and SQL traces
Week17: 7/29/2002: Interpreting the PS8 AE Batch Timings Report
Week18: 8/05/2002: Tracing Remote Call Cobol
Week19: 8/12/2002: Tracing SQR
Week20: 8/19/2002: Overview of Lock Contention
Week21: 8/26/2002: Monitoring Online Threads - 2 tier
Week22: 9/02/2002: Monitoring Online Threads - 3 and 4 tier
Week23: 9/09/2002: Monitoring Process Scheduler Threads
Week24: 9/23/2002: Monitoring Application Messaging Threads
Week25: 9/30/2002: How good is your network
Week26: 10/07/2002: Caching - Part 1 (EnableServerCaching)
Week27: 10/14/2002: Caching - Part 2 (ServerCacheMode)
Week28: 10/21/2002: Query Monitor
Week29: 10/28/2002: Correlated Subqueries in DB2 V7
Week30: 11/11/2002: Dedicated Cursors and Cursor Reuse
Week31: 11/18/2002: North American Payroll Tuning
Week32: 11/25/2002: Temporary Tables - Using non-shared Temp Tables in General Ledger Cobol Programs
Week35: 12/16/2002: Temporary Tables - Other Techniques to provide batch concurrency
Week36: 12/23/2002: Temporary Tables - Runstats techniques - Part 1
Week37: 12/30/2002: Temporary Tables - Runstats techniques - Part 2
Week38: 01/06/2003: SQL Case Study 4 - 6 different access paths from the same SQL
Week39: 01/13/2003: SQR Performance in PS8
Week40: 01/20/2003: Lock Contention with PSLOCK and PSVERSION in PS7.5 and PS8
Week42: 02/10/2003: SQL Case Study 5 - Distincts
Week43: 02/24/2003: EDM Pool Parameters
Week44: 03/10/2003: Tracing Application Engine Driver Program SQL calls
Week45: 03/24/2003: Using the Application Debugger to Capture Temp Table data
You will find White Papers and presentations written by Brian Holroyd at the following locations
PeopleSoft Customer Connection
2001 Connect Americas
http://www4.peoplesoft.com/2001presentsamer.nsf/SessionTrack?readform
Session Number: 7021 
DB2/OS390 Performance and Tuning
Support/Troubleshooting/Supported Platforms/Platform Communications/DB2 UDB for OS/390 and z/OS
Please Note: Some documents listed below may have expired and been removed from the site
09/25/2001
Correlated and Uncorrelated Subqueries on DB2/OS390 - Update - May 1999
05/14/1999
07/13/1999
06/19/1998
PeopleSoft and OS/390 DB2 Performance Management Using the Workload Manager
04/23/1999
07/12/1999
07/13/1999
07/13/1999
12/02/1999
T
uning Accounts Receivable 7.5 on DB2/OS390
07/13/1999
12/02/1999
07/13/1999
06/28/2000
07/13/1999
02/26/2001
SHARE 2000 Conference Proceedings CD
Session 1457 - PS8 Internet Architecture Performance Topics
IDUG 2000 Conference Proceedings CD
Session I4 - Tuning PeopleSoft on DB2 for OS/390
IDUG 2001 Conference Proceedings CD
Session I3 - Tuning PeopleSoft on DB2 for OS/390
Contact us at:
925-575-0232
Copyright © Database Consulting Services
All other products listed are registered trademarks or trademarks of other corporations
PeopleSoft DB2 UDB DBA and Performance Tuning Specialists