Bio

Consulting Services

Webinars

Monitoring, Optimizing,
Configuring,
Architecture
Guide

White Papers

Conference Presentations

Customer List & References

Resumes

Contact Us

WEBINAR 3 - CONFIGURING PSE APPLICATIONS ON DB2 UDB for z/OS

z/OS Platform Considerations

CPU availability

zIIP Specialty Engines

IFL Specialty Engines

WLM/Dispatching Priority

Workload Manager

Parallel Sysplex

ESS

USS Configuration

Call Attach Facility

Resource Recovery Services Attachment Facility

System Backup/Restore

DB2

Multi-Subsystem strategy

System Objects

Bufferpools

Buffer pool Page fixing

EDM Pool

DB2 Version 7

DB2 Version 8

Dynamic SQL caching

IRLM

RID pool

Sort pool

DSMAX

DB2 Catalog

CPU

I/O

Virtual Storage

Real Storage

CISize

Zparms

DDL Objects

Databases

ASCII and EBCDIC

UNICODE

Running COBOL in a z/OS Unicode Environment

Tablespaces

Smartextents

Define No

Page size

Segsize

Locking Parameters

NUMLKTS

NUMLKUS

LOCKSIZE and LOCKMAX

Isolation Level

CURRENTDATA

Lock Avoidance

Overflow Lock Avoidance

Evaluate Uncommitted

Skip Uncommitted Inserts

Acquire/release

Partitioning

DB2 V8 Partitioning

DB2 V9 Partitioning

Lockpart

Partitioning Key Update

Compression  

Table space logging

Tables

Temporary Tables

Introduction

COBOL non-shared temp tables

AE multi instance Temporary Tables

What are they

How are they defined

How are they stored in Tools tables

Setting the number of instances

Managing abends

Runstats techniques

Other techniques

Multiple Plans

Partitioning

Global Temporary Tables

Indexes

Deferred indexes and table access  

Index page sizes

Bind Options

Bind Options for PTPSQLRT / DB2 connect/ SQR

Defer(Prepare)

PTPSQLRT/SQR

DB2 Connect/USS

Keepdynamic

MAXKEEPD

Acquire/Release

Isolation Levels

CurrentData

Reopt

File Server

Application Server Tuning for DBA’s

Architecture

Domains

Application server components and server processes

Services

Listeners, Handlers, and Queues

Configuration

Tuning

Web Server Architecture for DBA’s

Architecture

Server Software Elements  

System Software

PeopleSoft Software

Web Browser

Configuration Options

Logical Application Server Configuration

Deployment Options

PeopleTools Base Portal

Development Environment

Integration Technologies

PeopleSoft Integration Broker.

PeopleSoft Component Interfaces.

PeopleSoft Business Interlinks.

Tuning

Process Scheduler  for DBAs

Configuration

Communications Hardware and Software

Architecture

Concepts to use for analysis:

Topology

Traffic

Reliability

Communications cards

DB2 Connect

Configuration

DB2CLI.INI settings

Static SQL Profiling

DB2 Threads

Definitions

ALLIED threads:

DBAT threads:

IDTHTOIN and thread timeouts

2-tier mode

3-tier/PIA mode

IDTHTOIN

TCP/IP keep_alive

Sleep Times and scan intervals

Connection Pooling and POOLINAC

Accounting trace instrumentation enhancements

  Info at db-consulting.com