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

When? Wednesday, September 14th, 2016, 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 Recursive SQL for Sanity and Performance
  Veasna Tauch, ATPCO
 
 

In certain scenarios Dynamic SQL statements could get very long and perform poorly, mainly because they are being generated by an application framework, which usually takes a “One Size Fits All” approach. Here is an innovative solution to shorten these long SQL statements and improve the performance with least amount of changes to the applications. We found a simple answer to our challenge by employing the recursive SQL.
We will also present a few other practical applications of recursive SQL we developed so far at ATPCO.

 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 Using Operational Data to Make DB2 more Self Managing
  Tim Willging and Anthony Ciabattoni, Rocket Software
 
  Many DBAs today spend a good portion of their time managing DB2 utilities and schema changes to meet their shops performance and recoverability SLAs. There is a wealth of information made available by the DB2 engine, z/OS and various performance tools to make DB2 maintenance decisions and actions more automatic. Keeping a history of this data can help make better decisions as well. This session will cover new tooling that is available to help DBAs take advantage of this information and more automated decisions on these tasks.
 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 Data Virtualization – Game Changing Technology and its application to DB2 
  Tim Willging and Anthony Ciabattoni, Rocket Software
 
  Data Virtualization can be used to provide more modern access to legacy data “in-place”, but can also be used for several other purposes such as consolidating data in many different formats into a central place for analysis and analytic purposes. This is an inside-out look at data virtualization, what it is, and several different applications and use cases including Spark on z/OS, the IBM DB2 Analytics Accelerator, and Business Intelligence tools that require SQL access.
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 V11 DB2 Utilities Update
  Craig Friske, IBM
 
  DB2 for z/OS V11 is another release filled with enhancements for DB2 utilities. This presentation covers utility enhancements which improve the use, availability, and performance of individual utilities in V11.
 

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, September 9th, 2016.

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
Veasna Tauch is a Data Architect at ATPCO. He has worked with DB2 for 20 years. He is responsible for DB2 SQL development and performance tuning. He is also a regular attendee of the BWDB2UG.
Database Architect and Strategist Tim Willging joined the Rocket Software team in 2005 and was named a distinguished engineer in 2015. With over 25 years developing enterprise software tools, Tim has architected and authored several database products focusing on backup and recovery, cloning, administration, monitoring and change management. He has recently been focusing on solutions for advanced analytics on z/OS. He is currently based in Chicago, and is an alumnus of Northern Illinois University with an emphasis in theoretical computing.
Anthony Ciabattoni has over 24 years of DB2 for z/OS experience with expertise in high available 24/7 systems, including extensive hands on backup/recovery and IDAA knowledge. He has been responsible for working on real life solutions with customers in the Analytic space as well as designing and architecting backup & recovery strategies. Anthony is a current IBM Information Champion, past member of the IBM DB2 for z/OS Customer Advisory Council, past presenter.
Craig Friske has over 2 decades of development experience working on DB2 for z/OS at the Silicon Valley Lab. He has worked on numerous utility projects, including statistics gathering enhancements, partition independence, data compression, and online utilities. He has also led the development of several large availability enhancements in the area of Online Schema Evolution.
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.