Loading…
Common Sweden Conference 2024
Attending this event?
Welcome to Common Sweden Conference
Monday, September 23
 

08:00 CEST

Conference Welcome Desk Open
Monday September 23, 2024 08:00 - 09:00 CEST
Monday September 23, 2024 08:00 - 09:00 CEST
Exhibitor hall

09:00 CEST

Opening Session - Welcome and Key Note Speakers
Monday September 23, 2024 09:00 - 10:15 CEST
Speakers
avatar for Douglas Gibbs

Douglas Gibbs

IBM i Product Manager, Program Director, IBM
Douglas Gibbs is the Program Director and Product Manager for the IBM i platform.  He is responsible for team leading the IBM i product direction and offerings on the Power platform.  Douglas has worked at IBM Canada for 24 years and has been a member of the Product Management team... Read More →
avatar for Mats Lidström

Mats Lidström

CPO, IBM i Cheif Architect, Apper Systems AB
I have been working with IBM i (and it predecessors) since 1987 as a Programmer, Designer, Head of development, CIO and Architect. I have been part of a number of national and international projects throughout the years. Since 2018 I work for Apper and are helping customers to take... Read More →
Monday September 23, 2024 09:00 - 10:15 CEST
Djurgårdssalen

10:15 CEST

Coffee break
Monday September 23, 2024 10:15 - 10:45 CEST
Monday September 23, 2024 10:15 - 10:45 CEST
Exhibitor hall

10:45 CEST

Introduction to VS Code for IBM i
Monday September 23, 2024 10:45 - 11:45 CEST
VS Code for IBM i is a powerful IDE that enables developers to build and deploy applications for the IBM i platform quickly and efficiently. It includes a powerful code editor that provides syntax highlighting, code completion, and code refactoring. It also includes integration n with IBM i’s database and security features, making it easier to develop secure applications. Included as well is an integrated debugger. In this session we will highlight some of its major components and discuss how it can be used for everyday development.
Speakers
avatar for Charlie Guarino

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
Monday September 23, 2024 10:45 - 11:45 CEST
Seglora

10:45 CEST

SQL Views and UDTF (User Defined Table Functions)
Monday September 23, 2024 10:45 - 11:45 CEST
SQL has become very powerful. It includes for example recursions, multi-dimensional grouping, OLAP specifications, IFS and Webservice access …. But not everybody will be able to code complex queries … and this is not necessary as long the programmer can easily use them.
With SQL Views complexity can be hidden. Since a SQL View can be used in a SELECT statement like a table even beginners can write reports based on complex SELECT statements.
How ever, sometimes more than one step is needed to retrieve the desired data. In this situation User Defined Functions (UDFs) or User Defined Table Functions come into play.
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
Monday September 23, 2024 10:45 - 11:45 CEST
Skansen

10:45 CEST

The AI Revolution: From Theory to Practice, Shaping Tomorrow's World
Monday September 23, 2024 10:45 - 11:45 CEST
"The advent of artificial intelligence (AI) marks a pivotal moment in human history, transitioning from theoretical constructs to practical applications that are rapidly transforming diverse facets of society. By analyzing case studies and real-world applications, this session provides insights into how AI is reshaping our world and offers a roadmap for navigating the opportunities and challenges that lie ahead.
Speakers
avatar for Koen Decorte

Koen Decorte

Owner and CEO, IBM Champion, CD-Invest
Koen Decorte is owner of CD Invest, an international IBM business partner with offices in Belgium andSpain. CD-Invest is specialized in innovating and modernizing IBM i applications.Koen studied philology and computer linguistics.His focus is mainly on integrating and using open source... Read More →
Monday September 23, 2024 10:45 - 11:45 CEST
Solliden

10:45 CEST

