Tuesday, January 11, 2022

                                                                     Happy New Year !



----------------------------------------------------------------------------------------------------------------------------------------
 
"Where success is concerned, people are not measured in inches, pounds, college degrees or family back-ground; they are measured by the size of their thinking"
 
----------------------------------------------------------------------------------------------------------------------------------------
 
Welcome to the IBM i Reference blog. I trust you'll find value. If there is something you find that can help the IBM i community, please contact me with that link / page and I'll add it to this repository.

This will be a continuing project. The goal is a 1 stop discovery for most anything you may need to help and/or enhance your IBM i job or analysis. There is also an "Other Sites of Interest" page that has tools to further help you on the job.

This blog came about after a lot of research to help myself on the system over the years when I didn't have IBM support contracts. I accumulated several google bookmark's of material - hundred's of sites. Some are still valid, many have been moved and updated while others have fallen by the wayside. 

I have done my best to vet the sites. It is a much cleaner, updated collection of resources than several exported google bookmark pages.

The links are designed to open in a new tab. If a link does not open or returns an error, please send me a message and I'll get it corrected. 

Note that there might be a bit of redundancy due to some of the posted links containing the same resources. 

----------------------------------------------------------------------------------------------------------------------------------------

IBM i Articles from Various Online Sources

Ash Giddings - Maxava
 
Alex Woodie - IT Jungle

Steve Will - IBM i Chief Architect 
 
Nick Litten - Waffle From My Brain Blog
 
Alex Woodie - IT Jungle

----------------------------------------------------------------------------------------------------------------------------------------

IBM Announcements 
 
 

 
IBM i System Subscription Enhanced Hardware Capabilities                                                    
 
 
 
 

IBM i V7R4 TR6 Page                                                                                                                            IBM i V7R4 TR7 Page                                                                                                                              IBM i V7R4 Enhancements Page                                                                                                                                                                                                                                                  IBM i V7R5 TR1 Page                                                                                                                         IBM i V7R5 TR1 Enhancements Page                                                                                                  IBM i V7R5 (MERLIN) Modernization Engine for Lifecycle Integration Overview Page                   IBM i V7R5 (MERLIN) Modernization Engine for Lifecycle Integration Video                                  IBM i V7R5 (MERLIN) Modernization Engine for Lifecycle Integration Guided Tours Presentations and Recordings                                                                                                                IBM i V7R5 (MERLIN) Modernization Engine for Lifecycle Integration "GitHub" docs                                                                                                                                                                                       IBM i Power 10 Pages                                                                                                https://www.ibm.com/support/pages/ibm-power-systems-power10-servers     https://www.redbooks.ibm.com/redpieces/abstracts/redp5675.html                     https://builtonpower.com/power10-all-you-need-to-know/ - Courtesy of Torbjorn Appehl                  IBM i Performance Optimization PDF

----------------------------------------------------------------------------------------------------------------------------------------
 IBM i on Power Company Locations Map:
Courtesy of John Rockwell  
Credit to Jerry Ponnoth                                                                                                          https://tinyurl.com/wuj5n3kb      
                                                                                                                                                                                                                                                                                                                                   IBM i Roadmap 
 

 
                                                                              
----------------------------------------------------------------------------------------------------------------------------------------
 
IBM i Save Strategy Diagram


----------------------------------------------------------------------------------------------------------------------------------------
 
IBM i Network Security Checklist
Courtesy of Leonardo Villalobos Prieto
 
 
----------------------------------------------------------------------------------------------------------------------------------------
 
IBM Power System CPW Performance Data Comparison 
Courtesy of iTech Solutions - A Service Express Company 
 
  ----------------------------------------------------------------------------------------------------------------------------------------
 
LOG4J Investigation / Remediation. V7R1 - V7R5:
 
Courtesy of Matt Seeberger - "The Bearded Geek"
 
Courtesy of Scott Forstie - "IBM DB2 for i Business Architect"
 
IBM Power Systems HMC

----------------------------------------------------------------------------------------------------------------------------------------
 
SQL that displays the PTF Groups Installed vs PTF Groups Available.
Note: This will run in green screen STRSQL or ACS Run SQL Scripts.
          The CCSID of the user profile must be set to 37 on the green screen. 
Note2: This was run on a V7R2 partition but will also run on V7R3, V7R4, V7R5.
 
SQL 1:
with ilevel (iversion, irelease) as (
select os_version, os_release
from sysibmadm.env_sys_info
)
select Row_Number() over (Order by ptf_group_level_available - ptf_group_level_installed desc, ptf_group_id) as "Row #", p.*
from ilevel, systools.group_ptf_currency p
where ptf_group_release = 'R' concat iversion concat irelease concat '0'
order by "Row #" 
 
Result: Right click to open in a new window.

 
SQL 2:
Select Row_Number() over (ORDER BY PTF_GROUP_CURRENCY DESC, PTF_GROUP_ID ASC) as "Row #",
    PTF_GROUP_CURRENCY, PTF_GROUP_ID,
    PTF_GROUP_TITLE, PTF_GROUP_LEVEL_INSTALLED,
    PTF_GROUP_LEVEL_AVAILABLE,PTF_GROUP_LAST_UPDATED_BY_IBM,
    PTF_GROUP_RELEASE, PTF_GROUP_STATUS_ON_SYSTEM
  From SYSTOOLS.GROUP_PTF_CURRENCY 

Result:
Right click to open in a new window.
 

----------------------------------------------------------------------------------------------------------------------------------------
 
Retrieve "Processor Pool Info", "Partition Info" and "System Info" by running
this IBM i API program as follows from a command line:
Call QLZARCAPI.
The result will look like this (Right click to open in a new window):
 


                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              This can also be run using Access Client Solutions "Run SQL Scripts" and this as the input:                  CL: Call QLZARCAPI                                                                                                                           Click on the "Run" tab. The results will be displayed on the bottom panel of the "Run SQL Scripts" display.                                                                            
 
----------------------------------------------------------------------------------------------------------------------------------------