UPDATE:We want to thank Erik Knudson of Serious Computer Solutions for sharing his knowledge of the Performance Monitoring Tools on the IBM i. This was a very informative presentation. If you were not able to be there you can review the slides from his presentation here: Presentation File
Speaker: Erik Knudson, Senior Technical Consultant, Sirius Computer Solutions
Topic:IBM i Performance Monitoring Tools and Techniques
Date:Wednesday, May 20, 2015
Time:11:00 a.m. – 12:30 p.m.
Location:Murray City Offices (City Council Chambers), 5025 South State Street, Murray, Utah.
Lunch: Lunch will be served, compliments of Sirius Computer Solutions
Erik will present on the topic of IBM i performance. Gone are the days of “simply” adding memory to get better performance. Erik will cover topics from monitoring to basic tuning. Expect to learn when and how to use the myriad of IBM i tools available. Some of these tools are legacy green screen Licensed Program Products, others are PC based compliments, and of course IBM’s System i Navigator.
Erik Knudson is a senior technical consultant with Sirius Computer Solutions in Salt Lake City. He started working on AS/400 systems when the 9404-C models were announced and has worked in Salt Lake City for over 13 years, working primarily on administration-related subjects including high availability, performance, communications, backup & recovery, and networking. Erik has traveled to over 100 US based customers during his tenure with Sirius, including Alaska & Hawaii. His most recent projects have had him installing Power8 systems and a handful of 7.2 local upgrades. His experiences have spanned from one of the largest IBM i customers based in Kirkland WA down to V5R1 < 50gb systems. Regardless of your environment size, vintage, or industry, Erik can relate. His passion lies in trouble-shooting.
Our thanks go out to Allyn Walsh for flying all the way from Rochester, Minnesota to speak to our group on March 11th and experience some Spring skiing in Utah. Allyn gave us a comprehensive presentation on the new features and functions of HMC Version 8. Among other things he covered the following:
Introduce new features and enhancements
HMC V8.820 New GUI Tech Preview
HMC machine type model support
Supported upgrade paths
Classic or Enhanced
New install wizard
Performance and Capacity Monitor
Thanks again Allyn for a great presentation. If any of you were not able to make it to our meeting with Allyn you can access his presentation here in PDF form: Presentation File
Our October meeting will be held on Wednesday, October 8th at 11:00 a.m. at the Murray City Offices (City Council Chambers), 5025 South State Street. Everyone is welcome to attend.
NOTE: This will be a 90 minute session so plan accordingly. Also, lunch will be served!
Topic: SQL for the System Admin: IBM i Commands, APIs and the role of DB2 for i and SQL
Speaker: Scott Fortsie, DB2 for i Business Architect (Via Webcast)
This presentation will focus on the ways in which SQL on IBM i can be used to accomplish a number of tasks that are unrelated to traditional uses of SQL. Although the central theme of these capabilities will be systems administration, benefits can be realized beyond that topic.
You’ll learn about the SQL capabilities that exist for systems management purposes. This presentation will include working SQL examples and some compelling reasons to add SQL to your set of skills.
Note that this session has been updated for IBM i 7.2 and will include a preview of the new services coming to 6.1, 7.1 and 7.2 in 4Q/2014.
Here is the basic outline for this presentation:
Traditional IBM i Interfaces
SQL is Key for IBM i
SQL’s TCP/IP Services
SQL’s Work Management Detail
Security with SQL
SQL Storage Devices
SQL Journal Details
Find SQL Catalogs and Services
Get Going with SQL on IBM i
There are a lot of great new SQL-based services for you to use on IBM i 7.1 (and 6.1). By coming to this presentation you will position yourself for success by having the recipe to get you started in learning and implementing SQL.
Scott Forstie is the DB2 for i Business Architect, SQL Development team leader, and IBM i developerWorks content manager. In addition to his development roles, he is a frequently published author on SQL and database topics. (http://iprodeveloper.com/author/scott-forstie) He has worked for IBM nearly 25 years, working primarily on IBM i. Scott can be reached by email at firstname.lastname@example.org or followed on Twitter at @Forstie_IBMi, where he is trying to mix DB2 for i, business, and social.