UIIPA – Our 33rd Year!

UIIPA – Our 33rd Year!

Utah IBM i Professionals Association

January Meeting: SQL Tips and Techniques on the IBM i

UPDATE: We want to thank David Larsen for a great presentation. If you were not able to make it to the meeting you can access his reference material here: 1) 33-Page slide deck  2) Document with all reference links

 

sqlSpeaker: David Larsen, Software Engineer at Lagoon Corporation

Topic: SQL Tips and Techniques on the IBM i

Date: Wednesday, January 14th, 2015

Time: 11:00 a.m. – 12:00 noon

Location: Murray City Offices (City Council Chambers), 5025 South State Street, Murray, Utah.

Our user group presentation this month will be by David Larsen. He will be introducing the basics of SQL and its implementation on the IBM i. For some of you, SQL is a very familiar tool you use every day. But for others it is a mystery of what it actually is and why you would want to use it. David will give us an overview of SQL with examples of SQL generation with System Navigator, some embedded SQL examples and many tips on how to get started using SQL. So come and learn how to use this very powerful tool.

New Picture (2)

David Larson is currently a software engineer at Lagoon Corporation. Previously he was the Director of Information Systems at Murray City for 16 years and also served as IT Director and Manager with other companies. He is also a founding member of the user group and has worked on the IBM i for many years.

 

sql-join

2014 Christmas Luncheon Highlights

Our annual Christmas Luncheon was a great success this year with over 50 people in attendance. It was held at the headquarters of Sinclair Oil Corporation in their company banquet room. We want to thank Sinclair Oil for hosting this event and sharing their world class chef and beautiful facilities with us. We were treated to a wonderful salmon and prime rib meal.

 

Our speaker was George Odencrantz, Vice President of Information Technology at Sinclair Oil. George shared with us the long history of IT at Sinclair Oil and how they are dealing with the challenges of legacy systems in a modern world. Sinclair has come a long way from the early days of manual systems to the widely diverse systems of today. George talked about the current emphasis to rebuild their systems using the modern tools and methods available for the IBM i.

 

At the end of the meeting we held a drawing for door prizes. Each attendee went away with a fun gift. We have a great group and it’s always enjoyable to get together. Thank you to all who attended.

IMG_0923IMG_0925IMG_0922IMG_0921IMG_0915IMG_0913

2014 Annual Christmas Luncheon

Christmas-LuncheonCome join us for our traditional UIIPA Christmas Luncheon. Kick off your festive season in style with a fantastic Salmon and Prime Rib lunch, a great speaker and prizes!

Date: Wednesday, December 17th, 2014

Time: Registration and mingle from 11:30-Noon with Lunch served at Noon.

Place: The banquet room at the Sinclair Oil Corporate offices located at 550 E. South Temple, Salt Lake City, Utah. (Enter the parking at the East entrance and park in the Sinclair Oil employee parking on levels P1 and P2.)

Come and share the Christmas cheer with your fellow UIIPA members and friends. That’s what this group is about. Sharing and progressing. We are looking forward, as always, to this month’s meeting. Come out, mingle, learn and share with each other!!

Remember, everyone attending will receive door prizes and a special drawing will be made for other special prizes!

Menu to Include:

Green Salad with Candied Walnuts and Cranberries

Combination Salmon and Prime Rib entrée

Garlic Mashed Potatoes

Vegetable Medley

Cheesecake with Fresh Strawberries

Rolls & Butter, Soft Drinks and Water

A paid membership entitles two people to come to the luncheon free of charge. Any additional guests will be charged $20.00 per person at the door.

We will need to give Sinclair Oil’s executive chef a count of how many people we are expecting to attend. So please RSVP to a member of the board by noon on Friday, December 12th.

 Guest Speaker:

George OdencrantzlogosOur speaker for the Christmas Luncheon this year will be George Odencrantz, Vice President of Information Technology at Sinclair Service Company. George will share with us the long history of technology at the Sinclair companies, what they are working on now and where he sees things going in the future.

Sinclair Oil is a privately held company owned by the Holding Family. It includes an oil and gas division, hospitality and resorts division and ranching division.  The oil and gas division refines about 35 million barrels of crude a year and sells over 2 billion gallons of finished product per year and has significant oil and gas exploration projects.  The hospitality division is represented by 7 hotels and 2 ski areas.  Our ranching division, located in Wyoming and Montana, farms about 30,000 head of cattle per year.

George has been with the Holding’s for 40 years. Starting at The Westgate Hotel in San Diego and spent 3 years at Sun Valley in Idaho before coming to the oil company in 1980.

Responsibilities include purchasing and managing computer systems, data communications and telecommunications for oil and hospitality. With a staff of 22 we manage to handle almost all of the IT functions for the company.

Our infrastructure include a couple of hundred servers, a couple of thousand desktops, three distributed control systems and the WAN/Lan’s to support them. We also support fifteen PBX’s and the trunks lines to support them.

We are also responsible for purchased and internally developed software that supports all of our business units.

Come join us for this year’s fun Christmas event!

geeky-little-christmas

 

November Meeting: Customer Presentation – Building World Class Operations on the IBM i

