June 6, 2017 CODUG Meeting

The next Central Ohio DB2 User Group meeting will be June 6, 2017 at the IBM Sterling campus in Dublin, OH (Tuttle Crossing).
We are very pleased and excited to have 3 local DB2 users speak on their experiences and Mark Rader from IBM. This will be an all-day, no-charge meeting and lunch is sponsored by Rob Barbour from Enterprise Systems Associates, Inc ESAi

8:30 - 9:00 Registration
9:00 - 9:15 Welcome and Opening Remarks
9:15 - 10:30 Ramesh Gattu (Nationwide) - DB2 (LUW) HA -redesign (Single to dual disk) and DB2 (LUW) process improvements
10:30 - 10:45 Break
10:45 - 12:00 Lori Alexander and Lillian Russell (Fifth Third Bank) - Enabling DB2 APPLCOMPAT V11R1...How to use IFCID 366 reports
12:00 - 1:00 Lunch and Learn - Rob Barbour, ESAi
1:00 - 2:15 Mark Rader (IBM) - DB2 for z/OS Continuous Delivery of New Features
2:15 - 2:30 Break
2:30 - 3:45 Mark Rader (IBM) - DB2 for z/OS 12 Migration Considerations
3:45 - 4:00 Closing Remarks

Ramesh Gattu (Nationwide)
DB2 (LUW) HA -redesign (Single to dual disk)
DB2 (LUW) process improvements:

Lori Alexander and Lillian Russell (Fifth Third Bank) To enable DB2 APPLCOMPAT V11R1 in your environment, it is necessary to identify and change incompatible functions in dynamic and static SQLs.  This presentation will detail Fifth Third’s approach to identifying these incompatible functions using the IFCID 366 trace and extracts of dynamic and static SQL. The presentation will cover how to interpret IFCID 366 incompatible functions, and how to manage testing and implementation of changes.

Mark Rader (IBM) - DB2 for z/OS Continuous Delivery of New Features
DB2 for z/OS is now offering continuous delivery of new features. Taking advantage of new capabilities and enhancements for DB2 for z/OS is now faster and more accessible than ever before
thanks to continuous delivery. In DB2 12, an environment is created where new functions can be delivered as activatable function levels multiple times a year, as opposed to waiting for the next DB2 version. Continuous delivery can help DB2 for z/OS customers by:
- Delivering new function when the quality is right
- Maintaining a stable environment
- Reducing costs associated with migration disruptions in a 3-year upgrade cycle
- Allowing systems to adopt new functions quicker
- Creating stable environments for applications to be developed, tested and deployed

Mark Rader (IBM) - DB2 for z/OS 12 Migration Considerations
With the introduction of function levels within DB2 for z/OS 12, customers can choose when and which enhancements are implemented. These include virtual storage enhancements, new subsystem parameters, optimization enhancements (for static SQL statements, this means package bind/rebind after the function level activation) and new SQL capabilities.


Ramesh R Gattu (MBA,PMP)
Ramesh is a Lead / Principal DBA (DB2-LUW) at Nationwide Insurance Company. He has over eighteen years of extensive IT experience in complete software life cycle development and over twelve years of extensive experience in Tech-leading, managing and administering distributed database platforms including SQL server ,DB2 and Oracle on Linux, UNIX, Windows, Solaris and Redhat platforms. Ramesh's certifications include: Certified Big Data Hadoop Developer and administrator, IBM certified advanced database administrator, and PMI certified Project Managemnet Professional (PMP)

Lori Alexander is a member of the DB2z DBA Team at Fifth Third Bank.  She has been employed with Fifth Third for two years.  Prior to her employment with Fifth Third, Lori was an independent consultant for 12 years and has over 25 years’ experience with DB2 Database Administration and DB2 Systems Programming.
Lillian Russell is a DB2 z/OS DBA at Fifth Third Bank.  She has been employed at Fifth Third for 16 years working in different infrastructure positions including business analysis and project coordination.  Currently, she has been a DB2 z/OS DBA for one and an a half years. 

Mark Rader is a Senior Consulting IT Specialist with IBM working with DB2 for z/OS clients. He has over 31 years of technical experience with IBM, primarily with DB2 for z/OS. He focuses on data sharing, performance,
availability, distributed client access to DB2 for z/OS and DB2 and WLM interaction. He has led many DB2 data sharing implementations and has presented a variety of topics at conferences and at regional user group meetings. He has worked closely with DB2 development in delivering the early support programs for DB2 11 and 12. He is an author of redbooks on Parallel Sysplex application considerations, DB2 datasharing.

Lunch is provided.

IBM/Sterling Campus Building One
6060 Britton Parkway
Dublin OH 43016
Meeting rooms - Auditorium A & B

Map to the address.

Driving Directions to IBM/Sterling Campus:

  • Hit the Columbus I-270 outerbelt and head to the northwest quadrant of greater Columbus, the suburb of Dublin.
  • Exit onto Tuttle Parkway.
  • Turn to the west ... away from the Tuttle Mall ... head outside the loop ... head towards the countryside
  • Once clear of the highway interchange, at the 1st big light turn right onto Emerald Parkway (turning left would be Britton Parkway)
  • After about 100 feet turn right again into the IBM Sterling Campus.
  • After about 100 feet (again) turn right into the parking lot that is adjacent to Building ONE (6060 Britton Parkway).
  • Enter the foyer of Building ONE and call the number delimited on a sign that will be posted (or call 717-557-9254) for entry assistance.

Register here.

Looking forward to seeing you there.



Attending via Web

Attending via Web

tkemmer's picture

I'm sorry but there is no web access to our live presentations.