Contact
Nilo Khan
Wisconsin Midrange Computer Professional Association
secretary@wmcpa.org
October 2023: Monthly Dinner Meeting
Speaker: Sarah Mackenzie
Sarah Mackenzie is an IBM i Senior Software Engineer. She has worked on the IBM i development team since she joined IBM in 2012. During that time, she has focused on both database and query and has worked on the design, development, and support of new enhancements for IBM i such as Geospatial Analytics, Temporal Tables, and Db2 Mirror. Sarah is also a speaker at many industry events.
SESSION INFORMATION:
Session 1: Answering “Where” questions with Geospatial Analytics(4:30pm - 5:30pm)
Session title:
Geospatial Analytics is now integrated into Db2 for i and allows you to use SQL to not only store geospatial data representing real world locations in your database, but to also compare and analyze geographic relationships and trends. This presentation will introduce the user-defined geospatial data types, geospatial scalar functions, and geospatial table functions that make up Geospatial Analytics and provide many real-world examples of how to use them.
Geospatial Analytics is now integrated into Db2 for i and allows you to use SQL to not only store geospatial data representing real world locations in your database, but to also compare and analyze geographic relationships and trends. This presentation will introduce the user-defined geospatial data types, geospatial scalar functions, and geospatial table functions that make up Geospatial Analytics and provide many real-world examples of how to use them.
Session 2: What's New in Db2 for i
(7:30pm - 8:30pm)
Db2 for i is frequently enhanced via regular Technology Refreshes. This presentation will cover the new and enhanced Db2 for i capabilities added to IBM i 7.4 and IBM i 7.5 over the most recent IBM i Technology Refreshes. Learn about recent enhancements including new and updated built-in scalar functions, the new SQL Error Logging Facility (SELF), updates to query processing, new and improved services, and updates to IBM i Access Client Solutions (ACS).