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 5 - TRACING PSE APPLICATIONS ON DB2 UDB for z/OS

Tracing PSE Batch Programs

Introduction

COBOL

Activating and Interpreting the Traces

Activating the Traces from JCL

Activating the traces from the Process Scheduler

Activating for an individual process

Activating the traces from the Client

Interpreting the PTPSQLRT Statistics Report

Interpreting the SQL Trace

Application Engine

Activating and Interpreting the Traces

Activating the Traces from JCL, or through the Process Scheduler

Activating the Traces from Application Server

Activating traces for an individual process

Activating the Traces from the command prompt

Interpreting the AE Step/SQL trace

Interpreting the SQL/PeopleCode Trace

Interpreting the Batch Timings Report

Using the AE debugger to capture Temp Table data

Remote Call COBOL

SQR

The “-S” trace

The “–DEBUG” Trace

Crystal

PS/nVision

DB2 Calls from USS

Tracing Online Transactions

Activating and Interpreting the 2-tier Windows Client trace

Activating the 2-tier Windows Client trace

Interpreting the PeopleTools online 2-tier trace

Activating and interpreting the 3-tier Windows Client trace

Activating the 3-tier Windows Client trace

Interpreting the PeopleTools online 3-tier trace

Activating and Interpreting the PeopleTools PIA trace

Activating the PeopleTools PIA trace

Interpreting the PeopleTools online PIA trace

Online Trace Summary

2-tier overview

3-tier Overview

PIA Overview

Conclusions

DB2 Traces

Activating the DB2 Server SQL trace

Activating and Interpreting DB2 Accounting and Statistics Traces

Activating the DB2 Accounting and Statistics Reports using DB2 PE

Interpreting the DB2 Accounting Report

Interpreting the DB2 Statistics Report

JES Output and SMF 30 records

Other Tools

Activating the DB2 Connect CLI trace  

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