Articles & Content

Archives

De-mystifing JDBC Universal Drivers - for the z/OS DBA (B02)

Topic: DB2 for z/OS

Subtopic: 2010



DATE: 2010-11-8 (13:30 - 14:30)
SPEAKERS: Billy Sundarrajan (Fifth Third Bank)

With the prevalence of web applications, and DDF becoming a predominant method of accessing data in DB2 for z/OS, the boundaries between the z/OS DBA and the DB2 drivers continue to shrink. Understanding a DDF connection from end-to-end is becoming key to the success of a mainframe DBA. DBAs are faced with the challenges of understanding how DB2 drivers interact with DB2, and understand the concepts of connection pooling from the application servers and type-4 drivers. This presentation provides an introduction to the type-2 and type-4 drivers, connection pooling, and key parameters and zparms are enabling connection pooling, and how to write a sample java program for connecting to DB2 on z/OS using a type-4 universal driver

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Introduction to various types of drivers - CLI, Universal driver

Understanding key terms: Driver property, property scope, Transport object, transport pool

Tracing and monitoring performance using the universal driver

Enabling sysplex workload balancing and encryption with the type-4 driver

Writing a sample java program to access DB2 on z/OS



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.