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

 

 

 

WEBINAR 4 - OPTIMIZING PSE APPLICATIONS ON DB2 UDB for z/OS

Batch Performance Tuning Perspective

Online Performance Tuning Perspective

The Art of Tuning

DB2 Environment Tuning  

The basics of Access Path Tuning

Concurrency

Commit frequency

Tablespace scans

Non-matching Index scans

Page vs Row locking

Lock Escalation

PSLOCK

NEXT processing

Small Control Tables

Large Updateable Master Tables

PSQuery

How do you Debug Lock Contention

Oracle

Runstats

Fast cached SQL statement invalidation

Real-time statistics

Reorg  Criteria

Using Real-time Statictics tables

Using Reorg Utility

Using Runstats Tables

SQL

Subqueries

Distinct in Queries

Parallel I/O

Optimization Hints

Bind Variables Vs Literals

Explainallcache

Unequal Length Joins

Varchar Indexes

Join Order

More tables in joins

Backward index scan

Multi-row fetch and insert

Non-correlated EXISTS subquery enhancement

Multiple IN values

Techniques to Influence the Optimizer

PeopleSoft Environment Tuning

Static/Dynamic SQL

Normal/Persistent Cursors

Reduced use of Persistent Cursors in DB2 UDB for z/OS with PT8.46

Dedicated Cursors and Reuse

COBOL

SQR

Application Engine

Connects/disconnects

Case Sensitive Searching  

Query Access List Cache

SQR

 

dbcs home page  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