2019 Fall Conference & Expo

2019 Fall Conference & Expo
Join COMMON for the premier Power Systems fall conference. With over 100 sessions organized into 15 Courses of Study, the topics you need for career and business success are covered. There will be professional networking opportunities and a sold-out Expo as well. Register now.

Click here for more information


Substitutions and Cancellations

If you cannot attend the conference, you may substitute another person from your company. Cancellation and substitution requests must be made in writing on company letterhead and emailed to common_registration@common.org. A processing fee of $100 will be charged for all substitutions and cancellations. Requests for substitutions and cancellations are accepted until September 2, 2019. All eligible refunds will be processed after the conference. Cancellations received after September 2, 2019 are non-refundable.

Conference Hotel Registration Rates
A minimum of a two-night stay is required to receive the registration rate associated with staying the COMMON conference hotel. The hotel confirmation code must be entered at the time of conference registration to receive this rate. If your plans change and you stay fewer than two nights at a COMMON conference hotel during a conference, a surcharge will be applied to your registration fee to equal the offsite registration rate. Hotel reservations should be made separately, and hotel pricing is not included in above registration rates.

Conference Image Release
When attending a COMMON event, you enter an area where photography, audio and video recording may occur.

By attending the event, you consent to photography, voice recording and video recording and its release, publication, exhibition or reproduction to be used for promotional purposes, advertising, social media or any other purpose by COMMON and its affiliates. You also waive all rights to any claims for payment or royalties in conjunction with any use of these materials in perpetuity.

When
9/9/2019 7:00 AM - 9/11/2019 1:00 PM
Where
Hyatt Regency Indianapolis 1 S Capitol Ave Indianapolis, IN 46204 UNITED STATES
Registration is closed.
My registration status: Not registered

Program

   

Sunday, 08 September 2019

 
There are two half days broken up into two logical sections: In Part One, we will discuss keeping things current along with best practices on your HMC, your System, and the IBM i Operating system.

In Part Two, we will discuss day-to-day systems management tasks including monitoring, some system tuning, system clean-up, and spooled file handling. Note that Part One is NOT a prerequisite for Part Two.

PART ONE TOPICS:
Setup and verify of Call Home functions on the HMC. Setup of a limited HMC user. A review of HMC command line capability including watching HMC disk space. Setup and verify of Call Home functions in IBMi. What and how to set them up and how to test them to be sure your system is protected. 
PTF Review and processing. We'll discuss how to find out your current levels and how to get new levels and tools to help you install them. This will include PTF Groups and Image catalogues. We'll also touch on HMC Updates, Flexible Service Processor (FSP) updates, why, when and how.

Validating your network configuration to assure it is correct and settings to review for best performance and reliability.
Presenter: Larry Bolhuis
Time
8:00 AM - 12:00 PM
8:00 AM

Today SQL is not only used for ad-hoc queries, but replaces more and more native I/O and must be used in composition with all programming languages other than RPG and COBOL. Moving business logic into data base is one of the main goals when we talk about application modernization. The first step for realizing this goal is the ultimate use of the SQL SELECT statement which may be much more powerful than you can imagine. Currently SQL provides around 180 scalar functions and 20 aggregate functions. Besides various ways of joining tables or views, data from multiple tables can be merged. Since Release 6.1 all kinds of sub- and grand totals can be built. Recursive Common Table Expressions and hierarchical query clauses allow recursive data (such as bill of materials or flight plans) to be analyzed. XML functions for generating and consuming XML data located in either a table or within the IFS were introduced in release 7.1. Since release 7.2 TR 1 regular expressions can be used. Release 7.3 offers a new range of OLAP-Functions … In this workshop you will learn multiple ways for solving your requirements by using a SQL Select Statement. Learning Objectives: Expand your SQL know-how with not-widely known scalar functions for string handling including regular expressions or numeric rounding. Handle different conditions with case-clauses within a single SELECT-Statement. Use multi-dimensional grouping for building totals. Join and merge tables and views. Instead of coding several SQL statements or building temporary tables, use sub-selects and/or common table expressions (CTE) including recursive CTE. Learn how recursive data can be analyzed.

Presenter: Birgitta Hauser
Time
8:00 AM - 12:00 PM
8:00 AM

here are two half days broken up into two logical sections:

In Part One, we will discuss keeping things current along with best practices on your HMC, your System, and the IBM i Operating system.

In Part Two, we will discuss day-to-day systems management tasks including monitoring, some system tuning, system clean-up, spooled file handling.

Note that Part One is NOT a prerequisite for Part Two.

PART TWO TOPICS:

Explore graphical methods for monitoring IBM i Performance. This includes Management Central and IBM Navigator for i System Monitors.

Things to watch out for: Memory usage, Disk I/O and storage, avoiding dead cash batteries. Message queues to use to keep the finger on the pulse of your IBM i.

Storage Management - Discover your disk and what's filling it. Tips for deciding on what doesn't need to be there.

Various System values you should understand.

Spool file maintenance including use of iASPs, Joblog Servers, and disconnected spool file functions.

This workshop will focus on key items that should be set up and managed on your system to assure it is running well and stays that way!

Presenter: Larry Bolhuis
Time
1:00 PM - 5:00 PM
1:00 PM

SQL is much more than a query language. Besides querying and manipulating data in database objects and generating those database objects, SQL also provides all kinds of commands and constructs, for writing and executing programs. With the SQL Programming Language, Stored Procedures, Triggers and User Defined (Table) Functions can be written, without knowing anything else than SQL commands! This session will give you an introduction into the SQL Programming Language. The procedure and function create options and controls are explained. You’ll learn how to structure the source code within the routine body, how to define variables and cursors, what control statements are available, how to read data row by row in a loop, how to receive and return parameter values and result sets and how to handle errors. Besides the pure coding you’ll get also a short introduction into the development tools.

Presenter: Birgitta Hauser
Time
1:00 PM - 5:00 PM
1:00 PM

Monday, 09 September 2019

 
Asssociate AIX 7 Administration Certification
Time
9/9/2019 8:00 AM - 9/11/2019 8:00 PM
8:00 AM

Certification Exam - Business Computing Associate
Time
9/9/2019 8:00 AM - 9/11/2019 8:00 PM
8:00 AM

Certification Exam - Business Computing Professional
Time
9/9/2019 8:00 AM - 9/11/2019 8:00 PM
8:00 AM

Associate IBM i 7.1 Administration Certification
Time
9/9/2019 8:00 AM - 9/11/2019 8:00 PM
8:00 AM

Certified Associate Application Developer - ILE RPG Programmer
Time
9/9/2019 8:00 AM - 9/11/2019 5:00 PM
8:00 AM

COMMON Certified Application Developer - ILE RPG on IBM i on Power
Time
9/9/2019 8:00 AM - 9/11/2019 8:00 PM
8:00 AM

 

Sign In