Tuesday, January 11, 2022

 
 Happy Thanksgiving everyone!
 
 

 
 
Welcome to the IBM i Reference Pages 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 multiple 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 add quality subject matter to this blog and 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.

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

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

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

 
 
 
August 2024.

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

Please enjoy these videos about the IBM "eseries / iseries". For those of us who have been on the box for awhile, you'll probably get a real kick out of these.
 
----------------------------------------------------------------------------------------------------------------------------------------
 
If you're new to IBM i, this is a good place to start.
or
Getting Started with IBM i (This is a bit dated but gives a good overview)

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

                                        Maybe the most informative document on this blog.                                             IBM i on Power - Performance FAQ.PDF    
Nov 3, 2023

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

IBM i Power 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         
----------------------------------------------------------------------------------------------------------------------------------------
 
 
Refer to the "IBM i Guided Tours" link on the "IBM i Extra's Page". Licensing Part 1 & 2. Courtesy of IBM and Carmelita Ruvalcaba. This is great material.     
 
 
 ---------------------------------------------------------------------------------------------------------------------------------------                   


 
 
 
Also listed on the IBM i Extra's Page.
 

 
IBM i V7R4 TR6 Enhancements Page                                                                                                  IBM i V7R4 TR7 Enhancements Page                                                                                               IBM i V7R4 TR8 Enhancements Page      
 
IBM i V7R5 SRC B90036A0 During IPL to Apply PTFs After Upgrade or New Install                   IBM i V7R5 TR1 Enhancements Page                                                                                                  IBM i V7R5 TR2 Enhancements Page   
                                                                                                                                                             IBM i V7R5 Adds Ordering Pgm Numbers & Features for IBM PowerHA SystemMirror 
 
 
---------------------------------------------------------------------------------------------------------------------------------------
 
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.                                                                            
 
----------------------------------------------------------------------------------------------------------------------------------------