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
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.
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
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.
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).
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 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/.
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 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.
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.
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.
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
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.
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.