Home     

Bio

Performance & Tuning Class    

Consulting Services

Customer List & References 

Resumes    

Papers 

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 anyone involved with optimizing the performance of PeopleSoft 8.x products on DB2 for OS/390.

It teaches all aspects of how to identify performance bottlenecks in both the batch and online 2, 3-tier and web 4-tier environments, and recommends ways to solve them.

The seminar specifically addresses PS 8.x functionality, but most of the content is relevant to prior releases as well.

Day 1 and half of Day 2 focuses on the batch environment. It covers a architectural overview, interpreting performance traces, tuning techniques, SQL tuning, DB2 object and system tuning, DB2 V6 and 7 features, Capacity Planning, and Case Studies.

The rest of Day 2 and Day 3 focuses on the online environment. It covers the online architecture, sizing and capacity planning, interpreting online traces, Application Server and Web Server  tuning, online performance tuning techniques, DB2 Connect/Centura, 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

·         JCL

·         Stored SQL

·         Dynamic SQL

·         PTPSQLRT

o        Batch Traces

·         PTPSQLRT stats report

·         SQL trace

·         AE trace

·         SQR trace

o        Program tuning

·         Common and dedicated cursors

·         Reuse

·         UpdateStats

o        SQL tuning

·         Explains

·         Indexes 

·         Subqueries

·         Optimization Hints

o        DB2 object and system tuning

·         Temp tables

·         DBDs

·         Tablespaces

·         BPs

·         EDM pool

·         Dynamic SQL Caching

o        Batch Concurrency

·         Commit Freqeuncy

·         Row vs page level locking

·         Partitioning

·         Non-shared temp tables

o        Misc

·         ASCII/EBCDIC

·         Compression

·         Bind Parameters

·         other misc

o        DB2 V6 and 7 Performance Enhancements

o        Batch Capacity Planning

o        Application Specific Tuning

o        Case studies -

·         Payroll

·         Accounts Payable

·         Accounts Receivable

·         Purchasing

·         Billing

·         Online Environment

o        Architecture

·         Evolution

·         2-tier

·         3-tier

·         Understanding the App Server

·         The web client

·         The JMAC client

·         PIA

·         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

·         Client AE batch traces

·         Client COBOL batch traces

·         Client SQR batch trace

·         DB2ODBC trace

o        Caching

o        App Server monitoring & tuning

·         Monitoring commands

·         Compression

·         Spawning

o        Web Server Monitoring and Tuning

o        Application Tuning

·         Optimize for n rows

·         Deferred prepare

·         Search Panels

·         Online performance considerations

·         Static SQL profiling

o        Connectivity parameters & Network tuning

·         DB2 Connect

·         Active/inactive threads

·         Cursorhold

o        Thread monitoring

o        Online Concurrency

o        TCP/VTAM 

o        Online Capacity Planning

o        Workload Manager

o        Parallel Sysplex

o        Back to the Future

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

$1500, which includes all course material and notes

Registration Form

Click on this link to go to the Registration Form

Schedule 2003

SAN FRANCISCO             Feb 3-5

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