December 11 SIRDUG meeting featuring ??

Download presentations

To download Robert Catterall's "Modern DB2 for z/OS Physical Database Design" click here

To download Donna Pearce's "A DBA Experience with Testing and Implementing IDAA" click here

To download Elwin Harrison's "Converting COBOL to SQL PL" click here

To download Paul Turpin's "db2batch Tips and Tricks" click here

Meeting Details

The SIRDUG officers are very happy to be bringing SIRDUG out of a long hiatus with an exciting meeting featuring Robert Catterall. ? will also be giving presentations at the event.

WHEN? December 11 (Friday)

WHERE? 8505 IBM Drive, Charlotte, NC 28262, The Innovation Park Charlotte (An old IBM Main Site) See directions below

COST? $10 cash or check, at the door.
We do not accept credit cards.

Meeting Agenda

December 11 (Friday)
Featured Speakers - Robert Catterall, Donna Pearce, Elwin Harrison, Paul Turpin
Tentative Schedule

 8:00 -  9:00   -  Registration - Coffee, Danish, and Networking
 9:00 - 10:00   -  Donna Pearce - "A DBA Experience with Testing and Implementing IDAA"
10:00 - 10:15   -  Break
10:15 - 11:45   -  Robert Catterall - "Modern DB2 for z/OS Physical Database Design"
11:45 - 12:45   -  Lunch
12:45 -  2:00   -  Elwin Harrison - "Converting COBOL to SQL PL"
 2:00 -  2:15  -   Break 
 2:15 -  3:30  -   Paul Turpin - "db2batch Tips and Tricks"


To pre-register please use our new online registration form at:
meeting registration form
email and give us your name and company. If you are not already on our distribution list and wish to be, include your email address and phone number.

If you do not wish to continue receiving these occasional notices, please indicate that in your registration email.

Pre-registration must be completed by Midnight, Friday, December 6th. Please feel free to invite others from your company (just make sure they pre-register as well). If you know others in your company who are interested in attending future SIRDUG events, please encourage them to become members of our distribution list (we just need their names, email addresses and phone numbers).

Registration Note
SIRDUG will be calling or emailing a confirmation for each person who pre-registers by the deadline. If you have pre-registered and have not received a confirmation by the day after the deadline, please notify us as your registration may not have been received.

If you have not pre-registered by the deadline, you may pre-register after the deadline or register at the door, but the availability of presentation handouts and lunch can not be guaranteed and confirmations will not be sent.

Directions to facility:

Meeting Address: 8505 IBM Drive, Charlotte, NC 28262, The Innovation Park Charlotte (the old IBM Main Site)

Use the address 8505 for Google Search.
From Interstate 85N or 85S, take EXIT 45B then turn right, you will be on the W.T., Harris Bvld, merge to left lane (not the one to exit back to Interstate 85), turn Left at next traffic light, it will be the IBM Drive, Address 8505 will be on the Right.

Enter Entrance 1 of the Innovation Park, the one after the Wells Fargo Entrance.

The meeting room is inside building 8335.

The map below shows the parking lot to use.

After parking, look for SIRDUG meeting signs along the entrance to the meeting place.


This map shows parking spots in orange highlights and the path from parking lot to building highlighted in orange color

To download the campus map with Orange Color highlights click here

To download the campus map click here

To download the site amenities document click here

What door to enter?
This information will be provided later.

Robert Catterall's Biography

Robert Catterall is a Consulting DB2 for z/OS Specialist with IBM. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent DB2 consultant, he rejoined IBM in 2010. Robert is a past President of IDUG, and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences, and blogs about DB2 for z/OS at

Title: "Modern DB2 for z/OS Physical Database Design"

DB2 for z/OS physical database design has changed with the introduction, via recent DB2 releases, of new options that DBAs can exploit to improve performance, availability, and security - without requiring application code changes. This session will provide information on leveraging features related to data partitioning, table space type, data organization, LOB management, data protection, index design, data archiving, and more.

Bullet Points:
1. Learn about the different options for partitioning data in a table, and making the right partitioning choices for a given table.
2. Learn about the importance of getting to universal table spaces, and how to get there.
3. Learn about "security views" versus row permissions and column masks, and when you might want to use one instead of the other to protect data.
4. Learn how to leverage recent index enhancements such as larger page sizes, INCLUDE columns, and index-on-expression.
5. Learn how to leverage recent table-related enhancements such as LOB in-lining, hash-organization of tables, and DB2-managed data archiving.

Presentation Category: Application Design, Data Management, Data Warehousing and Business Intelligence, Emerging Technology, Implementing New DB2 Releases and Features, Managing Availability, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for z/OS

