Vermont Midrange User Group 

VTMUG logo Fourteenth Annual Technical Conference
Thu, Sep 27, 2018
Conference
Home
Register Speakers  Sessions  Session Grid Sponsors  Hotel &
Directions 
Cancel
Registration 
Exhibitor
Information 
Session Descriptions

Track 1: RPG Programming:
Track 2: Systems Management:
Track 3: DB2 & SQL:

 

Track 1: RPG Programming

 

 


Opening Session: How to be an IT Survivor

Trevor Perry

Do you know that your job will look like in 5 years? 10 years? Will you be kicked off the island? Are you the weakest link? The IT industry is fueled by change and requires both ourselves and our companies to adapt quickly.This session is a discussion of topics that can assist you in being an IT survivor. A review of past trends may give us clues to maintaining current skills and developing new skills. This will allow us to remain competitive as individuals and drive our businesses in the right direction for a future of change. Be prepared to challenge your status quo, and leave with new ideas on how to become flexible enough to adjust quickly to new trends and directions and ensure your survival.

 


Access Client Solutions (ACS) for Programmers

Paul Tuohy

Access Client Solutions is a powerful tool for programmers. ACS replaces and enhances much of the functionality originally supplied by Navigatorfor i. This session discusses how ACS can be used by programmers; including

  • System Configuration
  • 5250 Emulator
  • SSH Terminal
  • Integrated File System
  • Printer Output
  • Schemas
  • Run SQL Scripts
  • SQL Performance Center

 


RPG Talks To Watson

Paul Tuohy

One of the key questions is - how easy is it to integrate Watson into my existing RPG applications? In this session we look at some of the way that RPG can connect with Watson (using the translation API) - and just how simple it is. As well as looking at different methodologies, we will also discuss the advantages, and disadvantages, of the different approaches

 


Who Knew You Could Do That with SQL

Paul Tuohy

You have been using SQL, but have you been using it to it’s full potential? In this session, Paul looks at some of the bits and pieces that may enhance your use of SQL. Topics include:

  • Grouping
  • CASE
  • Scalar Functions
  • Subselects/Sub Queries
  • Common Table Expressions
  • Union
  • Identity Columns
  • Row Change Timestamp
  • A Word About Views
  • Finding a view of a view of a view of a...

 

 

Track 2: Systems Management

 

 


Opening Session: How to be an IT Survivor

Trevor Perry

Do you know that your job will look like in 5 years? 10 years? Will you be kicked off the island? Are you the weakest link? The IT industry is fueled by change and requires both ourselves and our companies to adapt quickly.This session is a discussion of topics that can assist you in being an IT survivor. A review of past trends may give us clues to maintaining current skills and developing new skills. This will allow us to remain competitive as individuals and drive our businesses in the right direction for a future of change. Be prepared to challenge your status quo, and leave with new ideas on how to become flexible enough to adjust quickly to new trends and directions and ensure your survival.

 


Cool things in Navigator for IBM i to be a Rock Star System Administrator

Pete Massiello

The name of this session has been changed and originally was called "Managing IBM i with Navigator for i".

IBM Navigator for i is a powerful tool to better manage your IBM i environment. Get expert advice for features in the tool to make you a RockStar system administrator. Step through the functionality of this product and learn how to leverage the Performance Data Investigator to turn the collection services data into graphs you can use to identify performance issues. Learn ways to protect your system from intrusions, as well as close security holes such as FTP. See how this tool can help you select and install Logical files on your system to improve performance with the Index Advisor. Learn about the enhancements to this valuable tool in the release of version 7.3, while we see how this tool provides tips and techniques for better and more effective use of your IBM i.

 


Basics of IBM i Systems Management

Pete Massiello

What is required for the care and feeding of your IBM i (AS/400, iSeries, System i)? In this presentation, we will review the required steps necessary to care and feed your IBM i. All from an Operations or Systems Management perspective. What documentation should you have about your system? What backup strategy should you employ? How to measure and track growth of disk space. When, how often, and which PTFs should I apply. What to do about IPLs, Reclaim Storage, SST/DST security, and Performance.

 


Tips and Tricks to Improve Systems Performance and Save Disk Space

Pete Massiello

What can you do to stop the rampant growth of data that’s eating up disk space? How do you improve system performance? Come to this session to find out how to make the most out of your existing configuration by leveraging the many optimization and cleanup techniques that are a part of i5/OS, including reorganization of physical files, sharing of access paths, and using the DISKTASK command. Pinpoint how to reduce your disk I/O by reorganizing files and clean up your system using the Retrieve Disk Information (RTVDSKINF) and Retrieve Directory Information (RTVDIRINF) commands. Learn how sharing access paths can reduce disk utilization and memory faulting. Know your options for reorganizing your files while your users continue to access them.

 

 

Track 3: DB2 & SQL

 

 


Opening Session: How to be an IT Survivor

Trevor Perry

Do you know that your job will look like in 5 years? 10 years? Will you be kicked off the island? Are you the weakest link? The IT industry is fueled by change and requires both ourselves and our companies to adapt quickly.This session is a discussion of topics that can assist you in being an IT survivor. A review of past trends may give us clues to maintaining current skills and developing new skills. This will allow us to remain competitive as individuals and drive our businesses in the right direction for a future of change. Be prepared to challenge your status quo, and leave with new ideas on how to become flexible enough to adjust quickly to new trends and directions and ensure your survival.

 


Writing Better SQL

Jim Denton

Most of us have been successful at writing SQL statements that get the job done but are we really maximizing its value? Good SQL works but better SQL takes full advantage of functionality in DB2 for i, is easier to write and extend, is more readable, and also provides better performance. This session covers best practices for writing SQL which include thinking in sets, creating performance friendly SQL, and leveraging functional building blocks that are already available in IBM i.

 


Programming in SQL

Jim Denton

SQL is much more than a query language. This session provides an overview of the integrated DB2 for i SQL programming support for writing SQL procedures, functions, and triggers which can enhance and extend database functionality. This includes advanced techniques such as leveraging default parameters, handling errors, enhancing views with instead of triggers, and consuming result sets in high level languages.

 


Advanced OLAP

Jim Denton

OLAP stands for Online Analytical Processing which can be used to transform raw data into valuable business insights. There's no need to pull your data off into a spreadsheet to get the answers that the business requires! This session provides a jumpstart for using the OLAP functions which are already provided as part of DB2 for i. These include RANK, ROW NUMBER, CUBE, ROLLUP and GROUPING SETS.