This has been discussed previously. Google SQL0338. IBM got pickier about
your join statements.
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Oberholtzer
Sent: Monday, September 17, 2012 12:20 PM
To: Midrange Systems Technical Discussion
Subject: Re: Budgeting to replace V5R4
There's a little gem lost in most of the documentation and that is a
change that was made in DB/2 regarding outer joins. The only spot I
have seen customers have trouble with in a V5R4 to V7 upgrade is with
SQL statements that use certain kinds of joins. There are workarounds
but the best solution is to fix the SQL.
See the archives of Midrange-L for much more information as well as
IBM's web site, although good luck finding much out there.....
Chief Technical Architect
Agile Technology Architects
On 9/17/2012 10:20 AM, rob@xxxxxxxxx wrote:
Many of you are preparing budgets for next year. I've got no dog in thishttp://www-947.ibm.com/systems/support/i/planning/upgrade/suptschedule.html
fight, but you may want to consider adding upgrading from V5R4 to your
budget. End of service for V5R4 is end of September of 2013.
You can get an extension but IBM will REALLY, REALLY rake you over thehttp://www-03.ibm.com/systems/resources/systems_power_ibmi_lotus_releasesupp
coals financially for it. Besides, all that buys you is one year of delay
for a LOT of money.
I suggest you read the Memo to Users for both 6.1 and 7.1. Some items to
consider in your budgeting:
- Are you current with IBM software subscription?
- ANZOBJCVN. This may (almost guarantee WILL) affect some vendor
purchased software. If you're behind on your vendors versions of software
that are supported on 7.1 then there may be some serious costs including:
= Paying up back support
= Replacing the vendor if back support is too pricey or if they still
don't support 7.1, which has been out for 2.5 years now. We replaced a
few packages that we're dragging their feet on 6.1 versions when 6.1 first
came out. IBM gave them a year's notice on ANZOBJCVN prior to 6.1 and we
got tired of them milking maintenance for nothing.
= Training on the new version (or replacement) of your vendor software.
When we jumped from BPCS 405CD to LX 8.something we put everyone through
non software specific ERP training and then LX training. (Note: You can
get 405CD to work past V5R4 but it WILL require applying some BMRs.
- Hardware: Is all your hardware currently supported on something higher
There are some cards etc which may need to be replaced. Including models
otherwise supported on these releases:
- Actually doing your OS upgrades. Some of you contract that out versus
doing it in house. IBM or your BP may provide you a quote on that.
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept
1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108
6928N 400E Kendallville, IN 46755 http://www.dekko.com