The November meeting will be a customer presentation given by Kevin Murdock, IT Director for Dealertrack DMS, a local South Jordan based company (http://www.dealertrack.com). (Contact information can be found HERE.)

Date: Wednesday, November 12th, 2014

Time: 11:00 a.m. – 12:00 noon

Location: Murray City Offices (City Council Chambers), 5025 South State Street, Murray, Utah.

Lunch: Complimentary lunch will be Subway Sandwich platter, chips and drinks

 

8461870667_388b8e8e40_zKevin will speak to us about the Dealertrack journey and how they’ve built a world class operation on the IBM i.  The session will touch on applications, technologies, databases, and share how the platform is being used to deliver global cloud solutions.

Kevin Murdock is the IT Director for Dealertrack DMS. At Dealertrack DMS, Kevin is responsible for a fast growing SaaS application used by 50k+ users in the auto dealership market. At the core of Kevin’s current architecture is the IBM i platform. High availability, disaster recovery, and performance tuning are daily areas of focus for Kevin and his team. Just recently, Kevin and his team performed a successful production datacenter migration.

3857e80Kevin’s 15 year technology background has been focused on enterprise network & security, IBM Midrange computing, storage & virtualization, and datacenter services.

Kevin has a unique perspective from his experience as a customer and a solution provider. Kevin spent 4 years as a pre-sales engineer, providing technical solutions to multiple customers in the western states. These solutions included datacenter design, storage, virtualization, high-availability/disaster recovery and IBM Midrange architectures.

 

October Meeting: SQL for the System Admin

UPDATE: Scott gave a great presentation with tons of useful information. If you missed the presentation or would like a copy of his PowerPoint slides, you can get a copy of them here: SQL for the system administrator – UIIPA- October-2014

New Picture (1)

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)

Big-SQL_27224636This 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 Catalogs
  • 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 ForstieScott 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 forstie@us.ibm.com or followed on Twitter at @Forstie_IBMi, where he is trying to mix DB2 for i, business, and social.

September Meeting: Business Intelligence and Data Analytics – What’s the Difference?

Our September meeting will be held on Wednesday, September 10th at 11:00 a.m. at the Murray City Offices (City Council Chambers), 5025 South State Street. Everyone is welcome to attend.

NOTE: Lunch will be served!

Topic: Business intelligence and Data Analytics – What’s the Difference?

Speaker: Diana Stater

what-we-do_data_analytics

Diana Stater of New Generation Software, Inc. (NGS), will break through the jargon of business intelligence and data analytics using the “Analytics Triangle” to help you understand the goals of descriptive, predictive, and prescriptive analytics, and the database management tasks and data visualization techniques that support them.  You’ll gain insight into the very different perspectives and roles of programmers, business analysts, executives, and customers/suppliers. The presentation will also include some practical applications of “big data” concepts for small to mid-size, B2B companies.

Diana StaterDiana Stater is a Business Intelligence and Financial Management Software Specialist with New Generation Software, Inc.  New Generation Software, Inc. (NGS) is a leading provider of business intelligence, query/reporting, and analytics solutions designed for IBM i users.

June Election Luncheon Highlights

Our June meeting was our annual election luncheon held at the Brick Oven restaurant in South Jordan. We had some great pizza and a great time catching up with our friends in the IBM i world. The election results were as follows:

PresidentGary Larson
Vice PresidentMatt Kingdon
Secretary – Joe Wood
Treasurer Mike Meservy

Our guest speaker was Tony Latimer, Horticulture Specialist at Thanksgiving Point. Tony shared with us his knowledge and gardening wisdom, including what it’s like to be in charge of planting over 250,000 tulip bulbs for the famous Thanksgiving Point Tulip Festival.

Thank you to all who attended!

Tony Latimer

 

 

 

 

 

 

 

 

 

 

PIC-2014-06-11 (5)

 

Annual Officer Elections and Luncheon – “ Tip Toe Through The Tulips”

Our meeting this month will be held on Wednesday, June 11th at 11:30 A.M. at the Brick Oven restaurant located at 10622 South River Front Pkwy, South Jordan, Utah. This is our annual election luncheon.  Come and enjoy endless rounds of Brick Oven’s famous pizzas, along with homemade bread sticks, cinnamon sticks, and dessert pizzas brought right to your table. Get as much as you would like to eat, but you never have to leave your seat!

Our guest speaker will be Tony Latimer, Horticulture Specialist at Thanksgiving Point, famous for their magnificent gardens and annual Tulip Festival. Come listen to an expert talk about what it takes to maintain the beautiful gardens at Thanksgiving Point and a behind-the-scenes look at the Tulip Festival. Feel free to bring your spouse or a guest if you like.

Tony Latimer

Tony Latimer – Horticulture Specialist at Thanksgiving Point

