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