× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Brian:

I do not see SF99701 "DB2 for IBM i" listed ...

Mark S, Waterbury

> On 3/7/2016 12:12 PM, Brian wrote:
Thanks to both of you guys. I sent reply on first one just as this rolled in :-)

Query results for both are below. Not sure if this means I have what I need or not though.

SELECT cast(left(PTF_GROUP_NAME, 7) as char(7)) as group, cast (left(PTF_GROUP_DESCRIPTION,15) as char(15)) as title, PTF_GROUP_LEVEL, PTF_GROUP_TARGET_RELEASE, PTF_GROUP_STATUS FROM qsys2.group_ptf_info where ptf_group_description = 'DB2 FOR IBM I'

GROUP TITLE PTF_GROUP_LEVEL PTF_GROUP_TARGET_REL PTF_GROUP_STAT
EASE
SF99145 PERFORMANCE TOO 9 V7R1M0 INSTALLED
SF99367 TCP/IP PTF 9 V7R1M0 INSTALLED
SF99368 IBM HTTP SERVER 36 V7R1M0 INSTALLED
SF99369 IBM I INTEGRATI 16 V7R1M0 INSTALLED
SF99380 WEBSPHERE APP S 14 V7R1M0 UNKNOWN
SF99381 WEBSPHERE APP S 13 V7R1M0 UNKNOWN
SF99572 JAVA 22 V7R1M0 INSTALLED
SF99617 DB2 WEB QUERY F 6 V7R1M0 INSTALLED
SF99627 7.1 ELECTRONIC 11 V7R1M0 INSTALLED
SF99637 DB2 WEB QUERY F 9 V7R1M0 INSTALLED
SF99705 HARDWARE AND RE 22 V7R1M0 INSTALLED
SF99706 HIGH AVAILABILI 8 V7R1M0 INSTALLED
SF99707 TECHNOLOGY REFR 11 V7R1M0 INSTALLED
SF99708 GROUP SECURITY 47 V7R1M0 INSTALLED
SF99709 GROUP HIPER 152 V7R1M0 INSTALLED
SF99710 CUMULATIVE PTF 15,142 V7R1M0 NOT INSTALLED
SF99711 ALL PTF GROUPS 3 V7R1M0 UNKNOWN

-----
SELECT * FROM SYSTOOLS.GROUP_PTF_CURRENCY
ORDER BY PTF_GROUP_LEVEL_AVAILABLE - PTF_GROUP_LEVEL_INSTALLED DESC

PTF_GROUP_CURRENCY PTF_GROUP_ID PTF_GROUP_TITLE

UPDATE AVAILABLE SF99709 710 Group Hiper
UPDATE AVAILABLE SF99708 710 Group Security
UPDATE AVAILABLE SF99368 710 IBM HTTP Server for i
UPDATE AVAILABLE SF99705 710 Hardware and Related PTFs
UPDATE AVAILABLE SF99572 710 Java
UPDATE AVAILABLE SF99706 710 High Availability for IBM i
INSTALLED LEVEL IS CURRENT SF99145 710 Performance Tools
INSTALLED LEVEL IS CURRENT SF99367 710 TCP/IP PTF
INSTALLED LEVEL IS CURRENT SF99369 710 IBM i integration with BladeCenter and System x
INSTALLED LEVEL IS CURRENT SF99617 710 DB2 Web Query for IBM i V1.1.1
INSTALLED LEVEL IS CURRENT SF99627 710 7.1 Electronic Services Group PTF
INSTALLED LEVEL IS CURRENT SF99637 710 DB2 Web Query for IBM i V1.1.2
INSTALLED LEVEL IS CURRENT SF99707 710 Technology Refresh

On 3/7/2016 12:06 PM, Rob Berendt wrote:
SELECT cast(left(PTF_GROUP_NAME, 7) as char(7)) as group,
cast (left(PTF_GROUP_DESCRIPTION,15) as char(15)) as title,
PTF_GROUP_LEVEL,
PTF_GROUP_TARGET_RELEASE, PTF_GROUP_STATUS
FROM qsys2.group_ptf_info
where ptf_group_description = 'DB2 FOR IBM I'

And you can compare this to what's available at IBM with:
SELECT * FROM SYSTOOLS.GROUP_PTF_CURRENCY


Rob Berendt



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.