| Author |
Message
|
| kash3338 |
 Posted: Wed Jan 22, 2020 11:11 pm Post subject: DB2 version 12 support for IIB v9 |
 |
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
Hi,
We are currently running IIB v9 and DB2 v11. There is a upgrade project for IIB v10 which is planned to start by next month. But there is a push for DB2 upgrade to v12 before the IIB upgrade as its a enterprise level upgrade and they are not able to wait until IIB upgrade is done.
We can see from System requirements that DBv12 is not supported by IIB v9 and this has been confirmed by IBM Labs over a PMR as well.
But the client is pushing to see what would be the impact if we go ahead and upgrade DB2 v12 first. What would be the problem in IIB v9 when we use DBv12? This would be running for few months until IIB upgrade is done.
We know that there wont be any kind of support provided in case of issues, but apart from that is there any other technical issue is we run IIB v9 along with DBv12?
OS is z/OS. |
|
| Back to top |
|
 |
| abhi_thri |
| Posted: Thu Jan 23, 2020 1:35 am Post subject: Re: DB2 version 12 support for IIB v9 |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
Location: UK
|
hi...
| kash3338 wrote: |
| But there is a push for DB2 upgrade to v12 before the IIB upgrade as its a enterprise level upgrade and they are not able to wait until IIB upgrade is done. |
If they are planning to upgrade the backend database at enterprise level surely they should be doing impact analysis on all the apps using the database? Try to see whether you could stand up a new IIB 10/11 instance and move just the flows which uses DB2.
| kash3338 wrote: |
| We know that there wont be any kind of support provided in case of issues, but apart from that is there any other technical issue is we run IIB v9 along with DBv12? |
The only way to find that out is by testing it, try connecting to DB2 v12 initally using existing DB2 drivers and see. What kind of database operations are you dealing with...just simple select/insert ones or more complex ones including XA coordination? Once you are able to connect to DB2 v12 you should test all the database scenarios used in your flows and see.
PS: We once had to connect one IIB 10 interface to an older unsupported Oracle database using older Datadirect drivers for few months |
|
| Back to top |
|
|
| kash3338 |
| Posted: Thu Jan 23, 2020 1:39 am Post subject: |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
Thanks for the inputs abhi_thri.
Actually we are running on FTM v3.0.x which runs on IIB v9. All our flows are completely dependent on DB. We have more than 200 Message Flows and two FTM applications running. That's a huge dependency on DB2. |
|
| Back to top |
|
|
| abhi_thri |
| Posted: Thu Jan 23, 2020 2:20 am Post subject: |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
Location: UK
|
| kash3338 wrote: |
| Actually we are running on FTM v3.0.x which runs on IIB v9. All our flows are completely dependent on DB. We have more than 200 Message Flows and two FTM applications running. That's a huge dependency on DB2. |
If you are dealing with finanical transactions surely do you really want to run the risk of unsupported iib/database issues in Prod? I think you are better off highlight this risk to the mgmt and getting them upgrade IIB as well.
DB2 v11 EOS date is in Sep 2020, will that give enough time to upgrade IIB, if not you could still get an extended Support agreement with IBM for sure |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jan 23, 2020 7:45 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kash3338 wrote: |
| Actually we are running on FTM v3.0.x which runs on IIB v9. |
Why are you upgrading the IIB that FTM runs on? We run FTM on it's own little world where the software lifecycles for the rest of the business don't apply. This allows us to go from FTM vn.n to FTM vn.n+1 using the IBM installer that comes with FTM and saves a ton of time with PMRs because they can't say it's an installation problem with FTM.
As to your direct problem, reach out to IBM. The advice you've been given is good advice but there's no guarantee the IBM-supplied FTM flows are not doing something odd and/or IBM will not support FTM on the configuration you're proposing.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Thu Jan 23, 2020 2:47 pm Post subject: Re: DB2 version 12 support for IIB v9 |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
| kash3338 wrote: |
Hi,
...We can see from System requirements that DBv12 is not supported by IIB v9 and this has been confirmed by IBM Labs over a PMR as well.
...
But the client is pushing to see what would be the impact if we go ahead and upgrade DB2 v12 first. What would be the problem in IIB v9 when we use DBv12? This would be running for few months until IIB upgrade is done.
... |
You are at risk that it may fail unexpectedly in production, even after app regression testing, and IBM would not provide support. For me, this is a compelling reason not to do it.
_________________
Glenn |
|
| Back to top |
|
|
| kash3338 |
| Posted: Thu Jan 23, 2020 11:02 pm Post subject: |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
| Vitor wrote: |
Why are you upgrading the IIB that FTM runs on? We run FTM on it's own little world where the software lifecycles for the rest of the business don't apply. This allows us to go from FTM vn.n to FTM vn.n+1 using the IBM installer that comes with FTM and saves a ton of time with PMRs because they can't say it's an installation problem with FTM.
|
We are not upgrading only IIB here. We are doing a complete stack refresh of FTM (including all related products like IIB, MQ, WTX and DB2). We are moving from FTM 3.0.x to 3.2.x as the EOS is in Q3 this year.
The only problem is, the EOS of both DB2 v11 and FTM v3.0.x clash on same date and the DB2 team is in a hurry to get that upgraded without waiting for FTM to be upgraded. Hence the query on what would go wrong if we take the risk for few months. |
|
| Back to top |
|
|
| kash3338 |
| Posted: Thu Jan 23, 2020 11:03 pm Post subject: Re: DB2 version 12 support for IIB v9 |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
| gbaddeley wrote: |
| You are at risk that it may fail unexpectedly in production, even after app regression testing, and IBM would not provide support. For me, this is a compelling reason not to do it. |
Thanks. That's what we feel too. But just wanted to check if there is a way we can still use it for few months and what could be the depth of impact. |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Fri Jan 24, 2020 5:44 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
There is an acronym that encompasses the concept of using unsupported software, namely: CLM - Career Limiting Move.
Does your management understand the risks of running unsupported software? Have auditors and management approved?
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| kash3338 |
| Posted: Sun Jan 26, 2020 8:49 pm Post subject: |
|
|
Shaman
Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India
|
| bruce2359 wrote: |
There is an acronym that encompasses the concept of using unsupported software, namely: CLM - Career Limiting Move.
Does your management understand the risks of running unsupported software? Have auditors and management approved? |
The FTM software is under extended support and they are being upgraded as their EOS by this Sep. DB2 v11 EOS is by Sep and hence the upgrade. |
|
| Back to top |
|
|
|
|