BRMS - Beyond the Basics
Monday September 23, 2024 10:45 - 11:45 CEST
This session will discuss some of the advanced topics in using BRMS for your back up and recovery. Featured topics will be tape and library management, BRMS Networking,  control group and list controls, BRMS Policies and how they affect the overall operation of BRMS, and using SQL to manage BRMS. Recovering from a BRMS back up can be extremely easy, but it can also present some opportunities for trouble. This session will discuss some of the landmines in a BRMS recovery and how to avoid them.
Speakers
avatar for Sarah Jacob

Sarah Jacob

VP of Customer Experience, Agile Technology Architects
Sarah Jacob is the Vice President of Customer Experience at Agile Technology Architects. She is a Subject Matter Expert in Power Systems Administration and a volunteer for COMMON. Sarah specializes in Backup and Recovery planning and recovery testing. Additionally, she acts as primary... Read More →
Monday September 23, 2024 10:45 - 11:45 CEST
Prins Eugen

12:00 CEST

Service Programs and Unit Testing – The perfect pair
Monday September 23, 2024 12:00 - 13:00 CEST
Do you have monolithic programs that you have to start breaking up into manageable pieces? Have you been tasked to start unit testing and don’t know where to start? This session is meant for you.
We will work through the benefits to modernizing your code and why you want to adopt unit testing. We will work through breaking apart monolithic programs and how to write their respective unit tests. We will discuss some best practices in unit testing and how you can take some of those best practices and apply them to your everyday development processes.
Speakers
avatar for Marina Schwenk

Marina Schwenk

Innovative Software Solutions
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →
Monday September 23, 2024 12:00 - 13:00 CEST
Skansen

12:00 CEST

Simplify your life with SQL services
Monday September 23, 2024 12:00 - 13:00 CEST
There are so many services in SQL on our platform. They can make your life a bit simpler. I will show a few services and show how they are done within SQL.

Learning Objectives:
will leave with new ideas about how they can try new services when they get home.
Speakers
avatar for Sven Jansson

Sven Jansson

Senior developer, Apper Systems AB
I have worked on the IBM i platform since 1995. My technical roles include developer, analyst, database specialist, application security, and communications. I also worked on IBMz for a few years, and I serve on the COMMON Sweden board. I'm a curious person who always wants to learn... Read More →
Monday September 23, 2024 12:00 - 13:00 CEST
Seglora

12:00 CEST

Debugging with VScode
Monday September 23, 2024 12:00 - 13:00 CEST
VS Code for IBM i is a powerful IDE that enables developers to quickly and efficiently build, and deploy applications for the IBM i platform. It includes a powerful code editor that provides syntax highlighting, code completion, and code refactoring. It also includes integration with IBM i’s database and security features, making it easier to develop secure applications. It also includes an integrated debugger. In this session we will highlight some of the major components and discuss how it can be used for everyday development.
Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, IBM
I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :) 
Monday September 23, 2024 12:00 - 13:00 CEST
Solliden

12:00 CEST

How Healthy is your IBM i?
Monday September 23, 2024 12:00 - 13:00 CEST
We all know our favourite system is a tough cookie, it soldiers on day in day out with little support from us but how can you actually tell howhealthy it really is?
In this session, we run you through a series of simple ideas that you can take away and try on your system. They will not only help you quickly gauge the current health of your system but also allow you to track changes in behaviour and help you to detect changes early and plan your future needs with confidence. In most cases we find that following these simple steps will not only improve the performance of your server but extend it's working life and reduce the need for upgrades.
Speakers
avatar for Steve Bradshaw

Steve Bradshaw

Friendly Techie, Rowton IT Solutions Ltd
I've worked in the IBM Business Partner world for over thirty years now and despite IBM's best attempts I still love them ;-)In 2008 I set up my practice (Rowton) and now spend my time supporting clients or designing new IT solutions using a combination of Power servers, Intel and... Read More →
Monday September 23, 2024 12:00 - 13:00 CEST
Prins Eugen

13:00 CEST