Donna Pearce's Biography

Donna Pearce is a Senior Database Analyst with Blue Cross Blue Shield of South Carolina. Donna serves as a DBA for commercial applications, a DBA lead for the IDAA projects, and holds the DB2 11 for z/OS certification. Donna has 34 total years of experience on Enterprise level servers which includes 18 years as a DBA.

Donna Pearce's Biography

Title: "A DBA Experience with Testing and Implementing IDAA"

As a DBA, we see numerous complaints about long-running queries in our Data Warehouse environment. The IBM DB2 Analytics Accelerator can reduce the CPU and elapsed time of these queries by 50%-90% by offloading eligible queries to run on the IDAA device. Other advantages are a reduction in production job abends due to contention and a reduction in -904 failures due to running out of DB2 work space. There are tools available to help determine the workload that is eligible to run on the device, as well as a GUI tool that is a plug-in to Data Studio. The IDAA Studio can be used to interactively add and manipulate objects on the device as well as monitoring queries that run on the device. An R&D project was used to test the device and develop a process for determining what tables should go on the device, and how to maintain them. Queries started routing to the device immediately after enabling the first table, and the savings have been adding up.

Bullet Points:
1. The Proof of Concept
2. Tools for use with IDAA
3. Advantages of using IDAA
4. How to determine what tables should go on the device -- The Pilot
5. Experience since adding the device in Production

Presentation Category: Data Management, Emerging Technology, Managing Performance
Presentation Platform: DB2 for z/OS

Elwin Harrison's Biography

The speaker has been developing business applications for over 30 years. He has developed DB2 SQL in batch applications; CICS applications, external stored procedures and DB2 Native SQL stored procedures implemented using remote access. He has worked in the federal government, retail, insurance, banking, and mutual fund management; within the IT industry.

Title: "Converting COBOL to SQL PL"

This presentation is designed to give the attendees a basic familiarization to the methods of converting COBOL programs to the DB2 SQL PL language. The attendees will receive information designed to facilitate the conversion of the COBOL programs into DB2 SQL PL. The seminar will give the attendees a glimpse of what can and can not be converted from the COBOL language to DB2 SQL PL.

Bullet Points:
1. To provide the attendees with the understanding of converting COBOL programs into DB2 SQL PL
2. The attendees will learn what can be converted from COBOL into DB2 SQL PL Native SQL Stored Procedures. Using the skills they learned during the seminar.
3. The attendees will learn how to create a DB2 Native SQL Stored Procedure using IBM Data Studio, and add converted COBOL code to the stored procedure.
4. The attendees will learn how to use IBM Data Studio to deploy their DB2 Native SQL Stored Procedure.
5. The attendees will learn how to use IBM Data Studio to perform unit testing of their stored procedures.

Presentation Category: Application Design
Presentation Platform: Cross Platform

Paul Turpin's Biography

Paul Turpin is a consulting database administrator for a large financial institution, supporting SAP. He specializes in DB2 for LUW on large systems. He enjoys exploring new features and functionality in DB2. He has spoken at IDUG North America, IDUG Europe, SHARE, IBM’s Information on Demand conference, and several RUGs. Paul currently serves as the IDUG Treasurer and President-Elect. He was one of IBM's inaugural Information Champions.

Title: "db2batch Tips and Tricks"

db2batch is a very powerful tool, but not always easy to use. It is my favorite performance tool and I want to share my enthusiasm about it. db2batch captures actual timings and other metrics as the query you are testing is running. Some of those metrics are SQL execution timings, plus a number of metrics including CPU time, sort information (number of sorts, sort time, sort overflows), rows read, rows written, rows updated (and inserted and deleted), rows fetched and bufferpool usage details. In addition an explain can be captured at the time of execution. db2batch can work with SQL with literals or parameter markers. This presentation will teach you how to use the numerous db2batch parameters. It will also show the difference in using db2batch with SQL with literals and SQL with parameter markers.

Bullet Points:
1. Important db2batch options
2. How to do a snapshot in db2batch
3. How to use with literal SQL queries
4. How to use with parameter marker queries
5. How to interpret db2batch output

Presentation Category: Application Design, Data Management, Data Warehousing and Business Intelligence, Emerging Technology, Implementing New DB2 Releases and Features, Managing Availability, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for z/OS

If you have any links that you would like to see on our pages, send SIRDUG an EMAIL using our mail box below.


SIRDUG Home Page

Last Update: October 25, 2015

Copyright © 2015 SIRDUG Inc. All rights reserved.