Db2 12 and Db2 Connect [OT]

Philip Sevetson

Db2 12 and Db2 Connect [OT]
Are you two playing the Question Game, here?
-phil (sevetson)

From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Sunday, April 28, 2019 7:12 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

This would be facilitated via currentPackageSet. Is this possible via a gateway?
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]>
Sent: Sunday, April 28, 2019 4:17 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I believe IBM’s recommendation is to set up multiple collections with the CLI packages… one for each supported function level. You can then set the default by changing the collection you are using. This works with or without a gateway, no?

From: Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Sunday, April 28, 2019 7:48 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I’m assuming you are using the NULLID packages? If so, then this solution works for a homogenous application environment only. Yes? Of course, you can also set up all the other applications to use a lower application level if needed. Unless, of course, they also go through a gateway.
Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, April 25, 2019 3:38 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

So… an update on this for those interested. We applied the fix for PH08482 (which is still warm from being baked). With VERY current versions of the client / JDBC driver we are able to connect to higher function levels without setting the ClientApplcompat. With this APAR applied it will default to the APPLCOMPAT of the client packages you are using. This seems so very common sensical that it should have always been that way ��.

This has the side effect of allowing you to continue using a Db2 Connect gateway server as long as you can take the APPLCOMPAT value from the client packages.

Many thanks Jørn for pointing me in the right direction.

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 4:25 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Cc: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

Thanks for the APAR. I'm reading it now.

When I try to run the SET CURRENT APPLICATION COMPATIBILITY in the CLP I get the -30025. Client packages are bound V12R1M503.

On Apr 8, 2019 2:29 PM, Jørn Thyssen <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi David,

SET CURRENT APPLICATION COMPATIBILITY

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/sqlref/src/tpc/db2z_sql_setcurrentapplicationcompatibility.html

Note that APAR PH08482 address the situation where a DDF connection is rejected if clientApplCompat at the client side does not match the APPLCOMPAT of your Db2 connect packages.

In Reply to David Simpson:
On a related note, any wisdom on how to set clientApplcompat for CLP sessions that do NOT use a gateway?

On Apr 8, 2019 1:43 PM, Mohammad Khan wrote:
Moreover, it hardly sounds like an “Aha” moment … more like an “Oh oh” moment. May be IBM can spend less time on renaming things and more on listening to users’ needs.
Khalid

From: Daniel L Luksetich
Sent: Monday, April 08, 2019 1:02 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

It’s not what other database offer, it’s what IBM is taking away from what they offered. It’s not my complaint. I’ve encouraged the customer to go direct to Db2. However, they disagree with me and it is not in the customer’s plans. I’ll see if I can make the mod to the request, but I am NOT a customer and have been told several times that I have very very little influence as to enhancements. I think I might have exaggerated that claim. I believe I meant to say next to no influence. Sorry, it must be a Monday.

Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: Jørn Thyssen mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 12:48 PM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect


Hi Dan,

I suggest you add that concern to the Aha Idea I posted earlier in this thread.



Note that you might not be stuck on FL500 forever; you might just not be able to control on an application/connection level which APPLCOMPAT you get.



BTW, out of curiosity what other databases have gateway or proxy support?

In Reply to Daniel Luksetich:
That’s one issue I guess, but I suspect most people get an enterprise license.



The other issue is when people concentrate connections through a gateway to limit IP addresses that connect to Db2. For example one of my customers has a firewall in place that extremely limits the IP addresses that can connect to Db2. There are hundreds of clients, but those clients can’t get to Db2. They have to go through the gateway. Now, we asked that the gateway be eliminated, but they do not want to open up the firewall to hundreds of IP addresses. What’s the future hold for us then? Well, we will be stuck in perpetual V12R1M500. That’s it. The customer is fine with it as their primary goal is to eliminate Db2. This actually helps their cause.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: David Simpson
Sent: Monday, April 8, 2019 10:51 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Is there not still the licensing issue? The normal Db2 client will not connect directly to z/OS data sources.



From: Jørn Thyssen <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> >
Sent: Monday, April 8, 2019 8:20 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Sorry, RFE have been replaced by Aha ideas. Here's the correct link for the request for enhancement: https://ibmanalytics.ideas.aha.io/ideas/DB2CON-I-1

In Reply to Jørn Thyssen:

Hi David,



Also note that IBM have recommended direct connections over gateways for many years.
There are very few technical reasons for using a gateway -- it just adds cost (hw, sw, maintenance, operations) and latency.

There is an RFE open for adding gateway support for APPLCOMPAT: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=126019 &CR_ID=126019

In Reply to David Simpson:

I apologize if this has been discussed before.

Does anyone know of a concise, understandable write-up on configuring Db2 Connect for connections to Db2 12 at APPLCOMPAT levels higher than V12R1M500? Specifically when using gateway servers?

I know you need to be at very current levels of the client / gateway / JDBC driver. I have Data Studio working going directly to Db2 without a gateway, but no luck with non-JDBC connections or even JDBC connections via a gateway. The documentation I have found so far is... well it's written by IBM.

