DB2 for z/OS - performance del SISTEMA

Massimo Macera

DB2 for z/OS - performance del SISTEMA
Miei cari Studenti del DB2 z/OS,

desidero segnalarvi una edizione EXTRA CATALOGO del corso:

Durata 3,5 giorni

Sede MILANO (via Siusi 2/1 - METRO PIAZZA UDINE)
DAL 25/10/2005 (09H30)
AL 28/10/2005 (12H30)

Il corso sara tenuto in lingua italiana direttamente dallo sviluppatore
Bernhard Baumgartner. Chi vuole può iscriversi direttamente dal sito
Education IBM


Seguono alcuni dettagli:

After completing this course, you should be able to:
o Understand how pools and caches work
o Understand how traces work
o Do a top-down performance analysis
o Analyze a statistics report.

o DB2 address spaces, pools, caches, and control blocks
o The stealing algorithms for pools and caches
o Checklist for pools and caches
o DB2 traces
o Basic queuing theory
o Workload Manager goal mode
o Response time analysis with accounting trace
o Alarm limits (queuing and system overhead)
o SQL CPU time and CPU queuing time
o Multiprocessor support: IMS versus CICS
o IMS MPR queuing time
o Five ways to reduce synchronous read time per transaction or batch job
a. Reduce drive queuing time (RAID-5)
b. Reduce IOS queuing time (with or without PAV)
c. Reduce the number of SRs by database buffer pool tuning
d. Reduce the number of SRs by application tuning
e. Reduce DIO/SR ratio by disk cache tuning
o Asynchronous read (prefetch) with RAID-5 disk subsystems
o Lock waits
o Miscellaneous contributors to SQL time (logging, VSAM, and so on)
o Elapsed time between SQL calls
o Capacity analysis (bottlenecks versus response time)
o Massive batch concurrent with critical transactions
o Statistics report analysis
o Statistics checklist

Realistic Case Studies
The examples and lab exercises are based on performance reports
from medium-sized and large production systems with a current

What Is Not Included
Although many of the case studies come from installations using
data sharing, only global lock contention is discussed. Other
performance issues specific to data sharing, such as group buffer
pools, are not covered.

CG881 is focused on operational applications (transactions and
concurrent batch). The interaction between operational and data
warehouse applications is discussed, but not data warehouse issues,
such as star join performance.

Massimo MACERA
IBM Certified Education Specialist, Instruction and Mentoring
DB2 for z/OS + Data Warehouse
Learning Profession Leader, South Region
IT Education Services - Roma, Italy
office +39 06 59 66 52 44
Benvenuti alla lista DB2 User Group Italia.Per annullare l ' iscrizione collegarsi a : http://www.idugdb2-l.org/archives/DB2-UG-Italy.html. Selezionare "Join or Leave the list". Per consultare le IDUG Listserv FAQ collegarsi a :http://www.idugdb2-l.org. L'amministratore della lista DB2 User Group - Italy può essere raggiunto al seguente indirizzo: [login to unmask email] Per sapere le ultime novità sulle conferenze IDUG potete consultare : http://conferences.idug.org/index.cfm