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 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
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"
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------
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
----------------------------------------------------------------------------------------------------------------------------------------
Nov 3, 2023
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------
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.
---------------------------------------------------------------------------------------------------------------------------------------
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.
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.
----------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment