Db2 Tools for zOS

 View Only

  • 1.  Are the Visual Studio Code Plugins dead by design?

    Posted Thu December 19, 2024 08:59 AM

    We used the IBM Db2 Data Studio to have a more open interface for Client related people to work with our DB2.

    Now with DB2 v13 Data Studio isnt supported anymore and the replacement which is a Visual Studio Code Plugin requires a DB2 Data Server Client License/DB2 Connect we dont have. 

    In 2024 i really cannot explain anyone why we have to pay an extra fee to access our DB2 from common Client applications. Oracle, Postgres ... every other competitor allows developers to access from their SQL Tools. Not only tools, also from productive application servers. Hey, we live in a non-monolith world.

    Anyone can give me a hint, how to explain anyone outside the Mainframe Bubble why we have to pay a lot of extra money for accessing our data per JDBC/ODBC?



    ------------------------------
    Christian Frieben
    ------------------------------


  • 2.  RE: Are the Visual Studio Code Plugins dead by design?

    Posted Fri December 20, 2024 05:44 PM
    First in order to connect to Zos from a client you have always had to have a DB2 Connect license. This is nothing new and is not changing in DB2 Zos 13.

    Many other tools non IBM will still connect to DB2 13.

    Datastuido will work as long as you are on have not gone to DB2 13 500 or higher .
    DS breaks because of the catalog changes that DB2 13 500. But some parts will still work.

    Sent from my iPhone


    Original Message


  • 3.  RE: Are the Visual Studio Code Plugins dead by design?

    Posted Sat December 21, 2024 08:04 AM

    How can organizations justify the additional cost of a DB2 Data Server Client License or DB2 Connect for accessing DB2 v13 data via JDBC/ODBC, especially when competing platforms like Oracle and Postgres allow free access through common client applications?



    ------------------------------
    james colin
    ------------------------------

    Original Message


  • 4.  RE: Are the Visual Studio Code Plugins dead by design?

    Posted Mon December 30, 2024 10:10 AM

    James,

    Another thread on IBM Data Studio you may want to review...

    https://community.ibm.com/community/user/datamanagement/discussion/open-source-ibm-data-studio#bmdba899b9-7837-47b3-bf3d-c5525e9ff4b1


    Was going to mention that IBM could make Data Studio Open Source...

    One of the comments is Spot On - For Open Source to thrive - someone has to be a Champion and support the blasted thing!   
     



    ------------------------------
    Steve Able
    Director of Strategy and Architecture
    Adaptigent formally GT Software, Inc.
    ☠
    ------------------------------

    Original Message


  • 5.  RE: Are the Visual Studio Code Plugins dead by design?

    Posted Tue January 07, 2025 07:13 AM

    Thats the point.

    No one can explain why someone needs to pay an extra fee for JDBC/ODBC. That IBM wasnt able to include this in the DB2 z/OS core package as a license (the binaries including the license files are still there since decades) only shows their sales are beyond reality. This is how you can blame a good, reliable, cost efficient on-prem plattform in times where resilience has a rising value for companies.



    ------------------------------
    Christian Frieben
    ------------------------------

    Original Message


  • 6.  RE: Are the Visual Studio Code Plugins dead by design?

    Posted Mon December 30, 2024 09:34 AM

    Agree about the Db2 Client Drivers - you would think that it would be better to encourage as much Client access as possible - helps drive MSU usage even though client driver access to Db2 on IBM z is offloaded to specialty engines when possible. 

    It is Very Sad when companies do not keep their software current. The old IBM Data Studio was (well is still) a great tool - used it with IBM Db2 on z and LUW as well as Oracle, SQL Server, Sybase, Postgres, and several other data base client drivers.


    VS Code and API(s) is the IBM and other ISV(s) Strategic Direction, but this new support is not always as vibrant as what IBM Data Studio provided.

    All because of the $$$ cost to maintain a great tool like IBM Data Studio is being tossed to the side and allowed to die and rot all because there is not any profit from Free Software!

    May wany to check with your IBM Z Db2 group - because - if you had the Db2 License jar for the older versions of Db2 on IBM z for IBM Data Studio most likely they can provide you with the Db2 License jar file for the newer version. 
     
    Good luck!

    BTW - The Open Source SQuirreL (http://www.squirrelsql.org/) Tooling for JDBC Drivers is fairly good - not as good as IBM Data Studio - but fairly easy to use!
    But - LOL - U will still need the License Jar with the IBM Db2 JDBC Driver to access IBM z!
       


           
            



    ------------------------------
    Steve Able
    Director of Strategy and Architecture
    Adaptigent formally GT Software, Inc.
    ☠
    ------------------------------

    Original Message