Lunch
Monday September 23, 2024 13:00 - 14:00 CEST
Monday September 23, 2024 13:00 - 14:00 CEST
Exhibitor hall

14:00 CEST

Db2 for i inside of VS Code
Monday September 23, 2024 14:00 - 15:00 CEST
VS Code is really built with developers in mind. IBM has been building a neat Visual Studio Code extensions that makes accessing and working with the database much simpler for developers. Not only can VS Code be used for writing in many different languages, but now it has great tools for working with Db2 for i. You might see exporting data, working with examples, browsing your schemas, or even managing multiple database configurations. There's a lot to see!
Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →
avatar for Liam Allan

Liam Allan

Software Advocate, IBM
I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :) 
Monday September 23, 2024 14:00 - 15:00 CEST
Skansen

14:00 CEST

IBM i Modernization – The Key to a Brighter Future
Monday September 23, 2024 14:00 - 15:00 CEST
This presentation aims to unravel the importance of modernizing IBM i systems and how it paves the way for a more innovative and efficient future in technology. We will explore the latest trends, tools, and strategies essential for modernizing applications, infrastructure, and development practices on the IBM i platform. Learn how embracing modernization can enhance performance, increase competitiveness, and ensure the longevity of your IT investments.
Speakers
avatar for Charlie Guarino

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
Monday September 23, 2024 14:00 - 15:00 CEST
Seglora

14:00 CEST

PTF Management
Monday September 23, 2024 14:00 - 15:00 CEST
Keeping your system up to date and secure requires knowledge of the PTFs. Here will will discuss what the PTFs are, how to get them, and how to apply them. We will also discuss the different types of PTFs and how to develop a PTF strategy for your organization.
Speakers
avatar for Sarah Jacob

Sarah Jacob

VP of Customer Experience, Agile Technology Architects
Sarah Jacob is the Vice President of Customer Experience at Agile Technology Architects. She is a Subject Matter Expert in Power Systems Administration and a volunteer for COMMON. Sarah specializes in Backup and Recovery planning and recovery testing. Additionally, she acts as primary... Read More →
Monday September 23, 2024 14:00 - 15:00 CEST
Prins Eugen

14:00 CEST

Securing the IFS
Monday September 23, 2024 14:00 - 15:00 CEST
Securing the IFS remains a mystery to many administrators. Different authorities and the need to use different commands can be confusing! In this session Carol Woodbury will explain how security works in the IFS and provide techniques for securing it. She will also describe enhancements made in IBM i 7.5 that have made securing the IFS even easier as well as techniques for avoiding ransomware and other malware attacks.
Speakers
avatar for Carol Woodbury

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems
With over 30 years' experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →
Monday September 23, 2024 14:00 - 15:00 CEST
Solliden

15:00 CEST

Coffee break
Monday September 23, 2024 15:00 - 15:15 CEST
Monday September 23, 2024 15:00 - 15:15 CEST
Exhibitor hall

15:15 CEST

How Do I Improve Software Quality?
Monday September 23, 2024 15:15 - 16:15 CEST
Every programmer wants to do the best job. How do you test your program and ensure that you aren't missing anything? From the simplest bug fix to large complex projects, there are key concepts that you can use to ensure that your program is properly tested. This session is co-presented by expert developer, Scott Klement, and expert tester, Yvonne Enselman so that you can see things from both a developer and tester's perspective.
Speakers
avatar for Scott Klement

Scott Klement

Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
avatar for Yvonne Enselman

Yvonne Enselman

Principal Architect for Quality Assurance on IBM i, Yvonne Enselman Professional Services
Monday September 23, 2024 15:15 - 16:15 CEST
Prins Eugen

15:15 CEST

TBD - Liam
Monday September 23, 2024 15:15 - 16:15 CEST
Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, IBM
I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :) 
Monday September 23, 2024 15:15 - 16:15 CEST
Seglora

15:15 CEST

