Baltimore Washington DB2 Users Group Meeting - Wednesday, June 13th, 2018

Henry Nalven

Baltimore Washington DB2 Users Group Meeting - Wednesday, June 13th, 2018

BWDB2UG z/OS Quarterly Meeting

When? Wednesday, June 13th, 2018, 9:00AM-3:30PM (registration at 8:30)

Where? Hilton Baltimore BWI Airport Hotel, 1739 W Nursery Rd, Linthicum Heights, MD 21090

Meeting Fees: 
Pre-registered members: $30 
Pre-registered non-members: $40 
At-the-door for members: $40 
At-the-door for non-members: $50

Meeting Schedule:

  8:30 - 9:00 Registration  

  9:00 - 10:15 Revival of the SQL Tuner Sheryl M. Larsen , BMC Software  

The pool of DBAs with SME knowledge of SQL tuning has shrunk dramatically while the number of SQL statements needing attention has grown and will continue to grow. DB2 performance tooling can help identify what needs to be tuned. But what do you do then? This presentation will help fill the skills gap by reviving the role of an SQL Tuner. Specifically, you will learn what access paths are good for what types of queries, what indexes are best, and how to change the DB2 optimizers mind.

Objective 1: Witness the access path choices with graphic animations and understand which paths are good/bad for certain queries
Objective 2: Learn how to read a visual EXPLAIN
Objective 3: Learn how to use traditional query tuning techniques
Objective 4: Learn how to experiment with more extreme tuning techniques
Objective 5: identify SQL tuning opportunities and fix them with confidence

   10:15 - 10:30 Coffee Break   

   10:30 - 11:45 How To Get 10 Pounds of LOB in a 5 Pound Bag Jim Dee, BMC Software  

LOB compression is one of the more interesting features of Db2 12. It promises performance gains for your application that use LOB's, coupled with disk savings! This presentation provides an overview of the feature, and discusses some of the performance characteristics. Then we move on to pros and cons, and a process for taking advantage of the feature.

   11:45 - 12:30 Lunch   

   12:30 - 1:45 Using SQL to Generate SQL/DDL Veasna Tauch, Airline Tariff Publishing Company (ATPCO)  Use SQL to generate DBA tasks to accelerate the development process in your organization.   

   1:45 - 1:55 Break   

   1:55 - 2:15 DB2 12 – 12 months agile production experience with more focus on the Data and less on the base Ulf Heinrich, SEGUS Inc.  On October 21st 2016 Db2 12 went GA and several customers have quickly started to take a look at this new version. About a year ago some migrated their production systems and started to gain real life experience. In July IBM also decided to do a massive rebranding throughout the z – ups, sorry – the Z portfolio. Db2 since then comes with a lowercase b, to place all emphasis on "Data"—your data. With all of this in mind we’ve created this presentation, bundling a year of experience to share best practices and tips for the Data-focused, agile database.

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link at and follow directions; then send us an email to let us know the names of everyone in your group who will be attending.

2) To pay by check, mail the check with attendee and company name to:

NOTE: New Address 

The Baltimore/Washington DB2 Users' Group
P.O. Box 1027 
Owings Mills, Maryland 21117


Henry L Nalven

[login to unmask email]