DATABASE CONSULTING SERVICES
PeopleSoft DB2 UDB DBA and Performance Tuning Specialists
Database Consulting Services can structure a consulting assignment to suit your needs.
The following products are offered as standard service offerings:
Architectural Review and Performance Troubleshooting
Performance Troubleshooting of Specific Online and/or batch processes
Architectural Review and Performance Troubleshooting
Scope
 |
Review architecture and configuration of PeopleSoft DB2 for z/OS System (DB2 V9 audit available by June 2008) |
|
Review up to 3 batch and up to 3 online transactions for performance bottlenecks |
Specification
|
Review all relevant Zparms |
|
Review USS configuration |
|
Review all relevant parameters in table,index and tablespace definitions |
|
Review bufferpool allocations |
|
Review bind parameters for PS related packages |
|
Review network for acceptable response times |
|
Review DB2 Connect settings |
|
Review Application Server configurable parameters |
|
Review Web Server configurable parameters |
|
Review PS traces from batch and online transactions of choice. |
|
Determine potential tuning opportunities, and depending on complexity and time availability, resolve. |
|
Review WLM usage |
Pre Reqs
|
Customer to fill out environment template prior to arrival |
|
Accessibility to DB2 Catalog to run queries |
|
Accessibility to Zparm information and 'SYS1.PARMLIB' |
|
Authority to ping nodes in the network for response time analysis |
|
Accessibility to Application Server and Web Server configuration files |
|
Use of Visual Explain for DB2 for OS/390. This is mandatory because it is easily the most productive for identifying and resolving access path problems. If customer does not currently have this tool, it can be downloaded for free from http://www-4.ibm.com/software/data/db2/os390/v6facts/db2ve.html |
|
Accessibility and authority to run PS transactions from a Windows client |
|
Availability of PTPSQLRT stats report (for COBOL programs), and Batch Timings Report (for AE programs) to troubleshoot batch performance issues |
Timeframe
|
4 on-site days plus 1 off-site day for report. |
Performance troubleshooting of specific online and batch processes
Scope
|
Review batch and/or online processes of choice for performance bottlenecks |
Specification
|
Review PeopleSoft traces from batch and online transactions of choice. |
|
Determine potential tuning opportunities, and depending on complexity and time availability, resolve. |
Pre Reqs
|
Accessibility to DB2 Catalog to run queries |
|
Use of Visual Explain for DB2 for OS/390. This is mandatory because it is easily the most productive tool for identifying and resolving access path problems. If customer does not currently have this tool, it can be downloaded for free from http://www-4.ibm.com/software/data/db2/os390/v6facts/db2ve.html |
|
For online, accessibility and authority to run PS transactions from a Windows client |
|
For batch, availability of PTPSQLRT stats report (for COBOL programs), and Batch Timings Report (for AE programs) |
Timeframe
|
2 on-site days to review and recommend tuning opportunities for up to 3 batch and 3 online processes. |
|
Resolution may or may not be possible in that timeframe. Some SQL statements can take 4-8 hours to pinpoint the problem. Resolution sometimes requires running the process against the production data, and if that is restricted by schedules, 2 days may not be long enough. |
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. Upgrades, Installs , Administration, Audits