Re: Budgeting to replace V5R4

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Rob,

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

Jim Oberholtzer
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 this
> 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.
> http://www-947.ibm.com/systems/support/i/planning/upgrade/suptschedule.html
> You can get an extension but IBM will REALLY, REALLY rake you over the
> 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.
> - Domino:
> http://www-03.ibm.com/systems/resources/systems_power_ibmi_lotus_releasesupport.pdf
> - Hardware:  Is all your hardware currently supported on something higher
> than V5R4?
> http://www-947.ibm.com/systems/support/i/planning/upgrade/osmapping.html
> http://www-01.ibm.com/support/docview.wss?uid=ssm1platformibmi
> There are some cards etc which may need to be replaced.  Including models
> otherwise supported on these releases:
> http://www-947.ibm.com/systems/support/i/planning/upgrade/futurehdwr.html
> - 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.
>
>
>
>
> Rob Berendt
> -- 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