ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB2 version 12 support for IIB v9

Post new topic  Reply to topic
 DB2 version 12 support for IIB v9 « View previous topic :: View next topic » 
Author Message
kash3338
PostPosted: Wed Jan 22, 2020 11:11 pm    Post subject: DB2 version 12 support for IIB v9 Reply with quote

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
View user's profile Send private message Send e-mail
abhi_thri
PostPosted: Thu Jan 23, 2020 1:35 am    Post subject: Re: DB2 version 12 support for IIB v9 Reply with quote

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
View user's profile Send private message
kash3338
PostPosted: Thu Jan 23, 2020 1:39 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
abhi_thri
PostPosted: Thu Jan 23, 2020 2:20 am    Post subject: Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Thu Jan 23, 2020 7:45 am    Post subject: Reply with quote

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
View user's profile Send private message
gbaddeley
PostPosted: Thu Jan 23, 2020 2:47 pm    Post subject: Re: DB2 version 12 support for IIB v9 Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2492
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
View user's profile Send private message
kash3338
PostPosted: Thu Jan 23, 2020 11:02 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
kash3338
PostPosted: Thu Jan 23, 2020 11:03 pm    Post subject: Re: DB2 version 12 support for IIB v9 Reply with quote

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
View user's profile Send private message Send e-mail
bruce2359
PostPosted: Fri Jan 24, 2020 5:44 am    Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9394
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
View user's profile Send private message
kash3338
PostPosted: Sun Jan 26, 2020 8:49 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB2 version 12 support for IIB v9
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.