Re: SQL Misbehaving

["Dare @ Work" <oludare@xxxxxxxxxxxxx>]

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