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