Articles & Content


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

Topic: 2010 EMEA

Subtopic: DB2 for z/OS

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


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

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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