What's New in Db2 for i
Monday September 23, 2024 15:15 - 16:15 CEST
In the tradition of previous Technology Refreshes (TR), the database team is delivering enhancements on the same cadence. Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more. This session will cover the new and enhanced Db2 for i capabilities added to IBM i 7.4 and IBM i 7.5 over the most recent IBM i Technology Refreshes.

This session will include something for everyone and anyone who uses the IBM i.

Resources: https://www.ibm.com/support/pages/node/1119129 and http://ibm.biz/Db2foriSQLTutor

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →
Monday September 23, 2024 15:15 - 16:15 CEST
Solliden

15:15 CEST

IBM i Services the Future of Systems Management
Monday September 23, 2024 15:15 - 16:15 CEST
IBM i Services are perhaps the best-kept secret of managing and monitoring IBM i. Relatively few users of our favourite platform know what they are and even fewer use them regularly. This is a crying shame as they are truly remarkable. IBM i Services can tell you in seconds what it takes a skilled system operator minutes or even hours to discover.
Speakers
avatar for Steve Bradshaw

Steve Bradshaw

Friendly Techie, Rowton IT Solutions Ltd
I've worked in the IBM Business Partner world for over thirty years now and despite IBM's best attempts I still love them ;-)In 2008 I set up my practice (Rowton) and now spend my time supporting clients or designing new IT solutions using a combination of Power servers, Intel and... Read More →
Monday September 23, 2024 15:15 - 16:15 CEST
Skansen

16:30 CEST

Analyzing ILE Objects with SQL respective Db2 and IBM i Services
Monday September 23, 2024 16:30 - 17:30 CEST
With the latest Releases and Technology Refreshes IBM added a lot of powerful IBM and Db2 Services to Db2 for i and SQL, for example for work management, security, database, IFS …
But there are also all kinds of Services that help to analyze and manage ILE Objects, such as modules, service programs (with exported procedures), programs and Binding Directories.
This session combines an introduction into the ILE Concepts and shows what services are available for analyzing the ILE Objects (modules, programs, service programs, modules …)
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
Monday September 23, 2024 16:30 - 17:30 CEST
Skansen

16:30 CEST

Maximizing the benefits of embedding SQL in your RPG code
Monday September 23, 2024 16:30 - 17:30 CEST
Many people are now integrating SQL into RPG programs & procedures. Simon will give practical examples of how you can optimize the performance of your statements & simply diagnose the feedback returned from Db2. Will include mentions of how using Views enhances this optimization process.
1. SQL I/O methods to get data from the database faster
2. Better method to capture errors, or what happened with your SQL statements
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America, awarded... Read More →
Monday September 23, 2024 16:30 - 17:30 CEST
Seglora

16:30 CEST

My Vision For the Future
Monday September 23, 2024 16:30 - 17:30 CEST
The world is changing. You can see it if you look around you... computers understand your voice, cars drive themselves, and so much more! What will things look like in 10 or 20 years? How will the world change? And, most importantly, how can we be ready for it?
Speakers
avatar for Scott Klement

Scott Klement

Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
Monday September 23, 2024 16:30 - 17:30 CEST
Prins Eugen

16:30 CEST

IBM i Security with an SQL Chaser
Monday September 23, 2024 16:30 - 17:30 CEST
In this award-winning session, be prepared to hear Scott Forstie and Carol Woodbury shake up the world of IBM i Security, mixing up new SQL concoctions to bedazzle the otherwise boring world of IBM i Security. This menu includes examples of using SQL to find vulnerabilities in your code (aka penetration testing) as well as new (but practical!) ways to use SQL services to discover and fix your security out your current processes that have reached their ‘consume by’ date. A note of caution, however. You may leave a bit shaken (but not stirred).
Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →
avatar for Carol Woodbury

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems
With over 30 years' experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →
Monday September 23, 2024 16:30 - 17:30 CEST
Solliden
 
Tuesday, September 24
 

07:00 CEST

