DB2 10 for z/OS Distributed Environment Performance Topics

Session Number: 9906
Track: General I (E)
Session Type: Podium Presentation
Primary Presenter: Paolo Bruni [IBM ITSO/Redbooks]
Time: Nov 16, 2011 (11:00 AM - 12:00 PM)
Room: Tycho

Speaker Bio: Paolo Bruni is a DB2 Information Management Project Leader at the International Technical Support Organization based in the Silicon Valley Lab. He has authored several IBM Redbooks publications about DB2 for z/OS and related tools and has conducted workshops and seminars worldwide. During Paolo's many years with IBM, in development and in the field, his work has been mostly related to database systems.
Audience experience level: Intermediate
Presentation Category: Managing Database Resources
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Data Architects, Database Administrators, Systems Programmers
Technical areas this presentation will apply to: Connectivity, Information Integration and Replication, Database Performance (DB2 for z/OS)
Objective 1: The new high performance DBAT
Objective 2: The renaissance of type 2 drivers
Objective 3: New option to pass data back to the stored procedures client
Objective 4: CPU and storage distributed workloads measurements
Objective 5: LOBs and XML DDF-DBM1 materialization avoidance

Abstract:  This presentation provides performance observations, based on lab measurements, of the following DB2 10 for z/OS distributed topics:
High performance DBATs
Limited block fetch extended to the JCC Type 2 drivers
Return to client result sets
Enhanced support for native SQL procedures
Extended correlation token
Virtual and real storage with distributed IRWW workload
LOBs and XML materialization avoidance