For many years now IBM have positioned SQL as the primary interface to the database on IBM i. At the same time, new capabilities are being added only to SQL, not to the native database interface.
We need a different tool to understand and analyze query implementation plans and feedback from the optimizer – the SQL component that determines the most effective way to deliver the data we ask for in SQL statements. Visual Explain is just such a tool, and it both shows us graphically what plan the optimizer has chosen, as well as tells us details about each step along the way. It can also give us suggestions on ways to improve performance of our queries.
Learning Objectives: A brief description of optimization with SQL The several ways of invoking Visual Explain The various panes of the Visual Explain window Some features of Visual Explain for managing how it behaves Examples of improved performance after using suggested changes
JSON is a popular format for exchanging structured data. In this session, we will learn how SQL can shred a JSON document so it can be treated like relational data. Then we will see how easy it is to generate JSON by using the functions provided by SQL.
This year IBM created data marts that allow us more control over the way we can monitor data from the system audit journal and special authorities. Learn how to create and use these data marts, and how it becomes an easy way to gather and store this information for your LPAR.
Accessing business logic from Open Source application and off platform has evolved a great deal over the years. In this session we’ll look at some of the reasons for centralizing this business logic in the database via Db2 Stored procedures. We’ll look at RPG and SQL procedures and work through examples of how these are used from exhibit languages like PHP and Python. Learning Objectives: 1) Learn how to create and execute stored procedures in SQL and HLL (RPG). 2) See examples of how to use Db2 Stored Procedures in OSS languages. 3) Review tips and best practices when working with Db2 Stored Procedures.
SQL Error Logging Feature, SELF, is one of those Db2 tools that few know about, and even less use. Learn about Simon Hutchinson’s experiences in setting up SELF, “turning” it on, and what he discovered using it.
Whether your team admits it or not, we all have legacy code. In this session, we will explore easy ways to modernize these programs and improve performance. We will delve into these 3 specific situations: Converting RPG programs to SQLRPGLE Using SQL when multi-member files are in use Converting PF files to SQL tables
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →
Thursday March 13, 2025 10:15am - 11:30am PDT
Madison
IBM i Services are provided by Db2 for i and can be used to access and manage the IBM i operating system. This session will include many examples of how to use IBM i Services to modernize administration on IBM i. Invest in understanding this alternative to existing IBM i APIs and commands.
In this new session, Scott will explore the many ways that “bad actors” can attempt to subvert the security on IBM i. Whether the topic is protecting against SQL Injection, closing doors to acquiring elevated privileges, or attempting to discover unprotected objects, this session will include techniques for evaluation and protection of your IBM i. Attend this session to take a big step towards discovering and eliminating attack vectors within Db2 for i!
SQL includes a full-fledged programming language, SQL PL. Come learn about the programming constructs, including error handling, that this language contains. You will leave with all the knowledge you need to start writing your own SQL functions and procedures.
