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

When? Thursday, December 10th, 2015, 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 Where’s the BIF?
  Ulf Heinrich, Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH

BIFs (Built in Functions), have been used for years in SQL and in recent releases of DB2 some have changed the way that output is returned. Most noticeably in DB2 10 with the CHAR and DECIMAL problem. This presentation shows you what the problem actually is with real-life examples and two different ways of approaching the problem. One with “classic” tooling and one with “new” style tooling. One thing is for sure: We all have a problem, somewhere, with BIFs but the question is “Where’s the BIF?”

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 25 Years of Missed Opportunities? SQL Tuning Revisited
  Ulf Heinrich, Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH
  “Nothing is more expensive than a missed opportunity” (H.Jackson Brown, Jr).

This is especially true when it comes to SQL Tuning!

There are many low-hanging fruits within easy grasp of anyone tasked with tuning their systems. But how do you know what is dangling within reach if you can’t see it?

Find out how a modern DB2 z/OS SQL warehouse can collect and store all executed static and dynamic SQL (plex-wide) with basically no overhead. By comparing SQL statements side-by-side, the “easy pickings” will immediately become apparent. But why stop there? Experts can effortlessly dig deeper and find the totally hidden gems: Disc Problem Detection, Delay Detection, Never executed SQL, SQLTimeline. Precisely pinpoint specific areas to target and get the most out of your DB2 system – while reducing costs.

  11:45 - 12:45 Lunch
  12:45 - 2:00 DB2 Security Best Practices: Protecting your system from the Legions of Doom
  Dave Beulke, Dave Beulke and Associates

As the Legions of Doom descend on your system you need to be prepared with the best security techniques and strongest configuration safe guarding your data. This presentation discusses the latest DB2 security techniques, the software configurations, and application development best practices for a resilient comprehensive DB2 security strategy.  

The presentation discusses how to design, configure and code your application into a multi-layered DB2 security perimeter around data. By learning the application coding security practices, database design techniques and system security settings your company can have multi-layered DB2 security defenses to stop any nasty legion bandits from getting your data. Through a proper comprehensive DB2 security environment you will learn the secrets to defeating the Legions of Doom.

  2:00 - 2:15 Break
  2:15 - 3:30 What’s new for DB2 Clients and Drivers?
  Paul Wirth, IBM
  IBM’s strategy is to remove the reliance on the DB2 Connect Gateways and replace DB2 Connect with the IBM Data Server Drivers or Clients. While DB2 Connect licenses (in the form of DB2 Connect license files) are still required, you can replace DB2 Connect Gateways with the IBM Data Server Drivers or Clients and receive equivalent or superior function. In addition, you can reduce complexity, improve performance, and deploy application solutions with smaller footprints for your business users. IBM has also simplified the configuration of clients and drivers by replacing the database directory with a single XML configuration file.

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, December 4th, 2015.

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
Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. Ulfs specialties are DB2 availability and performance, focusing on the growing requirement for 247 operations and cost reduction. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under real world recovery pressure. Ulfs activities cover EMEA, as well as North America through SEs U.S. subsidiary, SEGUS Inc.
Dave Beulke is a system strategist, application architect, and performance expert specializing in Big Data, data warehouses, and high performance internet business solutions. He is an IBM Gold Consultant, Information Champion, President of DAMA-NCR, former President of International DB2 User Group, and frequent speaker at national and international conferences. His architectures, designs, and performance tuning techniques help organization better leverage their information assets, saving millions in processing costs. Follow him on Twitter (@DBeulke) or connect through LinkedIn.
Paul Wirth is a Senior Data Management Technical Professional with IBM Corporation located in Maryland. Paul has been involved in database administration and storage management for over twenty five years. Over the years Paul has worked in database administration with IMS, DB2 and Oracle. Paul has also worked extensively with enterprise storage subsystems for both Open Systems and z/OS. Paul is an IBM Certified Database Administrator for: IMS, DB2 for z/OS, Linux, UNIX and Windows.
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.