Any help would be appreciated.

_____________________________________________________________________________
David Simpson | Vice President | Themis Education
IBM Data Champion (2013-2018) | IBM Gold Consultant
PO Box 2578 * Westfield NJ * 07091 | phone 908-233-8900 | [login to unmask email]<mailto:[login to unmask email] <mailto:[login to unmask email]%3e><mailto:[login to unmask email]%3e%3e%3cmailto:[login to unmask email]%3e%3e%3e> >
For more information about Themis, visit www.themisinc.com http://www.themisinc.com http://www.themisinc.com http://www.themisinc.com http://www.themisinc.com
[cid:[login to unmask email] https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link&screen_name=ThemisTraining&tw_p=followbutton https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons&region=follow_link&screen_name=ThemisTraining&tw_p=followbutton &screen_name=ThemisTraining&tw_p=followbutton
[LogoNew][cid:[login to unmask email]





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com

2019 IBM Champion.

Views are personal.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com

2019 IBM Champion.

Views are personal.



-----End Original Message-----



-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> • W: www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at
(312) 653-6000 in Illinois; (800) 447-7828 in Montana;
(800)835-8699 in New Mexico; (918)560-3500 in Oklahoma;
or (972)766-6900 in Texas.

-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Raymond Bell

Db2 12 and Db2 Connect [OT]
(in response to Philip Sevetson)
What game is that?

(see what I did there?)

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 30 April 2019 13:00
To: '[login to unmask email]'
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect [OT]


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

Are you two playing the Question Game, here?
-phil (sevetson)

From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Sunday, April 28, 2019 7:12 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

This would be facilitated via currentPackageSet. Is this possible via a gateway?
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]>
Sent: Sunday, April 28, 2019 4:17 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I believe IBM’s recommendation is to set up multiple collections with the CLI packages… one for each supported function level. You can then set the default by changing the collection you are using. This works with or without a gateway, no?

From: Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Sunday, April 28, 2019 7:48 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I’m assuming you are using the NULLID packages? If so, then this solution works for a homogenous application environment only. Yes? Of course, you can also set up all the other applications to use a lower application level if needed. Unless, of course, they also go through a gateway.
Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, April 25, 2019 3:38 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

So… an update on this for those interested. We applied the fix for PH08482 (which is still warm from being baked). With VERY current versions of the client / JDBC driver we are able to connect to higher function levels without setting the ClientApplcompat. With this APAR applied it will default to the APPLCOMPAT of the client packages you are using. This seems so very common sensical that it should have always been that way ��.

This has the side effect of allowing you to continue using a Db2 Connect gateway server as long as you can take the APPLCOMPAT value from the client packages.

Many thanks Jørn for pointing me in the right direction.

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 4:25 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Cc: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

Thanks for the APAR. I'm reading it now.

When I try to run the SET CURRENT APPLICATION COMPATIBILITY in the CLP I get the -30025. Client packages are bound V12R1M503.

On Apr 8, 2019 2:29 PM, Jørn Thyssen <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi David,

SET CURRENT APPLICATION COMPATIBILITY

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/sqlref/src/tpc/db2z_sql_setcurrentapplicationcompatibility.html

Note that APAR PH08482 address the situation where a DDF connection is rejected if clientApplCompat at the client side does not match the APPLCOMPAT of your Db2 connect packages.

In Reply to David Simpson:
On a related note, any wisdom on how to set clientApplcompat for CLP sessions that do NOT use a gateway?

On Apr 8, 2019 1:43 PM, Mohammad Khan wrote:
Moreover, it hardly sounds like an “Aha” moment … more like an “Oh oh” moment. May be IBM can spend less time on renaming things and more on listening to users’ needs.
Khalid

From: Daniel L Luksetich
Sent: Monday, April 08, 2019 1:02 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

It’s not what other database offer, it’s what IBM is taking away from what they offered. It’s not my complaint. I’ve encouraged the customer to go direct to Db2. However, they disagree with me and it is not in the customer’s plans. I’ll see if I can make the mod to the request, but I am NOT a customer and have been told several times that I have very very little influence as to enhancements. I think I might have exaggerated that claim. I believe I meant to say next to no influence. Sorry, it must be a Monday.

Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: Jørn Thyssen mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 12:48 PM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect


Hi Dan,

I suggest you add that concern to the Aha Idea I posted earlier in this thread.



Note that you might not be stuck on FL500 forever; you might just not be able to control on an application/connection level which APPLCOMPAT you get.



BTW, out of curiosity what other databases have gateway or proxy support?

In Reply to Daniel Luksetich:
That’s one issue I guess, but I suspect most people get an enterprise license.



The other issue is when people concentrate connections through a gateway to limit IP addresses that connect to Db2. For example one of my customers has a firewall in place that extremely limits the IP addresses that can connect to Db2. There are hundreds of clients, but those clients can’t get to Db2. They have to go through the gateway. Now, we asked that the gateway be eliminated, but they do not want to open up the firewall to hundreds of IP addresses. What’s the future hold for us then? Well, we will be stuck in perpetual V12R1M500. That’s it. The customer is fine with it as their primary goal is to eliminate Db2. This actually helps their cause.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: David Simpson
Sent: Monday, April 8, 2019 10:51 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Is there not still the licensing issue? The normal Db2 client will not connect directly to z/OS data sources.



From: Jørn Thyssen <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> >
Sent: Monday, April 8, 2019 8:20 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Sorry, RFE have been replaced by Aha ideas. Here's the correct link for the request for enhancement: https://ibmanalytics.ideas.aha.io/ideas/DB2CON-I-1

In Reply to Jørn Thyssen:

Hi David,



Also note that IBM have recommended direct connections over gateways for many years.
There are very few technical reasons for using a gateway -- it just adds cost (hw, sw, maintenance, operations) and latency.

There is an RFE open for adding gateway support for APPLCOMPAT: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=126019 &CR_ID=126019

In Reply to David Simpson:

I apologize if this has been discussed before.

Does anyone know of a concise, understandable write-up on configuring Db2 Connect for connections to Db2 12 at APPLCOMPAT levels higher than V12R1M500? Specifically when using gateway servers?

I know you need to be at very current levels of the client / gateway / JDBC driver. I have Data Studio working going directly to Db2 without a gateway, but no luck with non-JDBC connections or even JDBC connections via a gateway. The documentation I have found so far is... well it's written by IBM.

Any help would be appreciated.

_____________________________________________________________________________
David Simpson | Vice President | Themis Education
IBM Data Champion (2013-2018) | IBM Gold Consultant
PO Box 2578 * Westfield NJ * 07091 | phone 908-233-8900 | [login to unmask email]<mailto:[login to unmask email] <mailto:[login to unmask email]%3e><mailto:[login to unmask email]%3e%3e%3cmailto:[login to unmask email]%3e%3e%3e> >
For more information about Themis, visit www.themisinc.com http://www.themisinc.com http://www.themisinc.com http://www.themisinc.com http://www.themisinc.com
[cid:[login to unmask email] https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link&screen_name=ThemisTraining&tw_p=followbutton https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons&region=follow_link&screen_name=ThemisTraining&tw_p=followbutton &screen_name=ThemisTraining&tw_p=followbutton
[LogoNew][cid:[login to unmask email]





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com

2019 IBM Champion.

Views are personal.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com

2019 IBM Champion.

Views are personal.



-----End Original Message-----



-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> • W: www.rocketsoftware.com http://www.rocketsoftware.com http://www.rocketsoftware.com

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at
(312) 653-6000 in Illinois; (800) 447-7828 in Montana;
(800)835-8699 in New Mexico; (918)560-3500 in Oklahoma;
or (972)766-6900 in Texas.

-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (RBS or us) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you understand that the content of your message may be monitored.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com

Marcus Davage

Db2 12 and Db2 Connect [OT]
(in response to Raymond Bell)
That’s not fair – did you just have two goes?

Regards,
Marcus Davage
Lead Product Developer
AMI-DevOps for Db2 – SQL Performance
Direct

+44 118 921 8517

[cid:[login to unmask email]



Mobile

+44 7840 023 560



Email

[login to unmask email]<mailto:[login to unmask email]>





From: Bell, Raymond (Hosting Services, Technology) <[login to unmask email]>
Sent: 30 April 2019 13:09
To: '[login to unmask email]' <[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: Db2 12 and Db2 Connect [OT]

What game is that?

(see what I did there?)

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 30 April 2019 13:00
To: '[login to unmask email]'
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect [OT]


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************
Are you two playing the Question Game, here?
-phil (sevetson)

From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Sunday, April 28, 2019 7:12 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

This would be facilitated via currentPackageSet. Is this possible via a gateway?
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Sunday, April 28, 2019 4:17 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I believe IBM’s recommendation is to set up multiple collections with the CLI packages… one for each supported function level. You can then set the default by changing the collection you are using. This works with or without a gateway, no?

From: Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Sunday, April 28, 2019 7:48 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I’m assuming you are using the NULLID packages? If so, then this solution works for a homogenous application environment only. Yes? Of course, you can also set up all the other applications to use a lower application level if needed. Unless, of course, they also go through a gateway.
Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, April 25, 2019 3:38 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

So… an update on this for those interested. We applied the fix for PH08482 (which is still warm from being baked). With VERY current versions of the client / JDBC driver we are able to connect to higher function levels without setting the ClientApplcompat. With this APAR applied it will default to the APPLCOMPAT of the client packages you are using. This seems so very common sensical that it should have always been that way ��.

This has the side effect of allowing you to continue using a Db2 Connect gateway server as long as you can take the APPLCOMPAT value from the client packages.

Many thanks Jørn for pointing me in the right direction.

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 4:25 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Cc: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

Thanks for the APAR. I'm reading it now.

When I try to run the SET CURRENT APPLICATION COMPATIBILITY in the CLP I get the -30025. Client packages are bound V12R1M503.

On Apr 8, 2019 2:29 PM, Jørn Thyssen <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi David,

SET CURRENT APPLICATION COMPATIBILITY

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/sqlref/src/tpc/db2z_sql_setcurrentapplicationcompatibility.html https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_en_SSEPEK-5F12.0.0_sqlref_src_tpc_db2z-5Fsql-5Fsetcurrentapplicationcompatibility.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=oIpzH2JsGen_mAZ0o7i_-9VQFVVoSR-3pe2SRoWsrbk&e=

Note that APAR PH08482 address the situation where a DDF connection is rejected if clientApplCompat at the client side does not match the APPLCOMPAT of your Db2 connect packages.

In Reply to David Simpson:
On a related note, any wisdom on how to set clientApplcompat for CLP sessions that do NOT use a gateway?

On Apr 8, 2019 1:43 PM, Mohammad Khan wrote:
Moreover, it hardly sounds like an “Aha” moment … more like an “Oh oh” moment. May be IBM can spend less time on renaming things and more on listening to users’ needs.
Khalid

From: Daniel L Luksetich
Sent: Monday, April 08, 2019 1:02 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

It’s not what other database offer, it’s what IBM is taking away from what they offered. It’s not my complaint. I’ve encouraged the customer to go direct to Db2. However, they disagree with me and it is not in the customer’s plans. I’ll see if I can make the mod to the request, but I am NOT a customer and have been told several times that I have very very little influence as to enhancements. I think I might have exaggerated that claim. I believe I meant to say next to no influence. Sorry, it must be a Monday.

Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: Jørn Thyssen mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 12:48 PM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect


Hi Dan,

I suggest you add that concern to the Aha Idea I posted earlier in this thread.



Note that you might not be stuck on FL500 forever; you might just not be able to control on an application/connection level which APPLCOMPAT you get.



BTW, out of curiosity what other databases have gateway or proxy support?

In Reply to Daniel Luksetich:
That’s one issue I guess, but I suspect most people get an enterprise license.



The other issue is when people concentrate connections through a gateway to limit IP addresses that connect to Db2. For example one of my customers has a firewall in place that extremely limits the IP addresses that can connect to Db2. There are hundreds of clients, but those clients can’t get to Db2. They have to go through the gateway. Now, we asked that the gateway be eliminated, but they do not want to open up the firewall to hundreds of IP addresses. What’s the future hold for us then? Well, we will be stuck in perpetual V12R1M500. That’s it. The customer is fine with it as their primary goal is to eliminate Db2. This actually helps their cause.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: David Simpson
Sent: Monday, April 8, 2019 10:51 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Is there not still the licensing issue? The normal Db2 client will not connect directly to z/OS data sources.



From: Jørn Thyssen <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> >
Sent: Monday, April 8, 2019 8:20 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Sorry, RFE have been replaced by Aha ideas. Here's the correct link for the request for enhancement: https://ibmanalytics.ideas.aha.io/ideas/DB2CON-I-1 https://urldefense.proofpoint.com/v2/url?u=https-3A__ibmanalytics.ideas.aha.io_ideas_DB2CON-2DI-2D1&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=cAn4aeCRUBbc6WdCEIbihKonRVCElkUuo6zCRT83R4w&e=

In Reply to Jørn Thyssen:

Hi David,



Also note that IBM have recommended direct connections over gateways for many years.
There are very few technical reasons for using a gateway -- it just adds cost (hw, sw, maintenance, operations) and latency.

There is an RFE open for adding gateway support for APPLCOMPAT: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_rfe_execute-3Fuse-5Fcase-3DviewRfe&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=yAvwJhXlxsC14tk_OOhCXadIbKHJI1fQlUF90NbZ0uY&e= https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=126019 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_rfe_execute-3Fuse-5Fcase-3DviewRfe-26CR-5FID-3D126019&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=5KmArziOIFZMwXVxfqX_JsssEN192m76In4C4A5C25o&e= &CR_ID=126019

In Reply to David Simpson:

I apologize if this has been discussed before.

Does anyone know of a concise, understandable write-up on configuring Db2 Connect for connections to Db2 12 at APPLCOMPAT levels higher than V12R1M500? Specifically when using gateway servers?

I know you need to be at very current levels of the client / gateway / JDBC driver. I have Data Studio working going directly to Db2 without a gateway, but no luck with non-JDBC connections or even JDBC connections via a gateway. The documentation I have found so far is... well it's written by IBM.

Any help would be appreciated.

_____________________________________________________________________________
David Simpson | Vice President | Themis Education
IBM Data Champion (2013-2018) | IBM Gold Consultant
PO Box 2578 * Westfield NJ * 07091 | phone 908-233-8900 | [login to unmask email]<mailto:[login to unmask email] <mailto:[login to unmask email]%3e><mailto:[login to unmask email]%3e%3e%3cmailto:[login to unmask email]%3e%3e%3e> >
For more information about Themis, visit www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e= http://www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e= http://www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e= http://www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e=
[cid:[login to unmask email] https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_intent_follow-3Foriginal-5Freferer-3Dhttps-253A-252F-252Fabout.twitter.com-252Fresources-252Fbuttons-25C2-25AEion-3Dfollow-5Flink&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=Us47rg8XbhvZejTM5KZVzfbI6arFv4e5j-bGFLNAkX0&e= https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link&screen_name=ThemisTraining&tw_p=followbutton https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_intent_follow-3Foriginal-5Freferer-3Dhttps-253A-252F-252Fabout.twitter.com-252Fresources-252Fbuttons-26region-3Dfollow-5Flink-26screen-5Fname-3DThemisTraining-26tw-5Fp-3Dfollowbutton&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=mDlGynyTwARNREd50jxunAfx0py15k-OsPctjv233QU&e= &screen_name=ThemisTraining&tw_p=followbutton
[LogoNew][cid:[login to unmask email]





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.



-----End Original Message-----



-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at
(312) 653-6000 in Illinois; (800) 447-7828 in Montana;
(800)835-8699 in New Mexico; (918)560-3500 in Oklahoma;
or (972)766-6900 in Texas.

-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 250 Bishopsgate, London EC2M 4AA. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (RBS or us) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you understand that the content of your message may be monitored.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


Visit our website at www.rbs.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rbs.com_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=DCcLh05G8AS-g7R_Cs-0tpGuSHaD-BnjffPi1owa7fM&e=
-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image002.png (12.9k)

Philip Sevetson

Db2 12 and Db2 Connect [OT]
(in response to Marcus Davage)
Statement embedded in a question. Default!

From: Davage, Marcus [mailto:[login to unmask email]
Sent: Thursday, May 02, 2019 11:28 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect [OT]

That’s not fair – did you just have two goes?

Regards,
Marcus Davage
Lead Product Developer
AMI-DevOps for Db2 – SQL Performance
Direct

+44 118 921 8517

[cid:[login to unmask email]



Mobile

+44 7840 023 560



Email

[login to unmask email]<mailto:[login to unmask email]>





From: Bell, Raymond (Hosting Services, Technology) <[login to unmask email]>
Sent: 30 April 2019 13:09
To: '[login to unmask email]' <[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: Db2 12 and Db2 Connect [OT]

What game is that?

(see what I did there?)

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 30 April 2019 13:00
To: '[login to unmask email]'
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect [OT]


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************
Are you two playing the Question Game, here?
-phil (sevetson)

From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Sunday, April 28, 2019 7:12 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

This would be facilitated via currentPackageSet. Is this possible via a gateway?
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Sunday, April 28, 2019 4:17 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I believe IBM’s recommendation is to set up multiple collections with the CLI packages… one for each supported function level. You can then set the default by changing the collection you are using. This works with or without a gateway, no?

From: Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Sunday, April 28, 2019 7:48 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I’m assuming you are using the NULLID packages? If so, then this solution works for a homogenous application environment only. Yes? Of course, you can also set up all the other applications to use a lower application level if needed. Unless, of course, they also go through a gateway.
Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, April 25, 2019 3:38 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

So… an update on this for those interested. We applied the fix for PH08482 (which is still warm from being baked). With VERY current versions of the client / JDBC driver we are able to connect to higher function levels without setting the ClientApplcompat. With this APAR applied it will default to the APPLCOMPAT of the client packages you are using. This seems so very common sensical that it should have always been that way ��.

This has the side effect of allowing you to continue using a Db2 Connect gateway server as long as you can take the APPLCOMPAT value from the client packages.

Many thanks Jørn for pointing me in the right direction.

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 4:25 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Cc: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

Thanks for the APAR. I'm reading it now.

When I try to run the SET CURRENT APPLICATION COMPATIBILITY in the CLP I get the -30025. Client packages are bound V12R1M503.

On Apr 8, 2019 2:29 PM, Jørn Thyssen <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi David,

SET CURRENT APPLICATION COMPATIBILITY

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/sqlref/src/tpc/db2z_sql_setcurrentapplicationcompatibility.html https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_en_SSEPEK-5F12.0.0_sqlref_src_tpc_db2z-5Fsql-5Fsetcurrentapplicationcompatibility.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=oIpzH2JsGen_mAZ0o7i_-9VQFVVoSR-3pe2SRoWsrbk&e=

Note that APAR PH08482 address the situation where a DDF connection is rejected if clientApplCompat at the client side does not match the APPLCOMPAT of your Db2 connect packages.

In Reply to David Simpson:
On a related note, any wisdom on how to set clientApplcompat for CLP sessions that do NOT use a gateway?

On Apr 8, 2019 1:43 PM, Mohammad Khan wrote:
Moreover, it hardly sounds like an “Aha” moment … more like an “Oh oh” moment. May be IBM can spend less time on renaming things and more on listening to users’ needs.
Khalid

From: Daniel L Luksetich
Sent: Monday, April 08, 2019 1:02 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

It’s not what other database offer, it’s what IBM is taking away from what they offered. It’s not my complaint. I’ve encouraged the customer to go direct to Db2. However, they disagree with me and it is not in the customer’s plans. I’ll see if I can make the mod to the request, but I am NOT a customer and have been told several times that I have very very little influence as to enhancements. I think I might have exaggerated that claim. I believe I meant to say next to no influence. Sorry, it must be a Monday.

Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: Jørn Thyssen mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 12:48 PM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect


Hi Dan,

I suggest you add that concern to the Aha Idea I posted earlier in this thread.



Note that you might not be stuck on FL500 forever; you might just not be able to control on an application/connection level which APPLCOMPAT you get.



BTW, out of curiosity what other databases have gateway or proxy support?

In Reply to Daniel Luksetich:
That’s one issue I guess, but I suspect most people get an enterprise license.



The other issue is when people concentrate connections through a gateway to limit IP addresses that connect to Db2. For example one of my customers has a firewall in place that extremely limits the IP addresses that can connect to Db2. There are hundreds of clients, but those clients can’t get to Db2. They have to go through the gateway. Now, we asked that the gateway be eliminated, but they do not want to open up the firewall to hundreds of IP addresses. What’s the future hold for us then? Well, we will be stuck in perpetual V12R1M500. That’s it. The customer is fine with it as their primary goal is to eliminate Db2. This actually helps their cause.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: David Simpson
Sent: Monday, April 8, 2019 10:51 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Is there not still the licensing issue? The normal Db2 client will not connect directly to z/OS data sources.



From: Jørn Thyssen <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> >
Sent: Monday, April 8, 2019 8:20 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Sorry, RFE have been replaced by Aha ideas. Here's the correct link for the request for enhancement: https://ibmanalytics.ideas.aha.io/ideas/DB2CON-I-1 https://urldefense.proofpoint.com/v2/url?u=https-3A__ibmanalytics.ideas.aha.io_ideas_DB2CON-2DI-2D1&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=cAn4aeCRUBbc6WdCEIbihKonRVCElkUuo6zCRT83R4w&e=

In Reply to Jørn Thyssen:

Hi David,



Also note that IBM have recommended direct connections over gateways for many years.
There are very few technical reasons for using a gateway -- it just adds cost (hw, sw, maintenance, operations) and latency.

There is an RFE open for adding gateway support for APPLCOMPAT: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_rfe_execute-3Fuse-5Fcase-3DviewRfe&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=yAvwJhXlxsC14tk_OOhCXadIbKHJI1fQlUF90NbZ0uY&e= https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=126019 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_rfe_execute-3Fuse-5Fcase-3DviewRfe-26CR-5FID-3D126019&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=5KmArziOIFZMwXVxfqX_JsssEN192m76In4C4A5C25o&e= &CR_ID=126019

In Reply to David Simpson:

I apologize if this has been discussed before.

Does anyone know of a concise, understandable write-up on configuring Db2 Connect for connections to Db2 12 at APPLCOMPAT levels higher than V12R1M500? Specifically when using gateway servers?

I know you need to be at very current levels of the client / gateway / JDBC driver. I have Data Studio working going directly to Db2 without a gateway, but no luck with non-JDBC connections or even JDBC connections via a gateway. The documentation I have found so far is... well it's written by IBM.

Any help would be appreciated.

_____________________________________________________________________________
David Simpson | Vice President | Themis Education
IBM Data Champion (2013-2018) | IBM Gold Consultant
PO Box 2578 * Westfield NJ * 07091 | phone 908-233-8900 | [login to unmask email]<mailto:[login to unmask email] <mailto:[login to unmask email]%3e><mailto:[login to unmask email]%3e%3e%3cmailto:[login to unmask email]%3e%3e%3e> >
For more information about Themis, visit www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e= http://www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e= http://www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e= http://www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e=
[cid:[login to unmask email] https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_intent_follow-3Foriginal-5Freferer-3Dhttps-253A-252F-252Fabout.twitter.com-252Fresources-252Fbuttons-25C2-25AEion-3Dfollow-5Flink&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=Us47rg8XbhvZejTM5KZVzfbI6arFv4e5j-bGFLNAkX0&e= https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link&screen_name=ThemisTraining&tw_p=followbutton https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_intent_follow-3Foriginal-5Freferer-3Dhttps-253A-252F-252Fabout.twitter.com-252Fresources-252Fbuttons-26region-3Dfollow-5Flink-26screen-5Fname-3DThemisTraining-26tw-5Fp-3Dfollowbutton&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=mDlGynyTwARNREd50jxunAfx0py15k-OsPctjv233QU&e= &screen_name=ThemisTraining&tw_p=followbutton
[LogoNew][cid:[login to unmask email]





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.



-----End Original Message-----



-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at
(312) 653-6000 in Illinois; (800) 447-7828 in Montana;
(800)835-8699 in New Mexico; (918)560-3500 in Oklahoma;
or (972)766-6900 in Texas.

-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 250 Bishopsgate, London EC2M 4AA. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (RBS or us) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you understand that the content of your message may be monitored.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


Visit our website at www.rbs.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rbs.com_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=DCcLh05G8AS-g7R_Cs-0tpGuSHaD-BnjffPi1owa7fM&e=
-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Raymond Bell

Db2 12 and Db2 Connect [OT]
(in response to Philip Sevetson)
Marcus, I think you reply counts too, doesn’t it?

Oh no; what have I done? :o)

(Surely it’s Friday somewhere by now?)

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 02 May 2019 17:15
To: '[login to unmask email]'
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect [OT]


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

Statement embedded in a question. Default!

From: Davage, Marcus [mailto:[login to unmask email]
Sent: Thursday, May 02, 2019 11:28 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect [OT]

That’s not fair – did you just have two goes?

Regards,
Marcus Davage
Lead Product Developer
AMI-DevOps for Db2 – SQL Performance
Direct

+44 118 921 8517

[cid:[login to unmask email]



Mobile

+44 7840 023 560



Email

[login to unmask email]<mailto:[login to unmask email]>





From: Bell, Raymond (Hosting Services, Technology) <[login to unmask email]>
Sent: 30 April 2019 13:09
To: '[login to unmask email]' <[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: Db2 12 and Db2 Connect [OT]

What game is that?

(see what I did there?)

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 30 April 2019 13:00
To: '[login to unmask email]'
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect [OT]


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************
Are you two playing the Question Game, here?
-phil (sevetson)

From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Sunday, April 28, 2019 7:12 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

This would be facilitated via currentPackageSet. Is this possible via a gateway?
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Sunday, April 28, 2019 4:17 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I believe IBM’s recommendation is to set up multiple collections with the CLI packages… one for each supported function level. You can then set the default by changing the collection you are using. This works with or without a gateway, no?

From: Daniel L Luksetich <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Sunday, April 28, 2019 7:48 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

I’m assuming you are using the NULLID packages? If so, then this solution works for a homogenous application environment only. Yes? Of course, you can also set up all the other applications to use a lower application level if needed. Unless, of course, they also go through a gateway.
Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, April 25, 2019 3:38 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

So… an update on this for those interested. We applied the fix for PH08482 (which is still warm from being baked). With VERY current versions of the client / JDBC driver we are able to connect to higher function levels without setting the ClientApplcompat. With this APAR applied it will default to the APPLCOMPAT of the client packages you are using. This seems so very common sensical that it should have always been that way ��.

This has the side effect of allowing you to continue using a Db2 Connect gateway server as long as you can take the APPLCOMPAT value from the client packages.

Many thanks Jørn for pointing me in the right direction.

From: David Simpson <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 4:25 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Cc: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

Thanks for the APAR. I'm reading it now.

When I try to run the SET CURRENT APPLICATION COMPATIBILITY in the CLP I get the -30025. Client packages are bound V12R1M503.

On Apr 8, 2019 2:29 PM, Jørn Thyssen <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi David,

SET CURRENT APPLICATION COMPATIBILITY

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/sqlref/src/tpc/db2z_sql_setcurrentapplicationcompatibility.html https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_en_SSEPEK-5F12.0.0_sqlref_src_tpc_db2z-5Fsql-5Fsetcurrentapplicationcompatibility.html&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=oIpzH2JsGen_mAZ0o7i_-9VQFVVoSR-3pe2SRoWsrbk&e=

Note that APAR PH08482 address the situation where a DDF connection is rejected if clientApplCompat at the client side does not match the APPLCOMPAT of your Db2 connect packages.

In Reply to David Simpson:
On a related note, any wisdom on how to set clientApplcompat for CLP sessions that do NOT use a gateway?

On Apr 8, 2019 1:43 PM, Mohammad Khan wrote:
Moreover, it hardly sounds like an “Aha” moment … more like an “Oh oh” moment. May be IBM can spend less time on renaming things and more on listening to users’ needs.
Khalid

From: Daniel L Luksetich
Sent: Monday, April 08, 2019 1:02 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect

It’s not what other database offer, it’s what IBM is taking away from what they offered. It’s not my complaint. I’ve encouraged the customer to go direct to Db2. However, they disagree with me and it is not in the customer’s plans. I’ll see if I can make the mod to the request, but I am NOT a customer and have been told several times that I have very very little influence as to enhancements. I think I might have exaggerated that claim. I believe I meant to say next to no influence. Sorry, it must be a Monday.

Cheers,
Dan

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IDUG DB2-L Administrator
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: Jørn Thyssen mailto:[login to unmask email]>>
Sent: Monday, April 8, 2019 12:48 PM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect


Hi Dan,

I suggest you add that concern to the Aha Idea I posted earlier in this thread.



Note that you might not be stuck on FL500 forever; you might just not be able to control on an application/connection level which APPLCOMPAT you get.



BTW, out of curiosity what other databases have gateway or proxy support?

In Reply to Daniel Luksetich:
That’s one issue I guess, but I suspect most people get an enterprise license.



The other issue is when people concentrate connections through a gateway to limit IP addresses that connect to Db2. For example one of my customers has a firewall in place that extremely limits the IP addresses that can connect to Db2. There are hundreds of clients, but those clients can’t get to Db2. They have to go through the gateway. Now, we asked that the gateway be eliminated, but they do not want to open up the firewall to hundreds of IP addresses. What’s the future hold for us then? Well, we will be stuck in perpetual V12R1M500. That’s it. The customer is fine with it as their primary goal is to eliminate Db2. This actually helps their cause.



Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: David Simpson
Sent: Monday, April 8, 2019 10:51 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Is there not still the licensing issue? The normal Db2 client will not connect directly to z/OS data sources.



From: Jørn Thyssen <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> >
Sent: Monday, April 8, 2019 8:20 AM
To: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e>
Subject: [DB2-L] - RE: Db2 12 and Db2 Connect



Sorry, RFE have been replaced by Aha ideas. Here's the correct link for the request for enhancement: https://ibmanalytics.ideas.aha.io/ideas/DB2CON-I-1 https://urldefense.proofpoint.com/v2/url?u=https-3A__ibmanalytics.ideas.aha.io_ideas_DB2CON-2DI-2D1&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=cAn4aeCRUBbc6WdCEIbihKonRVCElkUuo6zCRT83R4w&e=

In Reply to Jørn Thyssen:

Hi David,



Also note that IBM have recommended direct connections over gateways for many years.
There are very few technical reasons for using a gateway -- it just adds cost (hw, sw, maintenance, operations) and latency.

There is an RFE open for adding gateway support for APPLCOMPAT: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_rfe_execute-3Fuse-5Fcase-3DviewRfe&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=yAvwJhXlxsC14tk_OOhCXadIbKHJI1fQlUF90NbZ0uY&e= https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=126019 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_developerworks_rfe_execute-3Fuse-5Fcase-3DviewRfe-26CR-5FID-3D126019&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=5KmArziOIFZMwXVxfqX_JsssEN192m76In4C4A5C25o&e= &CR_ID=126019

In Reply to David Simpson:

I apologize if this has been discussed before.

Does anyone know of a concise, understandable write-up on configuring Db2 Connect for connections to Db2 12 at APPLCOMPAT levels higher than V12R1M500? Specifically when using gateway servers?

I know you need to be at very current levels of the client / gateway / JDBC driver. I have Data Studio working going directly to Db2 without a gateway, but no luck with non-JDBC connections or even JDBC connections via a gateway. The documentation I have found so far is... well it's written by IBM.

Any help would be appreciated.

_____________________________________________________________________________
David Simpson | Vice President | Themis Education
IBM Data Champion (2013-2018) | IBM Gold Consultant
PO Box 2578 * Westfield NJ * 07091 | phone 908-233-8900 | [login to unmask email]<mailto:[login to unmask email] <mailto:[login to unmask email]%3e><mailto:[login to unmask email]%3e%3e%3cmailto:[login to unmask email]%3e%3e%3e> >
For more information about Themis, visit www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e= http://www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e= http://www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e= http://www.themisinc.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.themisinc.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=dN9PhxZu4aNKPZP7P8smrnJADJk-TXIOq-pzGYNH0so&e=
[cid:[login to unmask email] https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_intent_follow-3Foriginal-5Freferer-3Dhttps-253A-252F-252Fabout.twitter.com-252Fresources-252Fbuttons-25C2-25AEion-3Dfollow-5Flink&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=Us47rg8XbhvZejTM5KZVzfbI6arFv4e5j-bGFLNAkX0&e= https://twitter.com/intent/follow?original_referer=https%3A%2F%2Fabout.twitter.com%2Fresources%2Fbuttons®ion=follow_link&screen_name=ThemisTraining&tw_p=followbutton https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_intent_follow-3Foriginal-5Freferer-3Dhttps-253A-252F-252Fabout.twitter.com-252Fresources-252Fbuttons-26region-3Dfollow-5Flink-26screen-5Fname-3DThemisTraining-26tw-5Fp-3Dfollowbutton&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=mDlGynyTwARNREd50jxunAfx0py15k-OsPctjv233QU&e= &screen_name=ThemisTraining&tw_p=followbutton
[LogoNew][cid:[login to unmask email]





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> <mailto:[login to unmask email]><mailto:[login to unmask email]%3e%3cmailto:[login to unmask email]%3e%3e> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.



-----End Original Message-----



-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e= http://www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at
(312) 653-6000 in Illinois; (800) 447-7828 in Montana;
(800)835-8699 in New Mexico; (918)560-3500 in Oklahoma;
or (972)766-6900 in Texas.

-----End Original Message-----





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rocketsoftware.com&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=QPoZZfcEhhPwHB762YvoDKOJj70rQ8_HP7DHLV2_VKk&e=

2019 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 250 Bishopsgate, London EC2M 4AA. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (RBS or us) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you understand that the content of your message may be monitored.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


Visit our website at www.rbs.com https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rbs.com_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=mhV0yJKfitu0qAYB_odGUoLWNP8v4L54s7lNo_VjYxo&m=i36pPIfRDD3rCaQO7vUCAGeZAXToH4NuvgGYQh11c_o&s=DCcLh05G8AS-g7R_Cs-0tpGuSHaD-BnjffPi1owa7fM&e=
-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (RBS or us) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you understand that the content of your message may be monitored.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com