In this new workshop, Scott will cover, explain, and demonstrate the varied techniques that can be used to see what SQL is being executed on your IBM i.
Topics include, but are not limited to:
-- SQL Performance Monitors
-- SQL Plan Cache analysis
-- Guardium Database Activity Monitor
-- Journal Extract Tool (JET)
-- Db2 for i SQL services
-- Db2 for i Client Special Registers
-- Db2 for i SQE Query Supervisor
-- IBM i (SQL) Services
-- Authority Collection
1. If you have a need or requirement to capture database activity, this session is for you.
2. If you need to have techniques to understand the SQL being executed (right now), this session is for you.
3. If you need to a better foundation for understand who is doing what with SQL on your IBM i, this session is for you.
It has been said that any Analytics project is going to require 70% or more of your time getting the data ""right."" For IBM i customers that have a majority of their critical information stored in Db2 for i, the Db2 Web Query product provides multiple architectures and facilities to ease the effort of preparing that data to feed into analytical applications. Those applications could be standard reports, slice and dice reports, dashboards using Db2 Web Query, or generate data feeds into other databases (such as a data warehouse) or cloud based AI/ML analytical services. This workshop will cover how to leverage Db2 *and* web query facilities to prepare and manage your data to simplify you analytics!
1. Learn about a meta data infrastructure to support your analytics strategy - ""get the data right"" and everything else becomes easier.
2. Understand that you can use both Db2 SQL or web query facilities (or a combination of the both) to do data preparation and avoid having to build RPG programs to get the data in the right formats to be consumed by analytics.
3. Discover different architectural options for on premise analytics or integrating data into and out of cloud based analytical services.
Creating and Consuming JSON Data with SQL
Birgitta Hauser | February 23, 2022 | 8:30 a.m. - 12:00 p.m. CT
JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose and can be faster parsed than XML. In this way JSON becomes more and more important especially when data is exchanged by RESTful web services. The use of XML declines in favor of JSON.
With Release 7.3 TR 3 a bunch of scalar and aggregate functions were integrated into SQL, for generating JSON objects, arrays and for combining JSON components into complete documents.
The JSON_TABLE tables function for consuming JSON data was already introduced with Release 7.3 TR 1. With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically out. Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members.
Last but not least IBM provides SQL http-functions for getting access to web services. In composition with the JSON_TABLE function the JSON answers returned by web services can be consumed within a SELECT-Statement.
1. Get an introduction into JSON basics.
2. Learn how JSON object and arrays can be generated, concatenated or nested and composed into JSON documents.
3. Discover how JSON documents located in either the IFS or a column of a table or JSON answers returned by web services can be parsed with the JSON_TABLE table function, converted into a relational representation and data specifically selected.
4. Get an overview over the new http-functions and how to use them for getting access to web services.
Take Your Application Performance to the Next Level with Database Engineer Essentials
Kent Milligan | February 23, 2022 | 1:00 p.m. - 4:30 p.m. CT
In this workshop, you'll start by learning how to get the proper database foundation in place for all your applications by learning about best practices for design of your data model and Db2 tables. Besides having a good database design, you also need a good understanding of key SQL performance concepts and critical success factor such as indexing strategy. You will learn how to analyze and investigate these important SQL performance concepts using the graphical performance tools that are included with Db2 for i featuring, Index Advisor, Visual Explain, and the Plan Cache tooling.
Taking the Next Steps with SQL
Simon Hutchinson | February 24, 2022 | 1:00 p.m. - 4:30 p.m. CT
Take the next steps from simple SQL and start thinking about the data in your database differently. Change the way you think about keeping data in a normalized form, to see the advantages of gathering data into unnormalized forms that will save you time and effort. Learn how to remove your logic from your programs and into the database itself. See real life examples of how you can use SQL to gather data from multiple partitions and present them all in one place. Discover how by using SQL you can simplify your programming, and reduce your workload, to produce results with less effort than you could using many programming languages.
1. Understand why working with SQL means you change from “record at a time” to “data sets” way of thinking
2. Learn how to maximize the value of SQL to simplify your programs
3. Learn how to access data from multiple partitions