Conference Welcome Desk Open
Tuesday September 24, 2024 07:00 - 08:00 CEST
Tuesday September 24, 2024 07:00 - 08:00 CEST
Exhibitor hall

08:00 CEST

Generating JSON Documents with SQL (SQL and JSON – Part 1)
Tuesday September 24, 2024 08:00 - 09:00 CEST
JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose and can be faster parsed than XML. In this way JSON becomes more and more important especially when data is exchanged by RESTful web services. The use of XML declines in favor of JSON. SQL on Db2 for i includes all kinds of scalar and aggregate functions for generating JSON objects, arrays, literals and for combining JSON components into complete documents. Since Release 7.5 TR 1 it is even possible to update/modify JSON documents. The focus of this session is to generate JSON documents.
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
Tuesday September 24, 2024 08:00 - 09:00 CEST
Skansen

08:00 CEST

RPG array magic and Simple ways to convert your DDS files into DDL statements
Tuesday September 24, 2024 08:00 - 09:00 CEST
(Currently short 20 - 30 mins)
Learn how the recent enhancements to RPG have added many new features & enhancements to the way you can use arrays. This will include all the new Built in Functions, Data Structure arrays, & dynamic arrays.
1. Modern ways to code arrays to include the latest features, & what stops you from using them.
2. How Data Structure arrays simplify you getting information from the database.
3. The new Built in Functions for arrays that replace a lot of the complicated coding we use to do.

(Short session 20 - 30 mins)
Modernization is more than putting a GUI front-end on your applications. Database modernization should also be included, converting from DDS files to DDL tables, index, & views. All of the tools needed to do this is included with your IBM i & Db2 for I at no additional charge. Why use a third party tool when you can do it for free? Will also include how you can de-create various SQL objects into statements.
1. Learn what tools are available to convert DDS to DDL
2. See example of how to use them
3. Learn how to recover the SQL statement used to create various SQL objects
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America, awarded... Read More →
Tuesday September 24, 2024 08:00 - 09:00 CEST
Seglora

08:00 CEST

TBD - Liam
Tuesday September 24, 2024 08:00 - 09:00 CEST
Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, IBM
I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :) 
Tuesday September 24, 2024 08:00 - 09:00 CEST
Solliden

08:00 CEST

Hidden Gems
Tuesday September 24, 2024 08:00 - 09:00 CEST
If you have anyone coming from IBM Rochester, I can combine with them to deliver and IBM i Hidden Gems session
Speakers
avatar for Steve Bradshaw

Steve Bradshaw

Friendly Techie, Rowton IT Solutions Ltd
I've worked in the IBM Business Partner world for over thirty years now and despite IBM's best attempts I still love them ;-)In 2008 I set up my practice (Rowton) and now spend my time supporting clients or designing new IT solutions using a combination of Power servers, Intel and... Read More →
Tuesday September 24, 2024 08:00 - 09:00 CEST
Prins Eugen

09:15 CEST

Få bättre sömn
Tuesday September 24, 2024 09:15 - 10:15 CEST
Speakers
Tuesday September 24, 2024 09:15 - 10:15 CEST
Djurgårdssalen

10:15 CEST

Coffee break
Tuesday September 24, 2024 10:15 - 10:30 CEST
Tuesday September 24, 2024 10:15 - 10:30 CEST
Exhibitor hall

10:30 CEST

Experience the Wonders of AI: Come Marvel with Me!
Tuesday September 24, 2024 10:30 - 11:30 CEST
This session explores the fascinating world of AI, demonstrates its possibilities and how it can be used to improve our lives. We will discuss some of the latest available technologies and work with them in real time. This session is perfect for anyone looking to learn more about AI and the potential it has to offer
Speakers
avatar for Charlie Guarino

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
Tuesday September 24, 2024 10:30 - 11:30 CEST
Seglora

10:30 CEST

