DB2 Forum 2018 Second Quarter Meeting
Tuesday, April 17, 2018
08:30 - 12:30 p.m.
- 08:30 - 09:00 Breakfast & Social
- 09:00 - 10:15 Robert Catterall - SQL Enhancements Delivered with Db2 12 for z/OS
- 10:15 - 10:30 BREAK
- 10:30 - 11:45 Les King - Part-1 The Common SQL Engine
- 11:45 - 12:45 LUNCH
- 12:45 - 14:00 Les King – Part-2 The DB2 Event Store & BIGSQL over Hadoop
- 14:00 - 14:15 BREAK
- 14:15 - 15:30 Robert Catterall - Let Me Make This Clear: Explaining Often-Misunderstood Db2 for z/OS Concepts and Facilities
- 15:30 - 16:00 What topics would you like next time?
Coppell, TX 75019
Meeting Cost: $10 for non-members, free to members. Membership is $25 per
year per person --or-- $100 for 5 people in a company --or-- $350 for
unlimited people in a company. You can register at the meeting.
This meeting is sponsored by
SQL Enhancements Delivered with Db2 12 for z/OS
Every version of Db2 for z/OS introduces new SQL-related capabilities, and Db2 12 is no exception. In this session I will describe new SQL features delivered with Db2 12, including temporal enhancements, the native REST interface, the new-and-improved MERGE statement, piece-wise DELETE, result set pagination, advanced triggers, "real" Unicode columns in EBCDIC tables, global variable enhancements, new built-in functions, and more.
Robert Catterall is an IBM Senior Consulting DB2 for z/OS specialist. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent DB2 consultant, he rejoined IBM in 2010. Robert is a past President of the International DB2 Users Group (IDUG), and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences and user group meetings, and blogs about DB2 for z/OS at http://robertsdb2blog.blogspot.com/
Les King - IBM
Part-1 The Common SQL Engine / Part-2 The DB2 Event Store & BIGSQL over Hadoop
Part-1 The Common SQL Engine
There is a significant amount of new news in 2018 across our hybrid data management portfolio. This includes a look at our 2018 roadmap as well. We will cover new news and a peak at the roadmap for the Common SQL Engine, Db2, IIAS, the new Db2 Event Store, our plans in the Big Data space including a look at our partnership with Hortonworks, Db2 Big SQL and Spark. We will also provide an update on our cloud offerings including how analytics is being leveraged in IBM's new IBM Cloud Private (ICP) offering. We will also talk about our new simplified packaging across this portfolio.
Part-2 The DB2 Event Store & BIGSQL over Hadoop
will explain more about IBM’s new EventStore database, and our partnership with Hortonworks Hadoop with BIGSQL.
Les King is a part-time professor at Seneca College in Toronto, offering courses in the Big Data, Data Warehousing and Db2 areas, drawing on his current experience with IBM and his previous experience teaching mathematics at the University of Toronto. Les effectively draws a connection between what the marketplace demands and what the next wave of talented students need to know to be market ready, and internationally competitive in an increasingly high demand field. This is a perfect intersection of his international, technological, and market awareness to perpetuate the success of the next generation.
Les King joined the IBM at the Toronto Software Lab in 1992, on the first database technical support team for DB2 Version 1. This sparked his creativity and offered a platform for him to execute a natural leadership ability from building the IBM Support Organization, serving as a key member in IBM Software Development Organization impacting a better series of advanced client technical support functions, making a unique contribution as a programmer before leading various teams within Information Management.
In 2001 Les became a senior manager, responsible for the planning, information development, and partner integration teams within DB2. In this capacity, he led the work to enhance the database engine, build a roadmap of future product releases and work to ensure the “next” releases of these products met customer expectations.
In 2004, Les took on the leadership of the Segment Product Management Team, at IBM Software Group Headquarters in New York. There, he was responsible for the DB2 distributed and Informix product portfolios, as well as Data Warehousing, z/0S and the Data Management Tools technology.
In 2007, Les took on the role of Director, Data Management Global Technical Support in Information Management, SWG. In this capacity, he led the client support function for important parts of IBM’s database portfolio which includes: DB2 z/OS, IMS, Tools, DB2 LUW, Informix Dynamic Server, SolidDB and Princeton Softech, among others.
Robert Catterall - IBM
Let Me Make This Clear: Explaining Often-Misunderstood Db2 for z/OS Concepts and Facilities
Some aspects of DB2 for z/OS technology are plain as day; others, less so. Questions I get from DB2 users worldwide have highlighted for me things that a lot of folks - even very experienced DB2 people - get wrong. In this session, I'll try to bring clarity to often misunderstood areas of DB2 for z/OS technology, including SQL statement zIIP eligibility, table space partitioning, high-performance database access threads, page-fixed buffer pools, DB2-managed archiving, hard and soft data set open and close, thread reuse, and in-memory database objects.