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

When? Wednesday, June 11th, 2014, 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 DB2 11 for z/OS is Great! But Why Should You Care?
  Sheryl Larsen, IBM
 
 

Sheryl Larsen, the DB2 for z/OS world-wide evangelist shares many of the insights she has gained in writing efficient and well performing SQL. She explains the stages of SQL processing and filtering and gives practical tips on which predicates might obtain faster results. The steps to review your SQL are outlined. Sheryl also reviews some of the analytic capabilities of SQL statements such as GROUP BY GROUPING SETS, GROUP BY ROLLUP, and GROUP BY CUBE.

 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 Applying DB2 Performance Structures Optimally
  Sheryl Larsen, IBM
 
  Sheryl Larsen, the DB2 for z/OS world-wide evangelist discusses structures and appliances that can be used in conjunction with DB2 to improve performance. She presents information on base table indexes, index on expression, Materialized Query Tables (MQTs), zIIPs, and Accelerated Query Tables (AQTs). Decisions and cases regarding when to use these structures are presented.
 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 DB2 Analytics Accelerator & DB2 Tools Ecosystem
  Saghi Amirsoleymani, IBM
 
 

Saghi will be discussing the enhancing value to the IDAA with the IBM Tools Ecosystem. In addition, key areas will also be discussed such as:

  • Assessment: What is the workload that would benefit from being accelerated?
  • Optimization: How do I monitor and optimize a workload to take advantage of the Accelerator?
  • Administration: Can I manage the Accelerator more effectively?
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 DB2 10 and 11 for z/OS - Implementing and Using Autonomic Statistics
  John Iczkovits, IBM
 
  DB2 10 and 11 have a neat feature, automatically executing RUNSTATS on required objects. By the way, you get to choose when and how to execute RUNSTATS. The actual implementation however is not straight forward. Come to this presentation and learn how to successfully implement and review the output for this new feature.
 

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:

NOTE: New Address

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

All pre-registrations must be received by Friday, June 6th, 2014.

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
Sheryl M. Larsen is an internationally recognized researcher, consultant, lecturer, specializing in DB2, and now works for IBM as the World Wide DB2 for z/OS Technical Evangelist. She is known for her extensive expertise in SQL and has performed detailed DB2 Performance Health Checks for many fortune 500 clients. Sheryl has over 25 years’ experience in DB2, has published many articles, white papers and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of the Midwest DB2 User Group - www.mwdug.org, and a member of the Northern Illinois University Computer Science Alumni Council.
Saghi Amirsoleymani is a Solutions Architect in the Optim Enablement team at IBM's Silicon Valley Lab in San Jose, CA, where she enables customers and partners on IBM Data Studio and Optim technologies. Prior to joining this team, Saghi was part of the DB2 z/OS L2 team. She joined IBM ,after finishing her degree at University Southern California. She has presented on various topics related to Data Studio and Performance at the Information on Demand (IOD) and IDUG conferences, various user groups, and events.
John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Support. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has 32 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, trade magazine articles, and presented at IDUG, SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, IBM System z Technical Symposium, CMG, and at local DB2 users groups.
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.