Tuesday, January 11, 2022

 Wishing you good health and prosperity in 2022.
 Stay safe, be well.
 
----------------------------------------------------------------------------------------------------------------------------------------
 
Welcome to my IBM i Reference. 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.

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. 

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

Thought for the day:

"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."
 
----------------------------------------------------------------------------------------------------------------------------------------
  
IBM Announcements 
 
 
 
 
 
IBM i V7R4 TR6 Page

IBM i V7R5 Overview Page
 
IBM i V7R5 (MERLIN) Modernization Engine for Lifecycle Integration Overview - YouTube Video
 
IBM i V7R5 (MERLIN) Modernization Engine for Lifecycle Integration Overview Page
                                                                                                                                                              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
Preparing Customer Firewalls and proxies for infrastructure changes on IBM Electronic Fix Distribution / IBM Fix Central System                                                                                    
----------------------------------------------------------------------------------------------------------------------------------------
 IBM i on Power Company Locations Map:
 
Courtesy of John Rockwell  
Credit to Jerry Ponnoth                                                                                                          https://tinyurl.com/wuj5n3kb      
                                                                                                                                                                                                                                                                                                                                   IBM i Roadmap 
 

                                                                              
 ---------------------------------------------------------------------------------------------------------------------------------------
 
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

----------------------------------------------------------------------------------------------------------------------------------------
   
By the way:  
 

 
 
 
 

IBM Offers Free Security Check for IBM i.    
    ITJungle Article     
 
----------------------------------------------------------------------------------------------------------------------------------------

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.                                                                            
 
----------------------------------------------------------------------------------------------------------------------------------------