Modernisering steg för steg - kund case
Tuesday September 24, 2024 10:30 - 11:30 CEST
Valet stod mellan att byta ut det gamla till ett nytt standardsystem, men...
Speakers
avatar for Mats Lidström

Mats Lidström

CPO, IBM i Cheif Architect, Apper Systems AB
I have been working with IBM i (and it predecessors) since 1987 as a Programmer, Designer, Head of development, CIO and Architect. I have been part of a number of national and international projects throughout the years. Since 2018 I work for Apper and are helping customers to take... Read More →
Tuesday September 24, 2024 10:30 - 11:30 CEST
Skansen

10:30 CEST

Beyond PTFs - Updating HMC, FSP, SAN and more
Tuesday September 24, 2024 10:30 - 11:30 CEST
Applying PTFs is only one part keeping your system up to date. In this session we will learn to apply updates to your hardware - the FSP, the HMC, and the SAN.  We will go over the access to the FSP through ASMI as well.
Speakers
avatar for Sarah Jacob

Sarah Jacob

VP of Customer Experience, Agile Technology Architects
Sarah Jacob is the Vice President of Customer Experience at Agile Technology Architects. She is a Subject Matter Expert in Power Systems Administration and a volunteer for COMMON. Sarah specializes in Backup and Recovery planning and recovery testing. Additionally, she acts as primary... Read More →
Tuesday September 24, 2024 10:30 - 11:30 CEST
Prins Eugen

10:30 CEST

Take the Guesswork out of IBM i Security with Authority Collection
Tuesday September 24, 2024 10:30 - 11:30 CEST
Want to remove *ALLOBJ from a service account but afraid you'll break something?   Can't determine where a user's authority to access a production file is coming from?  Don't know how much authority is required to access files in the IFS?   All of these questions can be answered using Authority Collection - a powerful feature added in V7R3 and enhanced in V7R4.  During this session, Carol Woodbury will demo Authority Collection and provide you with practical ways you can use it in your organization.
 
Speakers
avatar for Carol Woodbury

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems
With over 30 years' experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →
Tuesday September 24, 2024 10:30 - 11:30 CEST
Solliden

11:45 CEST

BI and AI on IBM i
Tuesday September 24, 2024 11:45 - 12:45 CEST
How AI and BI will bring the next generation of business analytics
If you’ve spent any time online in the last few months, you likely saw the buzz around ChatGPT, a new chatbot developed by OpenAI. Suddenly, the capabilities of artificial intelligence and machine learning (AI/ML) are democratized, their insights and guidance no longer exclusively available for data scientists. While the breadth and depth are unclear, it is certain they will have an impact for years to come. AI/ML will play a pivotal role in providing leaders the information, insight, and recommendations as to how best to optimize and modernize their IT environments.
We will show how to take BI a step further with AI capabilities that not only bring an accurate, trusted and complete picture of your business, but forecast what’s coming in the future, predict outcomes and explain why they may happen.
What if you were able to make things happen. Get a glimpse off what prescriptive AI can do with real life data.
Speakers
avatar for Koen Decorte

Koen Decorte

Owner and CEO, IBM Champion, CD-Invest
Koen Decorte is owner of CD Invest, an international IBM business partner with offices in Belgium andSpain. CD-Invest is specialized in innovating and modernizing IBM i applications.Koen studied philology and computer linguistics.His focus is mainly on integrating and using open source... Read More →
Tuesday September 24, 2024 11:45 - 12:45 CEST
Solliden

11:45 CEST

Tame the IFS with SQL Services
Tuesday September 24, 2024 11:45 - 12:45 CEST
In this session, you will discover how SQL and IBM i (SQL) Services can be used to bring order to the IFS. Whether you aim to further secure, manage, or utilize the IFS, SQL can help get the job done. The Db2 for i team has made consistent and noteworthy investments to bring SQL capabilities that can be used with the IFS. Come to this session to see, understand, and be ready to use SQL with the IFS.
Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →
Tuesday September 24, 2024 11:45 - 12:45 CEST
Prins Eugen

