Contact | Privacy Policy
 
Learn how at the next Summit
March 24-26, 2020 in Dallas
Sponsors & Special Offers
News Headlines
February 10, 2020
Session Grid for March 2020 RPG & DB2 Summit features new workshop, new sessions.
February 6, 2020
2020 IBM i Champions Named: Congrats to Ted Holt, Scott Klement, Liam Allan, Alan Seiden, Mike Pavlak, Stephanie Rabbani, Charles Guarino, Susan Gantner, Jon Paris & Paul Tuohy!
December 2, 2019
Super-Saver registration open for March 2020 RPG & DB2 Summit in Dallas!
November 2, 2019
Take a photo tour of the October 2019 Summit in Minneapolis
November 28, 2018
RPG & DB2 Summit heads to Charlotte, NC, with new sessions on SQL, analytics, data integration

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

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

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

All New: 30 MORE SQL Tips in 60 Minutes

You may have seen Ted's ever-popular "30 SQL Tips in 60 Minutes" session before. It turns out Ted has more than 30 SQL tips up his sleeve!

In this all-new second edition, Ted explores yet another set of 30 practical SQL tips.

As in the original SQL tips session, 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

Db2 Web Query EZ-Install

You've probably heard about Db2 Web Query but are wondering what the value is to you. This session reviews how to get started quickly with the new EZ-Install package and its many sample reports for users and system administrators.

Leverage the Query/400 Discovery tool for analysis of the hundreds of archaic reports on your system. Use the wizards to generate more samples over your data. Learn how to get trained on additional capabilities with tutorials and quick start services. Consume result sets from your RPG programs. Even take advantage of the SQL Services provided by Db2.

Speaker: Robert Bestgen

IBM i (SQL) Services for the Developer

IBM i services provided by Db2 for i can be used to access system information that is useful for developers. In the past you may have considered using CL or coding to system APIs to access and work with some system information. Today there is a better option: SQL.

In this session you will learn how to use SQL to work with data areas and data queues, discover how easy it is to review your program and service program attributes, and more. Just wander over to ibm.biz/Db2foriServices to get an advance look at what is available!

Speaker: Sue Romano

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

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