DB2 - L

Expand all | Collapse all

Db2 Connect vs z/OS Connect

  • 1.  Db2 Connect vs z/OS Connect

    Posted 9 days ago
    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 9 days ago
    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 7 days ago
    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 7 days ago

    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 7 days ago
    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 7 days ago

    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 6 days ago
    Well, there were actually 2 unmentioned.  The last, last one is DELETE.





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

    Posted 19 hours ago
    and what is "z/OS Appl Connect DB2"?

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



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

    Posted 18 hours ago

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