Contact | Privacy Policy
 
Learn how at the next Summit
March 24-26, 2020 in Dallas
Sponsors & Special Offers
News Headlines
April 9, 2019
Take a photo tour of the March 2019 Summit in Charlotte!
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
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 & 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 write it the same way they would 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.

This session revisits SQL with an eye on leveraging its power in set based processing: Less is more.

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 & more - including 7.4!

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 & Rob 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

Database Engineering 101

In this session, we will explore some of the most common and important challenges confronted by the Database Engineer (DBE).

  • What is Reorganize Physical File Member? When should a reorganize be implemented and what are you hoping to gain?
  • How can you predict the time it takes to complete time sensitive DBE operations?
  • How can you change trigger programs in a production environment without acquiring an exclusive lock on the physical file?
  • What are the most important factors to consider when reviewing the index strategy?
  • How can ACS accomplish DBE tasks?
  • What about SQL? Can SQL help with DBE tasks?

These and many other questions will be answered in this new, exciting, and interactive session.

Speaker: Scott Forstie

Getting Quick Wins on Improving SQL Performance

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 Visual Explain, the Index Advisor and the SQL Plan Cache. These options leverage 'always available' information to make powerful tools readily available to the database engineer.

Speaker: Robert Bestgen

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

Getting the Most Out of 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

OLTP vs. OLAP - Why Untangling Data is Important

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 analysis tools can simplify analytics and get you out of the extract building business, not to mention improve performance for those reports.

Want to integrate additional data from outside sources? You probably need to prepare the data.

This session covers approaches to handling data to make it more consumable and to simplify reporting.

Speaker: Robert Bestgen

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