Contact | Privacy Policy
 
Learn how at the next Summit
October 15-17, 2019 in Minneapolis
Sponsors & Special Offers
News Headlines
February 6, 2019
2019 IBM i Champions Named: Congrats to Scott Klement, Liam Allan, Alan Seiden, Mike Pavlak, Stephanie Rabbani, Charles Guarino, Susan Gantner, Jon Paris & Paul Tuohy!
November 28, 2018
RPG & DB2 Summit heads to Charlotte, NC, with new sessions on SQL, analytics, data integration
November 9, 2018
Take a photo tour of the October 2018 Summit in Chicago
June 5, 2018
Next Summit highlights SQL, Db2 for i, Open Source
February 6, 2018
New RPG & DB2 Summit Sessions Help IBM i Developers Achieve Big Goals

DB2-Oriented Sessions

Best practices for the SQL developer

Wisdom is typically gained through a commitment to repeatedly encounter, endure and finally overcome failure.

In this session, Rob and Scott will share several best practices for SQL development on Db2 for i. Take advantage of this rare opportunity to avoid some bruised knees that go along with being an SQL programmer.

Rob and Scott will cover such topics as proper definitions for SQL Procedures and Functions, using IBM i Access Client Solutions (ACS) to your advantage as an SQL programmer, and much more.

Speaker: Scott Forstie and Rob Bestgen

Advanced SQL Coding

Reinforcing the previous "Set Based Processing" session, here we'll dig deeper into advanced SQL topics such as Grouping Sets, Recursive Common Table Expressions, Lateral, and get started on join types, OLAP Extensions, and more.

Speaker: Robert Bestgen

SQL Set Based Processing

SQL is a very powerful language for processing data. However, many developers use it the same way they do record level access (RLA) from a native program. While SQL can be used this way, an RLA approach never fully exploits SQL and often results in disappointment.

Speaker: Robert Bestgen

Best Practices for File Design

This session will focus on the idea, concepts and best practices for database design and physical modeling. While arguably one of the most important factors in building a successful data centric application, database modeling is often overlooked or performed sub optimally. The presentation will set the stage for meeting business requirements.

Speaker: Robert Bestgen

Db2 for i - Strategy, Enhancements and more

I own the Db2 for i development strategy, plan and team. It's always a sunny day in the database, even if it is frigid outdoors in wonderful Rochester, Minnesota.

In this session, I will explain how and why Db2 for i has changed in recent years.

Beyond delivering major feature enhancements in IBM i operating system releases, the database team typically delivers enhancements on a twice-per-year cadence via Db2 PTF Groups.

Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more.

This session ends with an overview of the recent enhancements to Db2 for i.

Resource: www.ibm.com/developerworks/ibmi/techupdates/db2

Speaker: Scott Forstie

SQL Data Integration Options

You often have a requirement to use data from another system/database/application running somewhere else. This session will cover some new (maybe even some not so new) SQL ways to acquire data from across homogenous or heterogenous environments.

Topics will include use of 3-part-naming, data replication, leveraging Web Services and more.

Speaker: Scott Forstie and Rob Bestgen

Introducing the Database Engineer!

This session will review the need for strong DB engineering, the skills required for that role, the analysis tools and the programming entities that the DBE would create or oversee. Many IBM i shops do not have formal DB engineers but rely on systems administrators and programmers to fill that role. This session will help illuminate the need for specialized skills around DB as well as help those people currently involved in DB to understand where to broaden their skills.

Further... Db2 for i has made great strides in providing IBM i Services to access IBM i operating system detail. Those services are used by System administrators and application developers.

A lesser known fact is that a great many Db2 for i Services exist to help Database Engineers (DBEs) and Database Administrators (DBAs) improve their productivity.

This session will also address some of the most important tasks for a DBE on Db2 for i and show how SQL and Db2 for i Services can be used to streamline, automate and improve mission critical tasks.

Speaker: Scott Forstie

The Art and Science of Database Performance Analysis

This session will provide an overview of the DB2 SQL performance tools and methods included in IBM i. The presentation will provide particular focus on obtaining value from the index advisor and SQL plan cache - both fully autonomic monitoring and analysis mechanisms available to the database engineer.

Speaker: Robert Bestgen

Hidden Gems in Db2 for i

The IBM i team has been delivering new function two times per year since 2010. New releases and technology refreshes deliver a broad range of function and sometimes the smallest line items can be easily missed.

In this session, Scott has assembled some of his favorite hidden gems; things that you might have missed but should know.

Start your day right with Db2 for i.

Speaker: Scott Forstie

Analyze your Data Using DB2 SQL OLAP Support

A hidden gem in IBM i 7.3 is an enhancement that can significantly simplify, and out perform, traditional methods of dealing with complex reporting tasks.

Speaker: Robert Bestgen

Securing Critical Db2 Data

Data has value and is a critical asset to a business. When a business is "hacked", it means data is stolen or destroyed and a company's reputation is tainted, possibly permanently. Plus, with new compliance laws, there can be legal consequences for not properly securing and managing data.

This session discusses the importance of data, distinguishes different types of data, identifies the many ways data can be breached, and what to do protect your data.

Topics covered include: Personal Information, Security administrative roles, Object level Security, Row and column access control, Authority Collection on IBM i 7.3, Guardium, PowerSC, and more.

Speaker: Scott Forstie

Untangling Data for Analytics

Analytics pundits say 70% or more of a reporting, Business Intelligence or Analytics project is in data preparation. Creating an automated, repeatable process to untangle data to prepare it for the analysis tools can simplify analytics and get you out of the extract building business.

Want to integrate some "talking" to Watson feature or simplify enterprise reporting? You need to prepare the data.

This session covers approaches to simplify reporting through metadata and/or transformations using Db2 Web Query for i.

Speaker: Robert Bestgen

Clearing the Fog on SQL Joins

This session discusses the different types of SQL joins and how to use them. It will also explain how joins work in general and help to clear up some of the most commonly experienced confusion developers have. Pick the right join type for the job.

Speaker: Robert Bestgen

30 SQL Tips in 60 Minutes

SQL is THE data access language. It runs interactively from green screens and System i Navigator. It's in RPG and COBOL programs, in ODBC and JDBC. It's ubiquitous, and it's everywhere, too! You can't know too much about SQL. In this session, Ted Holt presents an assortment of powerful, effective, and easily implemented SQL tips and techniques.

These tips and techniques are based on DB2 for i, but many of them apply equally to other platforms. There's something for everyone, from the SQL novice to the advanced user. Come learn some new techniques and reacquaint yourself with some you may have forgotten.

Speaker: Ted Holt

Home | RPG & DB2 SUMMIT | About Us | System i Community | Privacy Policy | Legal Notices | Email Webmaster | Contact
System i Developer,LLC © 2019