JDBC "How to" series part 1: How to use WLM with the DataDirect Connect for JDBC DB2 driver

JDBC "How to" series part 1: How to use WLM with the DataDirect Connect for JDBC DB2 driver

July 27, 2007 0 Comments

Welcome to the new DataDirect JDBC Blog! This is my first post; however, rather than spending the first post exchanging pleasantries I would instead like to dive right into something with some real substance: a “How to” series highlighting answers to some of the questions I encounter on a regular basis. In Part 1, I will answer the question: “How do I use WLM on zOS with our DataDirect Connect for JDBC DB2 driver?”

WLM is the Work Load Manager for zOS. The purpose of WLM is to allow a user to specify performance goals and assign business importance to each goal. For instance, if you want to ensure that 70% of the transactions using the Connect for JDBC driver complete within 1 second, you would use WLM to configure a rule to do so. WLM keeps track of the work running on the system and configures system resources to try and meet these goals in the most efficient manner possible.

In order to create such a rule for the DataDirect Connect for JDBC DB2 drivers, you must set the subsystem type to DDF. You can then use any of the following 5 qualifier types to custom tailor your rule:

Qualifier Type Value for the Connect for JDBC DB2 Driver
PK (package name) All JDBC driver packages start with DDJ
CI (correlation info) JDBC4DB2
CN (collection name) default is NULLID, this is configurable via the packageCollection connect option
UI (user id) The userid specified in the URL or DataSource
PN (plan name) We use the default plan, usually DISTSERV

Armed with this knowledge, you can use WLM to create performance goals on zOS for the Connect for JDBC DB2 driver today. I would like to give many thanks to Gregg Willhoit, Chief Software Architect for our Shadow products, for expanding my zOS and WLM education as well as providing insight and guidance to this post.

Tech Tags:

Jesse Davis

Jesse Davis

As Senior Director of Research & Development, Jesse is responsible for the daily operations, product development initiatives and forward looking research for Progress DataDirect. Jesse has spent nearly 20 years creating enterprise data products and has served as an expert on several industry standards including JDBC, J2EE, DRDA and OData. Jesse holds a bachelor of science degree in Computer Engineering from North Carolina State university.

Comments are disabled in preview mode.