IDUG Meeting featuring IDUG 2013 Speakers

SIRDUG Meeting April 18th, 2013

SIRDUG is very pleased to announce that the first 2013 SIRDUG meeting on April 18, will feature Robert Catterall from IBM, Mary Beth Jeffords, Sally Mir and Paul Turpin.

Robert Catterall will give us a preview of his 2013 North American IDUG conference presentation, "The 2013 DB2 for z/OS Database Diet".


Mary Beth Jeffords will be presenting a DB2 for z/OS session, "Distributed Workloads: Moving to zNALC Now".

Sally Mir will be presenting a DB2 for z/OS session, "Suit Yourself! Customize Your Own Omegamon Reports".

Paul Turpin will be presenting a DB2 for LUW session, "Prospecting for Gold Nuggets in DB2 10.1.".


The IDUG DB2 Tech Conference in Orlando, Florida will be held April 29th through May 3rd. If you are not able to attend this year's IDUG North America Conference, this is your opportunity to catch a piece of the action.
To see details about the IDUG DB2 Tech Conference click here




Meeting Details


WHEN? Thursday, April 18th, 2013

WHERE? Baxter Hood Center (Rock Hill, SC)

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


Tentative Meeting Agenda


Meeting Agenda 8:00 - 8:50 - Registration - Coffee, Danish, and Networking 8:50 - 9:00 - SIRDUG announcements and speaker introductions 9:00 - 10:15 - Robert Catterall - The 2013 DB2 for z/OS Database Diet 10:15 - 10:30 - Mid-Morning Break 10:30 - 12:00 - Mary Beth Jefford - Distributed Workloads: Moving to zNALC Now 12:00 - 1:00 - Lunch 1:00 - 2:10 - Sally Mir - Suit Yourself! Customize Your Own OMEGAMON Reports 2:10 - 2:25 - Mid-Afternoon Break 2:25 - 3:35 - Paul Turpin - Prospecting for Gold Nuggets in DB2 10.1 3:35 - 3:45 - SIRDUG business , Adjourn


Registration

To pre-register please use our new online registration form at:
meeting registration form
or
email registration@sirdug.org 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, Monday, April 15th.
We need to provide a list of attendees to Lowes security, so we need
everyone to pre-register.  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 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.


Directions to Baxter Hood Center (Rock Hill, SC)

The Baxter Hood Center
452 S. Anderson Road
Rock Hill, SC 29730
803-981-7100

Less than 2 miles from I-77 & Dave Lyle Blvd intersection (south side of Charlotte).



Presentations for Download



To download Robert Catterall's "The 2013 DB2 for z/OS Database Diet" (264 KB)
click here

To download Mary Beth Jefford's "Distributed Workloads: Moving to zNALC Now" (13 MB) click here

To download Sally Mir's "Suit Yourself! Customize Your Own OMEGAMON Reports" (13.5 MB) click here

To download Paul Turpin's "Prospecting for Gold Nuggets in DB2 10.1" (3 MB) click here


Robert Caterall's Biography

Robert Catterall is an IBM DB2 for z/OS specialist. 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, a member of IDUG's Speakers Hall of Fame, and was one of IBM's inaugural Information Champions. He presents frequently at conferences, is a longtime columnist for IBM Data Management Magazine, and blogs about DB2 for z/OS at http://robertsdb2blog.blogspot.com/.

Title: "The 2013 DB2 for z/OS Database Diet"

Presentation Platform: DB2 for z/OS

Abstract

In 2003, I delivered a presentation at IDUG conferences titled, "Put Your Database on a Diet," which described various techniques to reduce the CPU and disk space consumption of a DB2 for z/OS workload. In the 10 years since, new DB2 for z/OS efficiency-boosting techniques have emerged. I will be highlighting several of these in this presentation, including methods of index trimming and upgrading, buffer pool configuration optimization, thread management, memory management, and SQL statement tuning.


Sally Mir's Biography

Sally Mir has worked with DB2 for z/OS since 1990, with a few years of DB2 for LUW thrown in. She has experience with all aspects of DB2, including system and application performance monitoring and tuning, application support, and developing enterprise-wide guidelines for best practices. Her extensive technical knowledge of DB2 for z/OS has allowed her to present creative solutions to complex technical requirements and problems. She is currently a DB2 Systems Programmer at BB&T in Winston-Salem, NC.

