Articles & Content


demystifying JDBC Universal Drivers - for the z/OS DBA (F02)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2010

DATE: 2010-5-11 (01:45 PM - 02:45 PM)
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


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.