Home     

Bio

Performance & Tuning Class    

Consulting Services

Customer List & References 

Resumes    

Papers 

OPTIMIZING PEOPLESOFT 8.x ON DB2 FOR OS/390 TRANSITION

The following information can be found on this page:

Overview
Audience
Outline
Instructor
Prerequisites
Fee
Registration Form
Schedule
Payment and Refund Policy
Appraisal Form

Overview

This class is for those customers who have already attended the 7.x tuning class and don't want to listen to much of the same material. It is for anyone involved with optimizing the performance of PeopleSoft 8.x products on DB2 for OS/390.

It teaches the new features and functionality of the PS8 product.

The morning session focuses on the batch environment. It covers a architectural overview including USS, enabling and interpreting many new performance traces, new PeopleSoft features, and DB2 V6 and 7 features.

The afternoon session focuses on the online environment. It covers the online architecture, sizing and capacity planning, enabling and interpreting new online traces, Application Server and Web Server  tuning, online performance tuning techniques, DB2 Connect and Workload Manager.

Audience

This class is particularly recommended for DBA's, who are usually responsible for most optimization issues, but also for technical developers who customize PeopleSoft and are most knowledgeable about the processes that run.

It is also relevant for Systems Programmers and Network Engineers, whose areas of expertise are an integral part of PeopleSoft performance.

Outline  

·    Batch Environment 

o        Batch Execution environment and architecture

·         Unix System Services and running App Engine

o        Batch Traces

·         PTPSQLRT stats report

·         New SQL traces

·         New AE traces 

o        Program tuning

·         New UpdateStats metaSQL

o        SQL tuning

·         New Indexes 

·         Subqueries

·         Optimization Hints

o        DB2 object and system tuning

·         New AE Temp tables

·         Predictive Governor

o        Misc

·         Parallelism

o        DB2 V6 and 7 Performance Enhancements

·    Online Environment

o        Architecture

·         PeopleSoft Internet Architecture

·         Understanding the Web Server

·         Sizing guidelines

o        Online traces

·         Basic end-to-end response time analysis

·         2 ,3 and 4-tier Ptools traces

·         SQA robot for the Web

·         Client AE batch traces

·         Client COBOL batch traces

·         Client SQR batch trace

o        Web Server Monitoring and Tuning

·         Apache

·         WebLogic

o        Application Tuning

·         Optimize for n rows

·         Deferred prepare

·         Search Panels

·         Online performance considerations

·         Static SQL profiling

o        Online Concurrency

o        Workload Manager

o        Parallel Sysplex

Instructor

Brian Holroyd

Prerequisites

A portion of the class covers SQL tuning techniques and DB2 related parameters, so a good understanding of DB2 is desirable. Some knowledge of PeopleSoft is desirable.

Fee

$500, which includes all course material and notes

Registration Form

Click on this link to go to the Registration Form

Schedule

Call or e-mail if you are interested in this class

Payment & Refund Policy

Click on this link to go to the Payment and Refund Policy

Appraisal Form

Click on this link to go to the Appraisal Form

  Brian@db-consulting.com 

Copyright © Database Consulting Services
All other products listed are registered trademarks or trademarks of other corporations