11:45 CEST

What's New and Exciting in RPG
Tuesday September 24, 2024 11:45 - 12:45 CEST
With each new release of the IBM i operating system and with Technology Refreshes, IBM has given us some new features in RPG. This session tells you about the new and exciting features of RPG and how you might like to use each feature in your own applications.
Speakers
avatar for Scott Klement

Scott Klement

Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
Tuesday September 24, 2024 11:45 - 12:45 CEST
Seglora

11:45 CEST

Troubleshooting tips and tricks
Tuesday September 24, 2024 11:45 - 12:45 CEST
Have you ever tried to figure out a problem and you don’t know where to begin? Have you ever received a level 1 or level 2 help desk call and want to scream? How many times have you looked at your code and wanted to figure out how to troubleshoot the problem? This session is for you. We are going to give you some tips and tricks to help you overcome most common developer and user issues.
Speakers
avatar for Marina Schwenk

Marina Schwenk

Innovative Software Solutions
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →
Tuesday September 24, 2024 11:45 - 12:45 CEST
Skansen

12:45 CEST

Lunch
Tuesday September 24, 2024 12:45 - 13:45 CEST
Tuesday September 24, 2024 12:45 - 13:45 CEST
Exhibitor hall

13:45 CEST

Integrating open source with traditional applications
Tuesday September 24, 2024 13:45 - 14:45 CEST
The question is not “whether open source” can work on the IBM i – The question is: what is best for you? Find out how to secure them and what open source can do for you. This workshop will focus on how ILE programs interact with various open source tools, including sending data to programs as parameters, retrieving results, and harnessing the power of open source tools to use results. in an innovative way. By the end of the workshop, you should have a better idea of how traditional IBM i programs can interact with open source tools.
Speakers
avatar for Koen Decorte

Koen Decorte

Owner and CEO, IBM Champion, CD-Invest
Koen Decorte is owner of CD Invest, an international IBM business partner with offices in Belgium andSpain. CD-Invest is specialized in innovating and modernizing IBM i applications.Koen studied philology and computer linguistics.His focus is mainly on integrating and using open source... Read More →
Tuesday September 24, 2024 13:45 - 14:45 CEST
Solliden

13:45 CEST

Programming Standards and Guidelines
Tuesday September 24, 2024 13:45 - 14:45 CEST
We have all unfortunately seen really bad code or really bad practices. Have you ever wanted to take that code and throw it against the wall and start over? This session will give you the steps and guidelines that will help you start the discussion so you and your colleagues can implement standards and guidelines and start the process of cleaning up your code or the code you have inherited.

1. We will look over various different recommended programming standards and guidelines.
2. we will look at bad code vs new code and make recommendations that you can take back and implement in your shop.
3. We will learn why its important to have standards and guidelines and how you can start the standards discussions at your shop.
Speakers
avatar for Marina Schwenk

Marina Schwenk

Innovative Software Solutions
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →
Tuesday September 24, 2024 13:45 - 14:45 CEST
Skansen

13:45 CEST

Simon's top 10 SQL favorites
Tuesday September 24, 2024 13:45 - 14:45 CEST
IBM Champion Simon Hutchinson has written a lot about modern Db2 for i and SQL on his blog for the past nine years. In this session he will take you through his top 10 favorites. You will have to attend to learn what these cool SQL tricks and tips are!
(Constantly revised for each release & TR. Different from what I showed last year)
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America, awarded... Read More →
Tuesday September 24, 2024 13:45 - 14:45 CEST
Seglora

13:45 CEST

i Chi - The Art of System Management
Tuesday September 24, 2024 13:45 - 14:45 CEST
We all want to have healthy, performant and reliable servers but how do we know how healthy are servers really are?

