Re: SQL Misbehaving

Group PTFs are for specific components. They are not on the same scheduie
as CUMs - short for CUMULATIVE.

If you go to <www.iseries.ibm.com/support>, you can find a link to
Preventive Service Planning. You can get more info there.

At 09:36 AM 3/20/02 -0500, you wrote:
>Thanks Rob,
>
>I'm planning a cum and group PTF load next month and I'm at V4R5M0. Could
>you remind me the difference between group PTF and Cum.  My recollection is
>that Cum is for the OS while group take care of the components that reside
>on the OS.
>
>Dare
>
>----- Original Message -----
>From: <rob@dekko.com>
>To: <midrange-l@midrange.com>
>Sent: Wednesday, March 20, 2002 9:29 AM
>Subject: Re: SQL Misbehaving
>
>
> >
> > 1)  The top cum is TL01100.  That one came out in the first third of 2001.
> > There is a good and bad.  It is good that you have applied a cum.  Some
> > people have upgraded their OS and never applied a cum.  Our first AS/400
> > only support 1 file in RPG.  I thought that was taking modular programming
> > to the extreme, but it turns out a ptf was needed.  The next part may
>sound
> > too much like IBM and please forgive me.  But, can you afford the time to
> > get the latest cum and apply that?  For the latest cum info:
> >
>http://www-912.ibm.com/s_dir/sline003.NSF/2d3aff1c6b4d6ce086256453000d971e/1
>eba4d1d2f39c3f886256a57004d6f69?OpenDocument
> > The latest cumulative package for Version 5 Release 1.0 is: C2071510
> >
> > 2)  And, since you are at V5R1M0, what appears when you type in DSPDTAARA
> > SF99501?  If you get the message that the data area was not found then
> > you've never put on a database group ptf.
> > To check out group ptf's:
> >
>http://www-912.ibm.com/s_dir/sline003.NSF/GroupPTFs?OpenView&view=GroupPTFs
> > At a minimum I would apply:
> > SF99501 - 510 DATABASE
> > SF99097 - 510 HIPER
> > SF99078 - 510 Backup Recovery Solutions
> > SF99069 - 510 Java
> >
> > I've did a DSPOBJD of all objects/libs into a file.  And the following SQL
> > works fine:
> > SELECT ODOBNM, ODOBTP, ODOBAT, ODOBTX, ODCTIM, ODOBOW, ODCRTU,
> > ODUCNT
> > FROM routines/dskdtl
> > WHERE ODUCNT >0 and odobnm like 'Q%'
> >
> > If you can think how I may be of more help, let me know.
> >
> > Rob Berendt
> > --
> > "They that can give up essential liberty to obtain a little temporary
> > safety deserve neither liberty nor safety."
> > Benjamin Franklin
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
>list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > 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@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.