RE: How to compare PTFs on four partitions

Scott Forstie, from IBM, spoke at our user group (OCEAN) Tuesday night and covered the SQL service for PTF checking along with many other DB enhancements.

There are a lot of great stuff going on in database which is fantastic to see. Can't wait till we get to 7.2 (still on 6.1 for a bit) so I can use some of it.

Check here for more info: http://www-03.ibm.com/systems/power/software/i/db2/index.html

Roger HarmanCOMMON Certified Application Developer – ILE RPG on IBM i on PowerOCEAN User Group – Vice-President, Membership (2014)

Date: Tue, 14 Oct 2014 16:49:47 -0400
From: bdietz400@xxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Subject: Re: How to compare PTFs on four partitions

and if on V7.2 you can do this from the web based navigator interface...
http://ibmsystemsmag.blogs.com/i_can/2014/04/ibm-i-72-systems-management-improvements.html

• PTF support has been added to Navigator – you can view the PTFs and
PTF groups that are installed on your partition; you can install, remove
and clean up PTFs from the GUI as well. And as the announcement stated,
you can now do the compare and update of PTFs via the Web console.

With the latest DB2 ptfs for 7.1 and 7.2 there is a sql service you can
use to check your group ptfs against IBMs list.

http://www.mcpressonline.com/ibm-i-os/400-i5/os/step-right-up-and-hear-about-db2-and-tr9.html

SYSTOOLS/GROUP_PTF_CURRENCY

SF99702 Level 3 & SF99701 Level 32
-




Frigyes Szepesi wrote on 10/14/2014 3:59 PM:

Hi Charles,

Thank you for the useful hint, it works very well!




On Mon, 13 Oct 2014 11:12:24 -0400, Charles Wilt
<charles.wilt@xxxxxxxxx> wrote:

iNav has this functionality built in.

Right click a system, select Fixes --> Compare and update...to start the
wizard.

Charles


On Mon, Oct 13, 2014 at 11:05 AM, Frigyes Szepesi <
frigyes.szepesi@xxxxxxxxxx> wrote:

Hi to the Gurus,

I have a simple question: how to compare PTFs on four partitions of
two servers? I did a DSPPTF to outfiles, queried them to have the
LICPGM and the PTF fields only. All I need to know which partition
misses what PTFs. I tried CMPF on the green screen, it does not work
on multiple files/members. I downloaded the files to my PC, tried FC
command on command prompt, it tells me the files are too different.
I tried to use Notepad++ with the compare plugin/DLL, it works only on
two files. I would really appreciate any good ideas.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.