Fear not, in this joint presentation tips and tricks are delivered in turns to check a server is healthy, using all the latest tooling that is currently available: IBM i Access Client Solutions, CLI, the HMC.

Add to that we share real life life stories based on our own observations and experiences
Speakers
avatar for Steve Bradshaw

Steve Bradshaw

Friendly Techie, Rowton IT Solutions Ltd
I've worked in the IBM Business Partner world for over thirty years now and despite IBM's best attempts I still love them ;-)In 2008 I set up my practice (Rowton) and now spend my time supporting clients or designing new IT solutions using a combination of Power servers, Intel and... Read More →
Tuesday September 24, 2024 13:45 - 14:45 CEST
Prins Eugen

14:45 CEST

Coffee break
Tuesday September 24, 2024 14:45 - 15:00 CEST
Tuesday September 24, 2024 14:45 - 15:00 CEST
Exhibitor hall

15:00 CEST

Beyond the Buzz: Practical AI Implementation in IT and Industry
Tuesday September 24, 2024 15:00 - 16:00 CEST
AI can be used in many different ways, from creating robots to helping with medical diagnoses. From automating mundane customer service tasks to improving decision making and predictive analytics. See how AI can help businesses save time and money, as well as improve customer service.
Speakers
avatar for Charlie Guarino

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
Tuesday September 24, 2024 15:00 - 16:00 CEST
Seglora

15:00 CEST

Consuming JSON Documents and Web Services with SQL (SQL and JSON – Part 2)
Tuesday September 24, 2024 15:00 - 16:00 CEST
JSON becomes more and more important especially in RESTful web services the, use of XML declines in favor of JSON.
With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically out.
Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members. Last but not least IBM provides SQL functions for getting access to web services. In composition with the JSON_TABLE function the JSON responses returned by web services can be consumed
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
Tuesday September 24, 2024 15:00 - 16:00 CEST
Skansen

15:00 CEST

Getting the Most out of your IBM i Audit Journal
Tuesday September 24, 2024 15:00 - 16:00 CEST
The audit journal contains so much information but has not been easy to access … until now. During this session Carol Woodbury will discuss the modern ways to access the IBM i audit journal, as well as the most recent audit enhancements. She will also discuss how the information can be used as an early warning signal of an attack on your organization.
Speakers
avatar for Carol Woodbury

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems
With over 30 years' experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →
Tuesday September 24, 2024 15:00 - 16:00 CEST
Solliden

15:00 CEST

Work Management Optimization
Tuesday September 24, 2024 15:00 - 16:00 CEST
This session will introduce IBM i Work Management to the developer and other new system administrators. We will explore how the system is configured and managed using IBM i Navigator for i, with examples from ACS, SQL Services, and the traditional character based interface as well. As delivered your IBM i installation work, but it is not optimized for your environment. All too often the performance of your system is impacted by poor work management practices. Learn how to take the first steps to optimizing your IBM i Work Management.
Speakers
avatar for Sarah Jacob

Sarah Jacob

VP of Customer Experience, Agile Technology Architects
Sarah Jacob is the Vice President of Customer Experience at Agile Technology Architects. She is a Subject Matter Expert in Power Systems Administration and a volunteer for COMMON. Sarah specializes in Backup and Recovery planning and recovery testing. Additionally, she acts as primary... Read More →
Tuesday September 24, 2024 15:00 - 16:00 CEST
Prins Eugen

16:15 CEST

Closing session
Tuesday September 24, 2024 16:15 - 17:00 CEST
Speakers
avatar for Mats Lidström

Mats Lidström

CPO, IBM i Cheif Architect, Apper Systems AB
I have been working with IBM i (and it predecessors) since 1987 as a Programmer, Designer, Head of development, CIO and Architect. I have been part of a number of national and international projects throughout the years. Since 2018 I work for Apper and are helping customers to take... Read More →
Tuesday September 24, 2024 16:15 - 17:00 CEST
Djurgårdssalen
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.