She is also an accomplished opera singer, and can be seen and heard in local concerts, operas and oratorios.

Sally has been a speaker/presenter at several regional and International DB2 User Group conferences in North America as well as in Europe.


Title: "Suit Yourself! Customize Your Own OMEGAMON Reports"

Presentation Platform: DB2 for z/OS

Abstract:

IBM's Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS is more than an online monitor. The reports that it produces are an invaluable tool in analyzing application and subsystem performance. We will look at how to get the most out of these reports.
This presentation will cover the Omegamon accounting report, starting with the standard long layout, looking at some of the major fields. There are various ways to organize the data in these reports, each giving a new and insightful view into the performance of your application. The ISPF interface offers a wealth of options, eliminating the need to remember syntax and keywords. And if the standard reports and options don’t meet your needs, you can customize your own report, selecting only the items that you need to see.

Objective 1: The accounting report contains a great deal of important information about application performance. We will look at some of the major report blocks and discuss the meanings of some of the fields and what to look for.
Objective 2: Besides the default order, there are many ways to group and report on the data in the accounting report. Looking at it in different ways can provide different insightful views into your performance information.
Objective 3: Why bother with having to remember complex syntax and keywords? The ISPF interface easily generates report control statements for any and all types of reports. Execute the report right away or save the JCL for later.
Objective 4: Is the long report too long, or the short report too short for you? Customize your own report, containing exactly the accounting fields that you want to see.
Objective 5: There are many other tips and tricks that are helpful in the use of Omegamon reporting.


Paul Turpin's Biography

Speaker Bio: Paul Turpin is a senior database administrator for a software development company specializing in financial applications. 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 on the IDUG Board of Directors.

Title: "Prospecting for Gold Nuggets in DB2 10.1"

Presentation Platform: DB2 for Linux, UNIX, Windows

Abstract:

There are many great features in DB2 10.1, that have gone un-noticed. Just like prospecting for gold, digging out the features can be challenging and very rewarding. A number of performance features have been added including usage iists that are extremely useful for understanding how indexes are used. Several new table monitoring functions and a change history event monitor have been added and several monitoring functions have been enhanced. I will also show you how to search for your own nuggets in DB2 10.1.

Objective 1: How to search for the nuggets
Objective 2: Finding how indexes are used with Usage Lists
Objective 3: Using the change history event monitor
Objective 4: New utility features, including INDEXSAMPLE in runstats
Objective 5: Using the new monitoring functions, like MON_GET_MEMORY_POOL, MON_GET_PAGE_ACCESS_INFO, and MON_GET_TRANSACTION_LOG. Using the new functionality in functions like MON_GET_BUFFERPOOL and MON_BP_UTILIZATION


Paul Turpin's Biography

Speaker Bio: Paul Turpin is a senior database administrator for a software development company specializing in financial applications. 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 on the IDUG Board of Directors.

Title: "Prospecting for Gold Nuggets in DB2 10.1"

Presentation Platform: DB2 for Linux, UNIX, Windows

Abstract:

There are many great features in DB2 10.1, that have gone un-noticed. Just like prospecting for gold, digging out the features can be challenging and very rewarding. A number of performance features have been added including usage iists that are extremely useful for understanding how indexes are used. Several new table monitoring functions and a change history event monitor have been added and several monitoring functions have been enhanced. I will also show you how to search for your own nuggets in DB2 10.1.

Objective 1: How to search for the nuggets
Objective 2: Finding how indexes are used with Usage Lists
Objective 3: Using the change history event monitor
Objective 4: New utility features, including INDEXSAMPLE in runstats
Objective 5: Using the new monitoring functions, like MON_GET_MEMORY_POOL, MON_GET_PAGE_ACCESS_INFO, and MON_GET_TRANSACTION_LOG. Using the new functionality in functions like MON_GET_BUFFERPOOL and MON_BP_UTILIZATION


SIRDUG Home Page

Last Update: April 19, 2013

9

Copyright © 2013 SIRDUG Inc. All rights reserved.