Group PTF levels Was: JDBCR4 Exception in thread "main

But, if you've ever loaded on a group ptf to be applied later (like that
evenings IPL) and you have an issue that day IBM wants to know what group
PTF level you are at NOW. Not what you'll be at with the next IPL.
Of course there's the usual disclaimer by Larry that loading on a PTF for
apply later can cause you issues if you have to do an emergency IPL. True,
but that rarely happens so I'll take that gamble.

It's really quite easy to simply do
WRKPTFGRP PTFGRPLVL(*LATEST)
if I only want to see the highest one. Or
WRKPTFGRP PTFGRPLVL(*INSTALLED)
if I only want to see the ones that are applied and not the ones which
will go on at the next IPL.

Then there's always this instead

select PTF_GROUP_NAME as group, PTF_GROUP_LEVEL as level,
PTF_GROUP_STATUS, PTF_GROUP_TARGET_RELEASE as release,
PTF_GROUP_DESCRIPTION
from qsys2.GROUP_PTF_INFO
order by PTF_GROUP_NAME, PTF_GROUP_LEVEL desc;

/* For those unfortunates using a primitive like STRSQL without resizable
columns */

select varchar(PTF_GROUP_NAME, 7) as group, PTF_GROUP_LEVEL as level,
PTF_GROUP_STATUS as status, PTF_GROUP_TARGET_RELEASE as release,
PTF_GROUP_DESCRIPTION
from qsys2.GROUP_PTF_INFO
order by PTF_GROUP_NAME, PTF_GROUP_LEVEL desc;



Rob Berendt