Connect With Us

Scott Forstie

Scott
Forstie

Scott Forstie is a senior software engineer at IBM. He is the DB2 for i Business Architect, SQL development leader, and IBM i developerWorks content manager.

Articles
Gain big DB2 for i insights
Gain Big Insights into DB2 for i with System Limits, Phase 2 
Gather new sources of information by automatically tracking individual database files, journals and journal receivers, and library objects. Scott Forstie explains.
Teach Your Old DB2 New Tricks
Teach Your Old DB2 New Tricks 
Scott Forstie presents the greatest database enhancements in IBM i 7.1 that aren't related to application development. Along the way, he illuminates technical topics and provides references to supporting details.
Tubocharge IBM i with SQL
Turbocharge IBM i with SQL [Power Pack]
In this SQL Power Pack, four IBM i experts deliver six of our most popular and handy SQL with IBM i articles, plucked from the virtual pages of iProDeveloper.com—unlocked and free to download for a limited time. Act now before they're gone!
A Parade of DB2 for i Enhancements
A Hit Parade of DB2 for i Enhancements  1
Whether you’ve used IBM i 7.1 for years, you’ve just moved to it, or it’s part of your future road map, you’ll want to know about IBM i’s latest features and enhanced capabilities for database users. Scott Forstie shows you what’s new in DB2 for i.
SQL for the Systems Administrator
SQL for the Systems Administrator  1
Scott Forstie explains how SQL on IBM i can be used to accomplish a number of tasks that are unrelated to traditional uses of SQL.
Tracking Important System Limits on IBM i
OnDemand Tracking of Important System Limits on IBM i  2
Reaching a system limit can render your machine unusable or put it in a state of extended recovery. In this article, Scott Forstie covers OnDemand Tracking of Important System Limits on IBM i, which keeps you informed of the health of your system and positions you for continued success.
Turbocharge Your SQL Routines
Turbocharge Your SQL Routines with These 10 Tips 
SQL is here to stay, and honing your skills is sure to pay off, writes IBM's Scott Forstie. Scott gathers 10 tips to boost your SQL routines on DB2 for i.
Use the New IBM i RUNSQL Command to Liberate Your SQL  1
RUNSQL, a new command in IBM i 6.1 and 7.1, frees you up from traditional programming requirements. With RUNSQL, you can execute a single SQL statement anywhere a command can be executed, without having to start an interactive SQL session or store the command string in a source file member. IBM's Scott Forstie provides all the essentials to help you get off to a great start with RUNSQL.
SQL Plan Cache Primer
Rock Your Query Environment: SQL Plan Cache Primer, Part 2 
You can leverage the SQL Plan Cache to help you achieve great performance in a DB2 for i query environment. In Part 2 of this two-part series, discover ways to take advantage of event and statistics monitors, along with plan cache utility procedures, to unravel your most knotty query engine conundrums.
Rock Your Query Environment: SQL Plan Cache Primer, Part 1 
A little awareness and knowledge of the SQL Plan Cache can go a long way toward helping you maintain a well-performing DB2 for i query environment. In Part 1 of this two-part series, learn exactly what the SQL Plan Cache is, how to ensure that it's properly configured on your machine, and how you can use it to get to the bottom of certain performance problems.
Get Up to Speed on SQL's Fast Delete in DB2 for i 
Recent improvements to IBM i 6.1 and 7.1 have made it easier to set up and troubleshoot fast delete on DB2. IBM's Scott Forstie explains the fast-delete rules and how to use SQL Performance Monitor to get the best results.
Use SQL CREATE OR REPLACE to Improve DB2 for i Object Management
Use SQL CREATE OR REPLACE to Improve DB2 for i Object Management 
Scott Forstie explores the ways you can use CREATE OR REPLACE to write simpler DDL SQL scripts, retain security authorizations, and create efficient and safe SQL view management with selective replacement.
Isolate SQL App Problems Using IBM DB2 for i's New FTRSQLCODE 
As SQL becomes more widely used on DB2 for i, developers and DBAs need techniques that help them efficiently identify causes of SQL application problems. A recent enhancement to IBM i 7.1 and 6.1 addresses this need by making it easier to isolate SQL application failures. Namely, Database Monitor includes the new Filter by SQLCODE (FTRSQLCODE) pre-filter, which lets users easily collect data about SQL app failures. Scott Forstie demonstrates how to use FTRSQLCODE with the STRDBMON and ENDDBMON commands and walks through an example scenario that uses FTRSQLCODE to isolate a failing SQL statement.
Automate Index Creation and Removal with SYSTOOLS Procedures 
From 5.4 on, DB2 for IBM i has generated index advice, and IBM i 6.1 and above has also included SYSTOOLS, a repository for index advice that can turn it into permanent indexes. Sometimes, however, these indexes are underutilized, but a recent update now allows SYSTOOLS to find and remove these neglected indexes. Scott Forstie shows you how this works and how SYSTOOLS can help you craft your own index strategy for optimal database performance.
Improve Your Data Center with Three-part Name Aliases 
As a database pro, you know the data center is a complex and heterogeneous beast to manage. To further complicate matters, the Internet and commoditization of storage continue to fuel data explosion and fragmentation. So anyone in charge of maintaining the data or approving extensions to the database architecture should consider using three-part name aliases. On IBM i 7.1, aliases can substitute a table reference with an object that resides on a different relational database. The alias simply indicates a three-part name, and DB2 will manage a temporary connection to the target database.
iPro Forums

Get answers to questions, share tips, and engage with the iPro Community in our Forums.

From the Blogs
Application Modernization Redbook Unleashed
Mar 27, 2014
blog

Application Modernization Redbook Unleashed  

The Application Modernization Redbook draft version has been released! Tim Rowe has the details....More
Free-Form RPG Transformation, Part 2
Mar 19, 2014
blog

Free-Form RPG Transformation, Part 2  

Tim Rowe continues his series on ISV tools for free-form RPG with a look at Linoma Software's free-format transformation tool, RPG Toolbox....More

Sponsored Introduction Continue on to (or wait seconds) ×