DB2 - L

Expand all | Collapse all

Db2 Connect vs z/OS Connect

  • 1.  Db2 Connect vs z/OS Connect

    Posted Sep 14, 2021 11:34 AM
    what are the differences, advantages and disadvantages to Db2 Connect vs z/OS Connect?
    My understanding is that z/OS Connect is IBM's current direction. And that it enables all types of connections and the Enterprise Edition support RESTful APIs.
    On the distributed side would the implementation be different for each of these?
    thanks
    Bill

    ------------------------------
    williamgiannelliMe
    ------------------------------


  • 2.  RE: Db2 Connect vs z/OS Connect

    Posted Sep 14, 2021 03:22 PM
    Hi Bill,

    z/OS Connect is for REST APIs.
    Db2 Connect is for communication to Db2 for z/OS over DRDA. Typical use cases is Java applications using JDBC or applications using ODBC. 

    They are really two different products for different use cases. I see them co-exist rather than one replacing the other, unless you want to do a costly rewrite of all our distributed applications.

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 3.  RE: Db2 Connect vs z/OS Connect

    Posted Sep 16, 2021 10:33 AM
    Hi Bill.  
    I agree with Jørn and his high level summary.  
    Although, I would add that you do not need z/OS connect to use a Db2 REST API.  I managed to create and use Db2 REST API without z/OS connect.  Once everything is setup and configured for the first. Then they are easy to create and use!

    I think z/OS connect allows you to create REST API for DB2 and all other systems within z/OS.  So it allows a super-set of capabilities.

    regards
    Brian Laube



    ------------------------------
    Brian Laube Manulife Financial

    Db2 Z DBA (mostly)
    ------------------------------



  • 4.  RE: Db2 Connect vs z/OS Connect

    Posted Sep 16, 2021 10:57 AM

    Brian's right; you don't need z/OS Connect to deploy and invoke Db2 REST services.  We've got loads (well, a dozen or so) and they work fine without it thankyouverymuch.

     

    What it does provide is the standard API interfaces into REST service calls for stuff like GET, PUT, POST and.. whatever the other one is.  Db2's REST service implementation is a little... proprietary and non-standard so if you want those calls to work the way Developers expect them to, z/OS Connect is the way to go.

     

    Of course, one could be forgiven for thinking Db2's implementation is non-standard to encourage you to buy z/OS Connect.  You might think that; I couldn't possibly comment.

     

    Cheers,

     

     

    Raymond

     






  • 5.  RE: Db2 Connect vs z/OS Connect

    Posted Sep 16, 2021 11:19 AM
    Hi Raymond,

    The last one is PATCH :)

    It is very strange you issue a POST to SELECT data. Normally that would be a GET...

    However, I recently learned that GET have potential security exposures. Let's say you write a query to retrieve transactions GET /transactions?cc=nnnnnnnn . The information is obviously sent encrypted (you are using SECPORT, right?!), but some tools might write the URL into logs which now contain sensitive data (cc=nnnnnnn).   If you're using POST instead, you end up doing a POST /transactions with body: { cc: nnnnnnn }, so no sensitive data in the URL.

    On the other hand, there is no security concerns for GET /exchange_rates?currency=BRU  (BRU is "British rubles") as the parameter is not considered sensitive data.

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 6.  RE: Db2 Connect vs z/OS Connect

    Posted Sep 17, 2021 03:52 AM

    Ah, I was thinking of the Four Musketeers of GET, PUT, POST and DELETE.  Not heard of PATCH; another one Db2 doesn't support.  ��

     

    Yeah, we've gone down the SECPORT route.  Unsecured in trials just to prove it works then swallowed the whole certificates thing.  Not something I understand TBH but I don't have to; that's Encryption Servies' job, fortunately.

     

    Will put aside a few BRUs to blow together at a pub some time – assuming they're still worth anything by then.  I discovered one NZD now buys 51p.  In my day it was closer to 20p.  Typical, now I have (relatively) more pounds than dollars.

     

    Cheers,

     

     

    Raymond

     

     






  • 7.  RE: Db2 Connect vs z/OS Connect

    Posted Sep 17, 2021 06:31 AM
    Well, there were actually 2 unmentioned.  The last, last one is DELETE.





  • 8.  RE: Db2 Connect vs z/OS Connect

    Posted Sep 23, 2021 09:30 AM
    and what is "z/OS Appl Connect DB2"?

    ------------------------------
    williamgiannelliMe
    ------------------------------



  • 9.  RE: Db2 Connect vs z/OS Connect

    Posted Sep 23, 2021 10:16 AM

    "z/OS Application Connectivity to Db2 for z/OS" is the z/OS equivalent of the "IBM Data Server Driver for JDBC and SQLJ (JCC) Driver" package. That is, the JDBC drivers needed to connect to Db2 for z/OS from an java application running under z/OS: standalone, Java in CICS, Websphere, Liberty, etc. No license required.



    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 10.  RE: Db2 Connect vs z/OS Connect

    Posted Oct 01, 2021 03:44 PM
    In order to install and configure Db2 Connect, is there any thing installed on z/OS? Or only on the distributed side?
    thanks
    Bill

    ------------------------------
    williamgiannelliMe
    ------------------------------



  • 11.  RE: Db2 Connect vs z/OS Connect

    Posted Oct 01, 2021 04:15 PM
    Hi Bill,

    Db2 Connect is a set of drivers on the client side.
    On the z/OS side you have a number of packages bound in Db2 and license If you have Db2 Connect unlimited enterprise. For other variations of Db2 Connect you'll have to install the license on the client side. 

    You can also have a Db2 Connect gateway on distributed platform, but I recommend against that for many reasons.


    FWIW, z/OS Connect does have a component on z/OS, but it is java so offloaded to zIIP if you have available capacity.

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 12.  RE: Db2 Connect vs z/OS Connect

    Posted Oct 01, 2021 10:01 PM
    Just to round this out: the packages that are bound in Db2 z/OS are provided by Db2
    Connect. Part of the first client installation is to bind them into the z/OS side
    https://www.ibm.com/docs/en/db2/11.1?topic=pack-binding-bind-files-after-installing-fix-pack
    s
    (step 4)


    The default collection for them is NULLID. If you have clients that are Db2 Connect 11.1 fp0
    or earlier things get a bit messy - because they cannot connect to packages bound in
    APPLCOMPAT V12R1M501 or later (and hence cannot use later SQL). So you end up with
    - NULLID - packages that support SQL up to V12R1M500
    - NULLID_???? (NULLID_V12R1M500 seems to be the supplied default) which are bound at higher levels but are only accessible from Db2 Connect 11.1 fp1 and later.

    https://www.ibm.com/docs/en/db2-for-zos/12?topic=aclid-v12r1mnnn-application-compatibilit
    y-levels-data-server-clients-drivers

    And Db2 Connect Unlimited Edition does come with a license file that can be installed on the
    client side.


    James Campbell


    On 1 Oct 2021 at 20:14, Thyssen via International DB2 wrote:

    > Hi Bill,
    >
    > Db2 Connect is a set of drivers on the client side.
    > On the z/OS side you have a number of packages bound in Db2 and license If you have Db2 Connect unlimited enterprise. For other variations of Db2 Connect you'll have to install the license on the client side.
    >
    > You can also have a Db2 Connect gateway on distributed platform, but I recommend against that for many reasons.
    >
    >
    > FWIW, z/OS Connect does have a component on z/OS, but it is java so offloaded to zIIP if you have available capacity.
    >
    > ------------------------------
    > Jørn Thyssen
    > Rocket Software
    > 2021 IBM Champion
    > ------------------------------
    > -------------------------------------------
    > Original Message:
    > Sent: Oct 01, 2021 03:44 PM
    > From: william giannelli
    > Subject: Db2 Connect vs z/OS Connect
    >
    > In order to install and configure Db2 Connect, is there any thing installed on z/OS? Or only on the distributed side?
    > thanks
    > Bill
    >
    > ------------------------------
    > williamgiannelliMe
    > ------------------------------
    >
    > Original Message:
    > Sent: Sep 23, 2021 10:15 AM
    > From: Jørn Thyssen
    > Subject: Db2 Connect vs z/OS Connect
    >
    > "z/OS Application Connectivity to Db2 for z/OS" is the z/OS equivalent of the "IBM Data Server Driver for JDBC and SQLJ (JCC) Driver" package. That is, the JDBC drivers needed to connect to Db2 for z/OS from an java application running under z/OS: standalone, Java in CICS, Websphere, Liberty, etc. No license required.
    >
    >
    >
    > ------------------------------
    > Jørn Thyssen
    > Rocket Software
    > 2021 IBM Champion
    >
    > Original Message:
    > Sent: Sep 23, 2021 09:29 AM
    > From: william giannelli
    > Subject: Db2 Connect vs z/OS Connect
    >
    > and what is "z/OS Appl Connect DB2"?
    >
    > ------------------------------
    > williamgiannelliMe
    >
    > Original Message:
    > Sent: Sep 17, 2021 06:30 AM
    > From: Patrick Bossman
    > Subject: Db2 Connect vs z/OS Connect
    >
    > Well, there were actually 2 unmentioned. The last, last one is DELETE.
    >
    >
    > Original Message:
    > Sent: 9/16/2021 11:19:00 AM
    > From: Jørn Thyssen
    > Subject: RE: Db2 Connect vs z/OS Connect
    >
    > Hi Raymond,
    >
    > The last one is PATCH :)
    >
    > It is very strange you issue a POST to SELECT data. Normally that would be a GET...
    >
    > However, I recently learned that GET have potential security exposures. Let's say you write a query to retrieve transactions GET /transactions?cc=nnnnnnnn . The information is obviously sent encrypted (you are using SECPORT, right?!), but some tools might write the URL into logs which now contain sensitive data (cc=nnnnnnn). If you're using POST instead, you end up doing a POST /transactions with body: { cc: nnnnnnn }, so no sensitive data in the URL.
    >
    > On the other hand, there is no security concerns for GET /exchange_rates?currency=BRU (BRU is "British rubles") as the parameter is not considered sensitive data.
    >
    > ------------------------------
    > Jørn Thyssen
    > Rocket Software
    > 2021 IBM Champion
    >
    > Original Message:
    > Sent: Sep 16, 2021 10:56 AM
    > From: Raymond Bell
    > Subject: Db2 Connect vs z/OS Connect
    >
    > Brian's right; you don't need z/OS Connect to deploy and invoke Db2 REST services. We've got loads (well, a dozen or so) and they work fine without it thankyouverymuch.
    >
    > What it does provide is the standard API interfaces into REST service calls for stuff like GET, PUT, POST and.. whatever the other one is. Db2's REST service implementation is a little... proprietary and non-standard so if you want those calls to work the way Developers expect them to, z/OS Connect is the way to go.
    >
    > Of course, one could be forgiven for thinking Db2's implementation is non-standard to encourage you to buy z/OS Connect. You might think that; I couldn't possibly comment.
    >
    > Cheers,
    >
    >
    > Raymond
    >
    >
    >
    >
    > Original Message:
    > Sent: 9/16/2021 10:33:00 AM
    > From: Brian Laube
    > Subject: RE: Db2 Connect vs z/OS Connect
    >
    > Hi Bill.
    > I agree with Jørn and his high level summary.
    > Although, I would add that you do not need z/OS connect to use a Db2 REST API. I managed to create and use Db2 REST API without z/OS connect. Once everything is setup and configured for the first. Then they are easy to create and use!
    >
    > I think z/OS connect allows you to create REST API for DB2 and all other systems within z/OS. So it allows a super-set of capabilities.
    >
    > regards
    > Brian Laube
    >
    >
    >
    > ------------------------------
    > Brian Laube Manulife Financial
    >
    > Db2 Z DBA (mostly)
    >
    > Original Message:
    > Sent: Sep 14, 2021 03:21 PM
    > From: Jørn Thyssen
    > Subject: Db2 Connect vs z/OS Connect
    >
    > Hi Bill,
    >
    > z/OS Connect is for REST APIs.
    > Db2 Connect is for communication to Db2 for z/OS over DRDA. Typical use cases is Java applications using JDBC or applications using ODBC.
    >
    > They are really two different products for different use cases. I see them co-exist rather than one replacing the other, unless you want to do a costly rewrite of all our distributed applications.
    >
    > ------------------------------
    > Jørn Thyssen
    > Rocket Software
    > 2021 IBM Champion
    >
    > Original Message:
    > Sent: Sep 14, 2021 11:34 AM
    > From: william giannelli
    > Subject: Db2 Connect vs z/OS Connect
    >
    > what are the differences, advantages and disadvantages to Db2 Connect vs z/OS Connect?
    > My understanding is that z/OS Connect is IBM's current direction. And that it enables all types of connections and the Enterprise Edition support RESTful APIs.
    > On the distributed side would the implementation be different for each of these?
    > thanks
    > Bill
    >
    > ------------------------------
    > williamgiannelliMe
    > ------------------------------
    >
    >
    > Reply to Sender : https://www.idug.org/eGroups/PostReply/?GroupId=253&MID=172638&SenderKey=d2290d58-7d82-4255-b2e2-51b27f7b9722&MDATE=7576465456&UserKey=0e114382-b62d-4df5-8bae-216292fc0091&sKey=KeyRemoved
    >
    > Reply to Discussion : https://www.idug.org/eGroups/PostReply/?GroupId=253&MID=172638&MDATE=7576465456&UserKey=0e114382-b62d-4df5-8bae-216292fc0091&sKey=KeyRemoved
    >
    >
    >
    > You are subscribed to "DB2 - L" as jacampbellaus@gmail.com. To change your subscriptions, go to http://www.idug.org/preferences?section=Subscriptions&MDATE=7576465456&UserKey=0e114382-b62d-4df5-8bae-216292fc0091&sKey=KeyRemoved. To unsubscribe from this community discussion, go to http://www.idug.org/HigherLogic/eGroups/Unsubscribe.aspx?UserKey=0e114382-b62d-4df5-8bae-216292fc0091&sKey=KeyRemoved&GroupKey=37484667-8556-4529-8eb2-a1404f7c5c5f.



    --
    This email has been checked for viruses by AVG.
    https://www.avg.com