St. Louis DB2 Users Group – Sept 9, 2014 Meeting

StlDUG 9/9/2014 Meeting - Agenda

St. Louis DB2 UserGroup Meeting

September 9, 201408:30AM – 03:30PM

ibm.biz/STLDUG_Registration

StlDUG Leadership TeamTed Achelpohl, MasterCardPaul Bartak, IBMKurt Bruhn, BJCSrinivas Chaganti, Wells FargoBabu Chellappa, UnigroupTom Glaser, MasterCardFred Shumake, MetLifeJason Taylor, IBM

Location: Metlife13045 Tesson Ferry RoadSt. Louis, MO 63128

Agenda:Room 107C Topics Speakers

08:30A - 8:45A Doors open / Refreshments available

08:45A - 9:00A Introductions, Opening Remarks, IBM News,StlDUG Business

Tom Glaser, MasterCardPaul Bartak, IBM

Room 107C DB2 for z/OS Track

09:00A - 10:15A DB2 10 and 11 for z/OS - Implementing andUsing Autonomic Statistics

John Iczkovits (IBM)

10:15A - 10:30A Break

10:30A - 11:45A What Every DB2 for z/OS Professional Needs toUnderstand about IBM Disk and TapeVirtualization

John Iczkovits (IBM)

11:45A - 12:45P Lunch – Sponsored by IBM

12:45P - 02:00P DB2 and Storage Management Craig Mullins (softwareon z)

02:00P - 02:15P Break

02:15P - 03:30P DB2 for z/OS Performance & Tuning Mike Wingfield(Compuware)

Indicates a link to the presentation @ STLDUG dW Community

For questions, contact Tom Glaser (tom_glaser@mastercard.com)

St. Louis DB2 Users Group – Sept 9, 2014 Meeting

StlDUG 9/9/2014 Meeting – Sessions

DB2 10 and 11 for z/OS - Implementing and Using Autonomic Statistics.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 actualimplementation however is not straight forward. Come to this presentation and learn howto successfully implement and review the output for this new feature.John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Skills. Heprovides DB2 for z/OS technical support and consulting services. His areas of expertiseinclude DB2 data sharing, performance, and availability. His work in IBM includesexperience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist,Consultant, and project lead. He has 31 years of IT experience, ranging from databaseproducts such as DB2 and IMS to MVS systems support, including storage management.He has also co-authored IBM Redbooks, red papers, white papers, trade magazinearticles, and presented at SHARE, the DB2 Tech Conference, the Information OnDemand Conference, zEXPO Conference, IBM System z Technical Symposium, CMG,IDUG, and at local DB2 users groups.

Every DB2 for z/OS Professional Needs to Understand about IBM Disk andTape VirtualizationModern disk and tape does not resemble older technology. What is the real pictureregarding modern disk and tape? How does the newer technology change the managementof your DB2 environment? How does performance change? The real question is, why do Icare about this new technology? Come and find the answers regarding the new technology,and how to best leverage it for your DB2 environment.John Iczkovits

St. Louis DB2 Users Group – Sept 9, 2014 Meeting

StlDUG 9/9/2014 Meeting – Sessions

DB2 and Storage Management.Every DB2 professional knows that the database management system relies on storagemechanisms to persist data. Without disk devices there would be no place to store ourDB2 data. On the surface, it may seem easy to understand that DB2 uses VSAM lineardata sets to house its data. But under the surface lies complexity that can be difficult todecipher.This presentation will look into various aspects of storage management with respect toDB2. It discusses the gap between the Database Administration and StorageAdministration (DASD) and offers guidance to bridging it. Along the way we’ll look at:

– DB2 and DFSMS– Modern Storage Architecture (RAID)– Newer DB2 Storage Features– Best Practice Guidance for Managing DB2 Storage

Craig Mullins is a data management strategist, researcher, and consultant. He ispresident and principal consultant of Mullins Consulting, Inc., a principal withSoftwareOnZ (a mainframe software distributor), and the publisher/editor forTheDatabaseSite.com.Craig has more than three decades of experience in all facets of database systemsdevelopment and has worked with mainframe DB2 since V1. You may know Craig fromhis popular books:

DB2 Developer's Guide, 6th edition – containing more than 1500 pages of in-depth technical information on DB2 for z/OS

Database Administration: The Complete Guide to DBA Practices and Procedures,2nd edition –the industry's only comprehensive guide to heterogeneous databaseadministration.

Craig has been named by IBM as a Gold Consultant and an Information Champion. Hewas recently named one of the Top 200 Thought Leaders in Big Data & Analytics byAnalyticsWeek magazine (http://analyticsweek.com/top-200-thought-leaders-in-bigdata-analytics/).

St. Louis DB2 Users Group – Sept 9, 2014 Meeting

StlDUG 9/9/2014 Meeting – Sessions

Mainframe DB2 for z/OS Performance & TuningMainframe Application Performance Management has become even more imperativetoday with processor speeds approaching the theoretical limit of 7 GHZ. So justthrowing hardware at performance problems is not enough anymore. Applicationresponse times and runtimes need to be tuned to run as efficiently as possible and oftentimes when DB2 is a big player in the application, that is where most of the performanceopportunities will be found. We will look at several DB2 tuning opportunities in CICS,Batch, and DDF; analyzing the SQL Text, the DB2 Access Paths, and the DB2 CatalogObjects involved.

Mike Wingfield has been in IT for over 35 years and has been working with DB2 sinceVersion 1.1 in 1987 as a programmer, DBA, Tech Support, Data Modeler, Data Architect,and for the last 20 years as a DB2 Performance and Tuning Specialist. Mike has beenutilizing Strobe since 1991 and has documented mainframe operating cost savings ofover 50 million dollars using Strobe from 1994 through 2001. Mike retired from U SWEST (which became Qwest Communications and now Century Link) after 30 years ofservice.As a Strobe Solution Consultant for the last 10 years in Compuware’s Field TechnicalSupport, Mike takes part in Application Performance Assessments for many Strobecustomers throughout North & South America, Asia/Pacific, and Europe analyzing Batch,Onlines, Stored Procedures, and DDF performance with Strobe and iStrobe andproviding recommendations for runtime and response time improvements.

St. Louis DB2 Users Group – Sept 9, 2014 Meeting

StlDUG 9/9/2014 Meeting – Locations and Directions

Location:

Location: Our event is being held at the MetLife campus in a southwesternsuburb of St. Louis. MetLife has been an excellent sponsor of our events and hassponsored several of our regular quarterly meetings.

The address is:

MetLife13045 Tesson FerrySt. Louis, MO 63128

Note that the campus is set back from Tesson Ferry, and is located a few milesWest of I-270.

Directions:From Interstate 270 / 255:Take I-270 (South) to Highway 21/Tesson Ferry (South). Right onto Hwy 21/Tesson Ferry. From the East (I-55 or Illinois), take I-255 / 270 (West) to Highway 21/Tesson Ferry (South). Left onto Hwy 21/TessonFerry. Take Tesson Ferry Road approx. 1.4 miles to Butler Hill Spur (You will travel to the fifth traffic lightafter the highway exit. There is a Bank on the right.) Turn right off of Tesson Ferry Rd and continuestraight into our main entrance.The main entrance is easily located by looking for the tall flag poles and cobblestone road.Park in the visitors' area (cobblestone circle).If the visitors area is full, you may proceed to the back parking lot, but you will need to walk back aroundto the main entrance.The reception area is immediately inside the main entrance.

EntrancesLobby

LimitedVisitor Parking

Parking