Tony Latimer has worked for Thanksgiving Point since 2000 in various roles such as Garden Supervisor, Greenhouse Manager, Garden Manager, and currently as Horticulture Specialist.  As a Horticulture Specialist he manages a 55 acre estate garden, 7,000 square feet of greenhouse space, and the landscape maintenance of the Thanksgiving Point complex which includes; a 22 acre park, 4 acres of gardens used for weddings and other events, and a number of other landscaped building.  Tony graduated in 1997 from Utah State University with a Bachelor of Science in Ornamental Horticulture.  For 2 years he worked in a 7 acre production greenhouse growing annuals, poinsettias, and chrysanthemums.  He spent another year working in property maintenance before coming to Thanksgiving Point.  He is currently serving on the Executive Board of the Utah Nursery and Landscape Association.

This is our Annual Officer Elections for the Utah IBM i Professionals Association and we invite everyone to come and vote to select our next year’s leadership. We ask each member to consider this opportunity to become involved in leading this group here in Utah. It is indeed an honor and opportunity to get to know other talented individuals in this group and the IBM supporting team and other IBM business partners who help in pulling together our monthly meetings.

A paid membership entitles two people to come to the luncheon free of charge. Any additional guests will be charged $15.00 per person at the door. Checks should be made out to UIIPA. We will need to give the Brick Oven a count of how many people we are expecting to attend. So please RSVP to a member of the board by noon on June 9th.

Some highlights of the Thanksgiving Point Gardens:

Thanksgiving-Point-01-2

garden

Gardens (2)Gardens (3)

4750405772_455579c6aa_z

 

May Meeting Highlights

May meetingWe want to thank Mark Ruberry of IBM for flying in from Seattle to speak to our group this month. His topic was POWER8 and IBM i 7.2 Announcements. We had a great turnout and we were not disappointed with the presentation. We also enjoyed a BBQ lunch provided by Matt Kingdon and Ciber.

POWER8: IBM continues to deliver on technology with the latest hardware announcements, significantly improving the performance and throughput. When IBM says it is going to deliver, it does just that. It was interesting to note that Google has teamed up with IBM in the development of custom made hardware based on the POWER8 chip to use in their search engine servers. Obviously, with Google, they need processing power and POWER8 delivers.

IBM i 7.2: IBM announced the release of IBM i 7.2, the first new release in four years. This release provides significant new function to the operating system including taking advantage of the new Power Systems servers running on the new POWER8 technology.

 IBM i 7.2 new enhancements include:

  • Enhanced security options in DB2 for i
  • Many new functions for programmer productivity and expanded function in DB2 for i
  • Improved ease of use with IBM Navigator for i
  • Enhancements to iAccess Client Solutions
  • Extension of security to more applications through new single sign-on (SSO) environments
  • Liberty Core as the base for Integrated Application Server
  • Support for Zend Server 6.0 on IBM i 7.2
  • Performance improvements for the IFS
  • Extensions to the printing environments
  • Expanded Hub functions for Backup, Recovery, and Media Services (BRMS)
  • PowerHA SystemMirror for i Express Edition with new HyperSwap capability
  • Support for new Power Systems built with POWER8 architecture and processor
  • Additional I/O capabilities including support for WAN over LAN
  • Rational tools enhancements to support Free Format RPG
  • Support for the open-source file-serving solution Samba

May meeting 2

May Meeting: Mark Ruberry presents POWER8 and IBM i 7.2 Announcements

Power8Our May meeting will be held on Thursday, May 15th at 11:00 a.m. at the Murray City Offices (City Council Chambers), 5025 South State Street. Everyone is welcome to attend and enjoy a FREE BBQ LUNCH at the end of the presentation provided by Matt Kingdon of CIBER!

ATTENTION: Please note this month’s meeting is being held on a Thursday instead of the usual Wednesday.

Topic: POWER8 and IBM i 7.2 Announcements

Speaker: Mark Ruberry

  • IBM POWER8 Announcement: In a move to disrupt the server industry, IBM debuted its newest Power Systems servers built on an open computing platform. These new systems are the culmination of $2.4 billion of investment, three-plus years of development and exploit hundreds of IBM patents. Powered by the POWER8 microprocessor, the systems are created to harness massive amounts of data and can analyze Big Data workloads up to 50 times faster than commodity servers. In tandem with this announcement, the OpenPOWER Foundation officially unveiled its technology roadmap. This roadmap marks a significant shift in the business computing industry and highlights the potential of a collaborative ecosystem to spawn innovation.
  • IBM i 7.2 Announcement: With the announcement of IBM i 7.2, IBM is extending the integration message of IBM i. This new release of IBM i provides significant new function in DB2 for i, systems management, and security as well as enhancing many other integrated components and licensed programs. IBM i 7.2 includes support for the latest Power Systems server family.

Please join us for this informative presentation.

Mark RuberryMark Ruberry is an IBM Client Technical Specialist supporting Power Systems. He has worked in the Information Technology industry with IBM for 35 years. Mark began his career with IBM as a Systems Engineer providing technical support for the IBM family of mid-range systems including the 5110, 5120, System/23, System/34, System/36, System/38, and AS/400. Mark worked for IBM Global Services during the 1990s providing consulting services to customers with AS/400 and iSeries systems. His service engagements included many CISC to RISC system migrations. Mark transitioned from Global Services to his current role during the summer of 2000. He has worked on almost all aspects of Power Systems and the IBM i operating system.