Database Consulting Services

DATABASE CONSULTING SERVICES 
PeopleSoft DB2 UDB DBA and Performance Tuning Specialists

Home

Bio

Consulting Services

Webinars

Monitoring, Optimizing,
Configuring,
Architecture
Guide

White Papers

Conference Presentations

Customer List & References

Resumes

Contact Us

 

 

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.

    Contact us at: 

Database Consulting Services

925-575-0232

Info at db-consulting.com

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