Baltimore / Washington DB2 Users Group
BWDB2UG z/OS Quarterly Meeting

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

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

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 An Overview of our Replication Solutions on z/OS and the Analytics Use Case
  Ed Lynch, IBM

Today every business strives to increase customer loyalty and improve employee productivity in an effort to gain a competitive advantage as well as identify new revenue opportunities and cost savings. Many are investigating and/or leveraging Business Analytics as part of this effort. In the past, these efforts have traditionally been leveraged by a small number of internal users, yet the greatest opportunity exists by better enabling customer service and customers to leverage Business Analytics. This brings with it a completely new set of requirements which may require the highest levels of quality of service in areas such as availability, reliability, transaction speed, transaction concurrency, and data latency in the supporting systems infrastructure. Techniques that provide the data infrastructure continue to evolve and include integration of existing data investments with the newly introduced technology options.

This session explores these new requirements and presents options for consideration in defining and building out your Data Warehousing and Business Analytics Infrastructure.

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 A technical update on IIDR's Q Replication
  Jayanti Mahapatra, IBM
  • Recent enhancements
  • Interesting customer use cases
  • Specific performance enhancements
  11:45 - 12:45 Lunch
  12:45 - 2:00 An introduction to replication for availability and GDPS A/A
  Karen Durward, IBM
  • How Q Rep and IMS rep are leveraged for availability
  • Intro to changing availability landscape and why A/A is important
  • Current state and what we're focused on
  2:00 - 2:15 Break
  2:15 - 3:30 Set Yourself Free with Real Time Statistics
  Paul Walters, Navy Federal Credit Union

IBM Real Time Statistics (RTS) will set you free from the chore of scheduling Reorgs and Runstats. RTS can help optimize these processes and provide a vendor neutral solution for these mundane but important tasks.

Objective 1 - Reorg Selection with RTS

  1. What is your existing Reorg Selection process
  2. Reorg indexes independently of Tablespaces
  3. Handle Exception processing

Objective 2 - Runstats Select with RTS

  1. What is your existing Runstats paradigm
  2. Impacts of needless stats collection
  3. Dynamic Statement Cache
  4. Potentially Inflates DSMAX
  5. Optimizer issues when CARDF 0 and how this changes with DB2 V10
  6. Only collect Statistics when an object has had a statistical change in volume

Objective 3

  1. Wrap it all together with an ISPF skeleton
  2. Prioritize objects for Reorganization
  3. Effectively use Deadline time.

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

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

Member Registrations
Non-Member Registrations

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

The Baltimore/Washington DB2 Users' Group
P.O. Box 18554
BWI Airport, Maryland 21240

All pre-registrations must be received by Friday, June 7th, 2013.

Please note: Refunds will not be granted for this seminar for cancellations after this date. However substitution of another person can be made up until the meeting.

Directions to the Sheraton Columbia Hotel
Generate directions via Google Maps
From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.
From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
Speaker Backgrounds
Ed Lynch is an Executive Client Technical Professional specializing in IBM's System z Data Warehousing, Business Analytics, and Information Integration software products. Ed's twenty-eight year career with IBM has spanned many areas of IBM, and has always involved IBM's Information Management (IM) products. His previous roles have included DB2 for z/OS Development and Management, DB2 Technical Marketing, Development and Delivery of IM Product Education, a Principal of Information Integration Design and Implementation Consulting Services, and DB2 Tools & Information Integration Technical Sales.

Currently, Ed is the lead Technical Specialist for North America's System z Data Warehousing and Business Analytics, and Information Integration Software Technical Sales team. Ed has worked extensively with DB2 across the various operating system platforms, InfoSphere Replication Server, InfoSphere Classic Replication Server, DB2 Analytics Accelerator, DB2 DataPropagator, InfoSphere Federation Server, InfoSphere Classic Federation Server, DB2 Connect, IBM Information Server, and IBM's Business Analytics solutions. In his current role, he frequently works with product development to identify and prioritize product requirements, and develop product strategy. He also provides software technical sales support and works extensively with customers to create architectures using these products.
Jayanti Mahapatra is a Senior Software Engineer at the IBM Silicon Valley laboratory with extensive experience in deploying database replication solutions using Infosphere Data Replication products. Infosphere Data Replication is a multiplatform enterprise database application, which allows customers world wide to solve a variety of large scale database availability, failover and warehousing issues. She leads a technical enablement team which provides analyses that help customers to design and implement of solutions for continuous availability of data.
Karen Durward is a product manager within IBM's InfoSphere Information Integration organization specializing in System z solutions. She has held a number of technical and management positions in corporate IT and software vendor environments. Her areas of expertise include data integration strategies and tactics, application development and enterprise IT environments. She holds a BS in Math and Computer Science from the University of New Hampshire and an MBA from Kellogg Graduate School of Business at Northwestern University.
Paul Walters (Navy Federal Credit Union). Paul has over 20 years of application design and development experience using and exploiting DB2 for z/OS. Paul has performed roles in application support, architecture and new product development. Currently, Paul is working as a DB2 Database Administration at Navy Federal Credit Union with a focus on performance and exploitation of DB2 features. Paul was a speaker at IDUG NA speaker in 2010, 2009 and 2008 and on the IDUG NA CPC in 2011 and 2012.
Have a topic?
The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.