Save files are an important object on our IBM i. They serve as the IBM i version of Zip files.  It’s a way to scoop up objects (including their security attributes!) put them into a container where you can restore them some place else at a later time. While that is all well and good, I think many of us don’t really have an appreciation for how many save files we have out on a system ?  How Large are they ? Did they come from this system ? or someplace else ? So many great questions that we can ask about the management of these files. This iSee will cover both the basics, as well as a deep dive on learning the inner details of these hidden mysteries.

Short demonstrations of tools, techniques and examples (including working SQL examples!!) to help you solve real problems that are part of your everyday work.  Presented by Scott Forstie and Tim Rowe, IBM

The IBM i team is announcing a series of Guided Tours on important IBM i topics.

The tours walk IBMers, partners, and customers through a series of sessions (presentations and demos) showing the key features of IBM i. Experts answer questions and show specific capabilities that are of interest.

These Guided Tours are intended for IBM and Business Partner sellers and technical sellers. Customers are also welcome to attend the Guided Tour sessions.

In the past few releases and TRs IBM has introduced a number of SQL views and table functions that allow anyone to do things to spool files that they would have had to use APIs or complex programming. Become the superstar at your company with the knowledge on how to do all of this with just a few SQL statements. Simon is a subject matter expert for COMMON North America and is the principal of RPGPGM.COM, the most popular blog about modern IBM i programming on the web. 

Learning Objectives:
1. How to find the biggest/oldest spool files on your systems.
2. How to delete old spool files.
3. How to extract data from a spool file into spreadsheet format
4. How to build views over spool files, even when they are not there
5. How to copy one spool file to PDF
6. How to copy many spool files to PDF

Here you can find tips, tricks, and session replays from the COMMON India project.  

COMMON India is brought to you by COMMON North America and Infoview Systems

What is application development for IBM i ?  Great question! There are many different views on what applications should look like. In this session we will explore what is possible when it comes to creating Modern Hybrid applications for IBM i.  What is the strategy that the operating system is marching towards and how to help you in your day to day development. This presentation is delivered by Tim Rowe, the Business Architect responsible for Application Development and Systems Management for the IBM i operating system.

In this session we discuss the partnership between COMMON North America and Infoview Systems to bring you COMMON India. Dawn May, COMMON President will provide an overview of COMMON and all the benefits this organization offers to the IBM i community.  Satya Sekhar Das Manda from Infoview Systems will talk about the organization and the collaboration with COMMON. Then Tim Rowe will speak on "IBM i and its Future." Tim is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system

Are you concerned about the security of your IBM i passwords? Join us for an eye-opening session hosted by SEA's very own Lloyd Ramdarie and Joe Hertvik. Together, they will unveil the six critical components of an efficient IBM i password management strategy. 

Here are a few takeaways from the session:

• Multi-Factor Authentication (MFA) for logins & changes: Discover how MFA can fortify your login processes and protect against unauthorized access.

• Password Composition Requirements: Gain insights into crafting robust passwords that are resistant to cyberattacks.

• Password Security Audit & Compliance: Learn how to ensure your password practices align with industry standards and compliance requirements.

• Self-service Password Reset (SSPR): Empower your users with the ability to reset their passwords securely and independently.

• Password Synchronization Between Servers: Streamline password management across your IBM i servers for enhanced efficiency.

This seminar, generously provided for Fcourtesy of SEA, is an invaluable opportunity to optimize your IBM i password management practices. Lloyd and Joe, experts in Software Engineering of America, will guide you through these crucial aspects.

Don't miss out on this chance to fortify your security measures and bolster your IBM i password management strategy.

The “i” in “IBM i” stands for “integration”, and the database is a key component of that. The IBM i team has been hard at work listening to the needs and feedback of the community and have delivered a new round of Db2 for i updates for all users of IBM i to enjoy. Join Scott Forstie, Db2 for i Business Architect, on Thursday, October 12^th at 10:00AM CST for a discussion with COMMON on the latest Db2 for i updates. Scott will overview the latest updates within Db2 for i, including new SYSTOOLS functions that add even more capabilities for system administrators, developers, and all users of IBM i alike. Learn how these new capabilities in Db2 for i will increase productivity for your teams and how to utilize updated database functions to maximize business value.  

Another year and another busy time for the IBM i team. They’ve been traveling around listening to your feedback out there in the community on needs and requirements for IBM i and are now ready to present you with the latest and greatest. Join COMMON and the IBM i Business Architects on Tuesday, October 10^th at 10:00AM CST for a roundtable discussion on the latest and greatest with the platform. You’ll hear updates about security, database, hardware, systems management, application modernization, open source, and more. Mark this on your calendar now so you don’t miss out on learning about new updates and features that will bring value to your teams, applications, and systems.